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

Report query retreives no data in Report Builder Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 6:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:55 PM
Points: 4, Visits: 39
Hi all,

I try to create a new report and I have the following problem: The query defined works great in SQL Management Studio(MS) but retrieves no data in SQL Report Builder(RB) 2.0. I run the query in RB without any parameters and the result was the same: no data returned. I use the same data source for both MS and RB.

Has anyone faced this problem before?

Thanks in advance.

Post #1417032
Posted Wednesday, March 20, 2013 6:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 11:31 AM
Points: 26, Visits: 180
Did you figure this out? I am curious to know what happened.

Mike
Post #1433174
Posted Wednesday, March 27, 2013 12:32 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 10:42 AM
Points: 593, Visits: 2,110
if you right click the dataset and choose QUERY, you can see what is returned by the query. If you get nothing there, then I'd check your datasource to make sure everything is right.

Failing that I'd use profiler to listen and try to catch the query to see exactly what is passed to the DB engine.
Post #1436095
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse