question

lms0033 avatar image
lms0033 asked

Temp tables with reporting services 2008

I am teaching myself Reporting Services 2008 and I am unable to get any of my Temp Tables to work. I apologize if this has been asked before, but is there a way to do this?
ssrs-2008temporary-table
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
You may need to expand on your question to give us more of an idea of what you are doing and what you want to achieve. The best way to create reports is to write a stored procedure to gather the data that you want to report on and then create your report based on the stored procedure. If your procedure works with any temp tables then they will be created and destroyed as the procedure gets called by the report. There should be no issues, it is something that I have many reports doing.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.