September 6, 2011 at 1:06 pm
Hello -
I'm self taught on SSRS 2008 so bear with me. I created a report to simply display all the rows of my database table (Project Tracker). I have my header row and one row of dataset elements, however when I run the report it only displays one row. Please advise!
Thanks,
Nate
N. Heard
September 6, 2011 at 1:32 pm
Did you do simple select to test if there is data in Database??? or run the query you used to generate the report in managemnt studio and see if it is returning any data.
thanks,
Komal
September 6, 2011 at 2:52 pm
I did conduct a test query, returned all my results. Verified via SSMS that the data is populated as I expected.
N. Heard
September 6, 2011 at 4:17 pm
Problem solved! Case of the wizard doing to much work. Thanks all.
N. Heard
September 6, 2011 at 5:15 pm
Nate Heard (9/6/2011)
Problem solved! Case of the wizard doing to much work. Thanks all.
Presuming the issue was that there was a grouping issue in the report. Is that correct?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2011 at 1:49 pm
I agree, there was a grouping issue in the report.
Plenty people copy a report, rename it, use it. This sometimes causes problems because its like the cache of report copied is still pointing to original report layout. If you delete the tablix (table or matrix), re-create it you will find all rows are now displayed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply