Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 489
matthew_360 Avatar asked Dec 05 '11 18:12

matthew_360


People also ask

How show data report in Rdlc?

Go to Design view, Select Smart tag. Click Choose Report Dropdown, Select RDLC report (StudentReport). Click Choose Data Source and select <New data Source>. Select Object and Give DataSource Name.

How do I reduce the size of my Rdlc report?

Hit F4 to see the properties tab. Here, you will see a "Size" property. This can be expanded for the width and height. The width you see here represents the width that the body of your report requires as printable area.


1 Answers

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".

like image 98
JonH Avatar answered Oct 02 '22 00:10

JonH