December 23, 2010 at 1:16 pm
I'm building a report that requires the records to be displayed one per page. I've been trying to figure out how to force the data to go to a new page for each record and have not been able to figure this out. I think so far the closest that I've been was when using a List and have the default row group "Details" set to group on one of field values. I expected this to push each record to a new page but it's not.
Can anyone tell me how I can make one record show up per page, unless the data for the record causes a field to push the data into another page?
December 23, 2010 at 1:21 pm
How about adding a group that is based on a field that's unique within all records, and using that group to create a page break between each group? If nothing else, adding a field to the recordset that's just RowNumber() should be sufficient if there are no unique fields.
Steve
(aka sgmunson)
:-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 28, 2010 at 12:23 pm
I currently have the default group (Details) grouping on the field FullName which is unique and I have Page Break set to "Between each instance of a group". I have 3 records and I get 3 pages but each page is displaying the same record instead of the next record. I have no idea why it's not showing a new record for each new page.
Any ideas?
December 28, 2010 at 12:58 pm
It seems as though the only way I can get any per page grouping to work is if I have a column group. When I have a column on the left and I group it the field in it then the data in the left column changes per page but the data in the body of the list still does not.
I must be missing something really simple here but I just don't know what.
December 28, 2010 at 4:03 pm
I'm thinking you have the fields set to display on the GROUP line as opposed to the detail line within the tablix... Take a closer look at your tablix, and update here with the results.
Steve
(aka sgmunson)
:-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 28, 2010 at 5:17 pm
OK, I'm starting over. I just cute all my fields out of the content area of the list. I then deleted the list and have re-created a new one and pasted the fields back into the content area.
I now have one Row Group called Details. If I go to the Group Properties page for Details then I see where I can enter a Group Expression. There is also a Page Breaks page that currently does not have anything checked.
I just set the dataset to the one that is already setup in the project. Now in the Details Group Properties page I have set the Group Expression to the field that I want to create each new page. If I run this I still get the same data on each of the three pages. The correct number of pages are being created but the data is the same on every page. How do I get it to show a different record per page?
December 28, 2010 at 5:53 pm
Assuming you have your detail fields on the detail line, then the next critical step is to ensure that your data actually has a different group value for the grouping field for each of the 3 records in the table or view or stored procedure result set that feeds your dataset. If that's ok, then it may mean you'll need to zip up the RDL file for your report and attach it to your next post. What version of SSRS are you using?
Steve
(aka sgmunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 28, 2010 at 6:07 pm
How can I check or know that the fields are on the detail line? I only have the one container for the fields which I'm assuming must be the detail line.
I'm out for the day and will check back in tomorrow. Thanks.
December 28, 2010 at 7:39 pm
Post a screen-shot of your report in design mode - I presume you're using BIDS... Worst case you can zip up the RDL file for the report and attach it to a post.
Steve
(aka sgmunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 29, 2010 at 1:57 pm
OK, I new this was something easy. I created a new test report with a different data source and it worked the first try.
So I went back into my report and found that all my data expressions where like this. First(Fields!CreatedDate.Value, "DataSet1")
So I changed it to =Fields!CreatedDate.Value and that solved my problem.
Now I understand what I was doing wrong. Thank you so much for the help, it did lead me in the right direction.
December 29, 2010 at 9:10 pm
Glad to be of service. I definitely enjoy it when I need help and while I find the problem myself, someone else helps me go in the right direction because I just need a sounding board / 2nd set of eyes....
I've been having much more complex grief with SSRS lately - from discovering a known bug where the "collected tooltip" for a pie chart "collected slice" doesn't show, to having totally unprepared data from which one is supposed to reproduce an existing custom coded C# .NET Silverlight app with Telerik charts using SSRS, when SSRS's charting capability is largely in the dust in comparison to the Telerik chart control for Silverlight.
Steve
(aka sgmunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 30, 2010 at 11:41 am
You're really getting into a lot more complex stuff. Sounds fun!
I'm happy to say that this is my first report so seeing it start to work is really nice. Thank you again and good luck with your projects.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply