February 12, 2013 at 2:28 pm
I have a SSRS 2008 Reporting Services report that returns no data with certain parameters.
The report parameters consist of strings that are parsed and used as parameters in the stored procedure. One of the strings is a list of company ids. One of the Companies does not have any data other than company data. I can run the stored procedure through management studio and get 115,616 rows. But when I run the report with the same parameters, I get no data and the report is blank.
If the Company that doesn't have any data is excluded, the report will contain data. Anyone have any idea why the report would come back blank when there is data from the stored procedure?
Kathy Goad
February 21, 2013 at 2:55 am
I'm currently investigating a report under similiar circumstances. It works perfect in Visual Studio 2008 but after it's been deployed to SSRS the new parameter I added fails to return any data when populated and even returns 'Arithmetic Overflow' errors when certain values are used.
The best advice I've received so far is to run SQL Profiler on the source database and examine the differences in the query executed between SSRS and VS2008.
Hope this helps, if I find anything further then I'll certainly try to remember to post here! 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply