SSRS - Split table to multiple pages

• David Leaver

  Mr or Mrs. 500

  Points: 599

  More actions

  January 7, 2009 at 8:23 am

  #383698

  I've been tasked with developing an Invoice report in SSRS, and one of the requirements is to have three sections on the first page ( tri-fold ) with delivery information in the first third, invoice details on the second third, and a payment coupon on the third.

  I've got everything positioned correctly now, but I can't seem to figure out how to limit the invoice detail records to fit within the space allotted, and continue the detail table on pages 2 - X.

  I can't even base it on record counts, as the values in the invoice details may grow to fill multiple lines, so I can't be guaranteed that 10 invoice detail lines will fit in the allotted space.

  Any ideas welcome at this point.

  Thanks.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  January 7, 2009 at 8:52 am

  #922609

  Sorry to say, you are going to have to deal with it in the number of rows.

  I have had to do a few similar things to ensure proper positioning. The only way I was ever able to deal with it was to control the data set completely to ensure nothing could grow in size. If you have details that can cause word-wrap, return these as individual records in your recordset. You will then be able to control the output by the number of returned records.

• David Leaver

  Mr or Mrs. 500

  Points: 599

  More actions

  January 7, 2009 at 9:17 am

  #922649

  Brilliant! Thanks.

  Did you use mono-space fonts then for the detail lines? If not, what method did you use to determine where an entry would wrap?

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  January 7, 2009 at 9:25 am

  #922658

  I was dealing with insurance paperwork - which had to be in a some specific true-type font - so all of the characters were the same width.

  If you are using a variable-width font, you could be in some serious trouble. You could "guesstimate" and just set your textboxes to not grow - or change fonts.