CODEWITHSUNDEEP
reporting-servicesreportssrs-2008-r2
Rio
Rio

Reputation: 107

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

Upvotes: 0

Views: 5526

Answers (1)

Henrov
Henrov

Reputation: 1610

  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 ;)

Upvotes: 1

Related Questions