temporary table in ssrs

Temporary table does not work with SSRS 2005 & 2008?.Is there any ways to overcome this difficulty?. Thanks in advance.. Regards, pvn.

asked Sep 01 '11 at 08:32 PM in Default

nidheesh
90 ● 6 ● 10 ● 12

(comments are locked)

2 answers:

When I have more complex needs within SSRS I typically put the logic into a stored procedure and call the store procedure within the SSRS Report. I create variables for my end users to enter that get passed to the sproc. So far it has worked well for me.

answered Sep 01 '11 at 08:35 PM

Tim
31.5k ● 20 ● 31 ● 116

Where I work I recommend using stored procedures as the default method of providing data to a report data source.

Oh, and many congrats on getting to the 20k karma level. Thanks for bringing your experience and skills to the forum.

Sep 02 '11 at 05:34 AM Fatherjack ♦♦

Thanks @Fatherjack, it has been a lot of fun and education getting this far. I still say I have gotten more out of participating on this site than I have contributed. AskSSC is simply the best.

Sep 02 '11 at 10:20 AM Tim

(comments are locked)

Depends how you would like to use the temp tables. If you would like to use it in subsequent Execute SQL Task or in scripts, there is no problem to use the temp tables. The only problem comes with Data Flow, if you would like to use it as source or destination.

To allow use a temp table among several executables you have to set RetainSameConnetion = True on the connection so the same connection is retained between executables. Otherwise each executable starts it's own connection and the temp table is gone.

answered Sep 02 '11 at 03:41 AM