Search code examples
reporting-servicesreportssrs-2008-r2

How to make SSRS report for an invoice with page breakes


I have to create an ssrs report which will be used to print invoices from database data. In my initial attempt I created an A4 page filled with textboxes with dataset fields inside. This works great for a single page invoice for one customer.

But now I need to create a multi-page report which would list all the invoices for a certain date. I wonder if I need to use list for this, and if it is the case, would I need to replace each textbox with a list box?

Thanks


Solution

    1. Create a report with 1 Tablix.
    2. Couple that to a dataset containing all your invoicenumbers.
    3. Create a parameter 'invoicenumber' in the existing report.
    4. Place your existing report as a subreport in the tablix.
    5. In Rowgroups rightclick 'Details' and choose Pagebreaks.
    6. Set a pagebreak 'Between each instance of a group'.
    7. Use the invoicenumber to couple the main- to the subreport. (left: invoicenumber, right: [@invoicenumber])
    8. Run your report ;)