June 5, 2009 at 7:56 am
Hi,
My Case we have to only write queries to build reports. So i used only Dynamic Sql to get the requirement done. My Dynamic Sql code extends to around 500 lines. As and when i paste the total sql into Dataset's query area and try to refresh then the Visual Studio gets hung .
Please help me in overcomming this .....
anyone....
June 5, 2009 at 8:20 am
The probability of you running a 500 line monster in VS instead of SMS as stored procedure is very limited because when code is stored procedure it is controlled by the relational engine instead of SSRS. So most complex reports are run from stored procedure instead of plain .sql code.
This is where you find a conference room and design the report, create a view and write stored procedure because when you do the design work the code gets very small.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply