Post reply

Report query retreives no data in Report Builder

  • February 7, 2013 at 6:18 am

    #273924

    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.

  • March 20, 2013 at 6:32 am

    #1598865

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

    Mike

  • March 27, 2013 at 12:32 pm

    #1601311

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply