How do you create a report (rdlc) that shows 1 record per page

matthew_360 picture matthew_360 · Dec 5, 2011 · Viewed 23.5k times · Source

Having some trouble getting this to work... I basically want the report to look similar to:

enter image description here

The way I remember doing this in the past was by creating "page groups" in the report wizard. However, I believe that was in VS05, and now the report wizard is very different in VS10. It now has column groups and row groups but no page groups, and I can't see how to get this to work without the wizard either. If tried looking for a tutorial or example but haven't had much luck. Also, the site 'gotreportviewer.com' is pretty terrible and has not been much help.

Answer

JonH picture JonH · Dec 5, 2011

To create the effect of one record per page means you need to set a group element to the report. For instance assume you have a database table called "Login" and you wanted to group by a person's login name. Here is what you do:

First add a table to the report like so:

enter image description here

The table can be found in the "Toolbox" on the left hand side of VS2010. Once the table is added you will want to add a group to this table:

enter image description here

After this you will want to go to the properties of the group:

enter image description here

Here you simply can set a page break between each instance of a group, in addition, this will give you a "one record per page".