May 30, 2012 at 2:47 pm
Current:
I have an MS OLE DB connector for DB2 and is working in that I am able to connect on the AS400 DB2 database and create sprocs using views and apply them in Visual Studio for SSRS.
Everything was going well and I was testing the data in SSRS, the datasets were creating and when I previewed the report all the data was there and was working as anticipated.
The problem:
When I add parameters to the sproc on DB2 and reapply the sproc to SSRS the parameters are created but the column and data are not there.
What do I need to do to correct this problem and make the parameters & dataset work appropriately.
Thanks ahead of time for your efforts.
May 31, 2012 at 7:12 am
I wrote a blog about this when using dynamic SQL Server queries that may help. Also there were several comments at the bottom of the blog that offered alternatives that you may also find useful.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply