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?
If all else fails, head for the beach!