January 7, 2009 at 8:23 am
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.
January 7, 2009 at 8:52 am
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.
January 7, 2009 at 9:17 am
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?
January 7, 2009 at 9:25 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply