Report query retreives no data in Report Builder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Report query retreives no data in Report...

Report query retreives no data in Report Builder

Rate Topic

Display Mode

Topic Options

Author

Message

Bahmudales

Posted Thursday, February 07, 2013 6:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:49 AM
Points: 2, Visits: 19

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

mikehunsaker

Posted Wednesday, March 20, 2013 6:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:32 AM
Points: 26, Visits: 178

Did you figure this out? I am curious to know what happened.

Mike

Post #1433174

Steven.Howes

Posted Wednesday, March 27, 2013 12:32 PM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 3:09 PM
Points: 374, Visits: 1,681

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 »

Permissions