How to Print Payroll Checks

[Randy]

I'm using Telerik Reporting for an MVC app and I have a requirement to print payroll checks. I don't need to recreate the entire check, I just need to fill in data in the check for date, amount, etc., in the appropriate areas on the check. 

The payroll checks are on 8.5 x 11 sheets with three checks per sheet, vertically (top to bottom). Therefore, I need to be able to create a report that allows me to basically limit each page to three rows of data, each row representing an individual check. How do I go about doing this? I tried putting a particular field in the detail section three times, but, of course, it just prints the contents of the field three times. It's almost as if I need three detail sections per page (one detail section per check), but I don't see that Telerik Reporting supports that.

[Stef]

Hi Randy,

Please check the information in Report Structure and how each section appears in the report. Check also the details in Grouping data as you can use GroupHeader/FooterSection to add static or dynamic content in the document as well.

Let assume the data looks like:

employee, salary, date
emp1,XXX1,1-1-2017
emp2,XXX2,1-1-2017
emp3,XXX3,1-1-2017
emp4,XXX4,1-1-2017

Possible layouts:

1. The requirements are to have 3 times the check information of an employee on a page.
   You can use a Band Report Wizard, where you can add a grouping by employee - the idea is to have a GroupHeaderSection, DetailSection and GroupFooterSection per employee. This will let you have the information 3 times on the page.
2. The requirements are to have each employee's check only once, where 3 employees information should gather into a single page.
   You can use the Band Report Wizard without any groupings.

In both suggested layouts, each section will grow depending on the size of its items - Report item Layout.
You can adjust the report's PageSettings properties, with consideration of the designed sizes of sections, in order to be able to have 3 sections on one page - Understanding Pagination.


If you need further help, please elaborate on the format of the data and the required document layout.

Regards,
Stef
Progress Telerik

[Randy]

Thanks Stef. I don't really understand your answer. Your layout option #1 won't work for me because I don't want each of the three checks on each sheet repeated. I want each check to represent the paycheck of a different employee. I tried your layout 2 option, with no grouping. But where do I put the various fields? Do I put them in the page header, detail and page footer sections? If so, I tried that and the data is simply repeated.

[Stef]

Hello Randy,

Please check Report Structure:

• The report has page sections - Page Header and Page Footer, which repeat on each physical page. These sections are generated last and should not display data bound object, but rather information about the current page.
• The report has a ReportHeaderSection and a ReportFooterSection which are report sections. These sections are rendered only once in the report - on the first and last pages respectively. They can contain aggregated information for the whole report, or title information.
• The report has DetailSection. This section repeat for each data record in the set data source. You can place items in the Detail section and make them use expressions like "=Fields.ColumnName1" - the expression in each developed detail section will get a new value from the data source.
• You can add also GroupHeader/FooterSection which will surround detail sections displaying data related to the grouping expression. These sections can be used for displaying the repeating (grouping) data or aggregated information for the group.

To test the above, please follow the steps from How To: Use the Report Wizard to create a Band Report.


If you need further help, please feel free to open a support ticket and to send us test data and the designed report. Include also details about the expected layout e.g. a screenshot with remarks.

Regards,
Stef
Progress Telerik