Report rows differ from SQL result

views:

answers:

+1 Q:

Report rows differ from SQL result

I am stumped.

I have a select statement that returns the data fine in the data pane, but in the resulting report, one row is our of sort order and falls about 25 rows down in the data where it shouldn't be.

How do I trouble shoot something like that?

Thanks!i

+1 A:

How do I trouble shoot something like that?

You start by posting the select statement here so we can help without having to hone our psychic debugging skills :-)

It's possible that you're not ordering on every column you think you are. It's also possible that SSRS re-orders the data even after you've retrieved it.

They'd be the first two places I'd look.

paxdiablo 2010-09-15 01:57:16

The key thing is that when I execute the SQL in the data pane, it returns everything properly sorted on 3 columns. I can scroll through it, and it's all fine. The report has that one row out of place, and I can't see anything special about that row. Thanks for the suggestion.

Glenn 2010-09-15 02:12:51

+5 A:

Somewhere in the report you must be sorting the dataset. In this case, the data will look fine in the data pane but will be out of the expected order in the report. Try adding a brand new table to the report and apply the dataset. It should match the data pane.

Alison 2010-09-15 02:03:13

Thanks, I will try that! I DID reuse this report from an existing report and I bet there is sorting in it...I did look but couldn't remember where that sorting would be found. It has been a long while since the original report was done.

Glenn 2010-09-15 02:14:09

+1: That was going to be my suggestion. If things are still weird, refresh the dataset by going to the **Data** tab, selecting the dataset from the drop down (if there's more than one), and click the refresh button to the left of the dropdown (it's tiny, looks like a recycling logo)

OMG Ponies 2010-09-15 02:17:38

New table. That did the trick! Thanks. I wonder where the grouping was? In the future I'd like to just find it and change it.

Glenn 2010-09-15 02:33:17

Try right-clicking on the table and select properties. In the resulting window, there should be sorting and grouping tabs (I don't have SSRS open right now so I can't remember exactly.). The source of the incorrectly ordered data should be somewhere in there.

Alison 2010-09-15 02:37:59

Thanks, Alison. I will take a look!

Glenn 2010-09-15 02:56:54

ansaurus

tags:

views:

answers:

Report rows differ from SQL result

related questions