Over the summer, another staff member at my organization wrote a report using SSRS for a project I'm currently working on. We tested the report together, everything looked great, he deployed it and set everything up in production. Now he's gone, and the time has come for me to start using the report. For some reason, even though I'm running the report using a list of ~30K households, it's only returning 2 pages of a report. When I use other large lists, I see the same issue -- I get two pages of the report, but that's it.
I'm wondering if anyone has any thoughts on why this might be happening. This coworker had a lot more SQL & SSRS experience than I do, and I'm afraid I'm missing something obvious.
Thanks in advance for any thoughts!
Hi Jonathan,
Try looking for this in the SQL:
SELECT TOP n column-name
FROM table-name
Where n is a number - that will restrict the report to that number of rows. Folks will often do this in test to make sure the SQL works as they expect and doesn't kill performance of the system.
Susan
Hi Susan -- thanks so much! That was exactly it. Problem solved, I'm off to the races. (And it wasn't even hard to find in the SQL...it was basically staring me in the face.)
Thanks again for your help!