Please help if you can.
I have been building reports in .Net to deploy to SSRS and usually after running the sp passing through parameters data is returned but no fields in the field section on the left hand side of the screen. Now usually I hit the refresh button and they appear. With this report the refresh button is doing nothing and I can not move on to doing the layout.
I am not sure if it has something to do with the sp as this is the first time I am using an sp that has dynamic sql in it. Would the dynamic sql be causing my problems?
Any help would really be appreciated.