July 2, 2010 at 2:20 pm
I'm new to Reporting Services and I'm working on a new SSRS report project in the VS2005 report designer. I have a simple report that needs to print 10 rows. My Dataset query returns 10 rows when I click the run "!" button. However when I go to the "Preview" tab, I only see data on the report from the last row in the result set. It behaves as though I'm using the "=Last()" qualifier in my text box value as in ... "=Last(Fields!Last_Name.Value)". I am not using =Last(). How can I get get my report to show all ten rows? There must be something very simple and basic that I am missing.
Thanks for any advice. 🙂
July 4, 2010 at 12:05 am
Which control you are using to display the data?
July 6, 2010 at 2:27 pm
Sounds like you may have just dropped a bunch of text boxes on your report form. Without wrapping them in somethign that will generate the rows for you you'll only get one row of data. Either a matrix or table will probably be the best way to go for you and also the easiest to set up. OR you could walk through the wizard to see what it comes up with for you as an example and then see how that it did differs from yours...
-Luke.
July 7, 2010 at 6:17 am
I was dropping some text boxes on the report designer surface and was expecting to see rows print. I'm now wrapping my textboxes in a List control and it's working just fine. I didn't realize I had to have a container - such as a table or list control in order to get all rows to print. Thanks for the help.
July 7, 2010 at 6:23 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply