Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Report shows no data with certain parameters but stored procedure does Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 2:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2014 1:46 PM
Points: 3, Visits: 92
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!

Kathy Goad
Post #1419190
Posted Thursday, February 21, 2013 2:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:03 AM
Points: 94, Visits: 452
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! :)
Post #1422463
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse