Temp Tables in Simulsoft Report

Tom7 · Post by **Tom7** » Fri Jun 11, 2010 7:24 am

Hi All

Is there any way of being able to create a Temp Table from within the SQL in a Stimulsoft Report, with SQL Syntax such as CREATE TABLE ##Temp

I need add columns to a temp table based on the results of another SQL query, and have it working perfectly in SQL Management Studio, but when out into the SQL area of Stimulsoft I get an error on the Temp Table

I cannot use DECLARE @Temp TABLE.... syntax as with this type of table variable, I was having trouble adding columns to it using ALTER TABLE @Temp ADD NewColumnName VARCHAR(100)

Anyone any ideas?

Post by **Jan** » Mon Jun 14, 2010 12:43 am

Hello,

Sql data source based on standard ADO.Net sql query. For MS SQL database we use standard SqlDataAdapter class. All queries which accept this class, will be accepted by our product. Also i need specify that we use SelectCommand property of this class. If you need run something more you can use code similar to

http://social.msdn.microsoft.com/forums ... 27e970f31/

in one of event of report. For example in BeginRenderEvent of report.

Thank you.

Hessam8008 · Post by **Hessam8008** » Sun Jul 05, 2015 2:57 am

Hello,
I have same problem. Temp tables are used in stored procedures and work properly with "SqlDataAdapter", however, when It calls by StimulReport, an error occurred that refers to the temp table!!
I do not know why StimulReport checks stored procedure's syntax while SQL has accepted that procedure !?

Thank you.

Post by **Alex K.** » Mon Jul 06, 2015 6:46 am

Hello,

Please clarify which version you are use?
Also please check the last build, we made some improvements and checks in that direction.

Thank you.

Hessam8008 · Post by **Hessam8008** » Tue Jul 07, 2015 8:27 am

Hello,

I use Stimulsoft Reports.Net version 2015.1 and Visual studio 2010.
You are right. It is related to TableAdapter Configuration. So, I added below code after 'AS' in stored procedure and solve the problem

IF 1=0 BEGIN
SET FMTONLY OFF
END

Thank you.

Post by **HighAley** » Tue Jul 07, 2015 11:53 am

Hello.

We are glad to help you.
Let us know if you need any additional help.

Thank you.

Hessam8008 · Post by **Hessam8008** » Wed Jul 08, 2015 5:07 am

Hello,

That's kind of you.

Thank you.

Post by **Alex K.** » Wed Jul 08, 2015 11:08 am

Hello,

Let us know if you need any additional help.

Thank you.