Forum Discussion
general design of a multi invoice report
Hi, i have a requirement to produce the report you see below in ssrs. Its basically 1 to n invoices based on a range (from and to) of invoice #'s that will be input as 2 parameters. The stuff hilighted in yellow is static info. everything you see from line 1 to line 23 should be repeated on each page for the same invoice. And a new invoice should start on a new page.
Except for page number, all non heading info on lines 1 thru 20 represents header info that for a given invoice will be REPEATED on every row of the dataset. See the 2nd image for a rough draft of the dataset layout. Header info shows once on every page.
Am i looking at a matrix with a report perhaps in the 1st cell? How would i ensure that each invoice starts on a new page? Is there a link to a "how to" to a similar requirement?
- after hitting submit it occurred to me that maybe paired with page number, we can pretend that a new report is being generated in the matrix for every combo of invoice # and page number. Thinking out loud here.
also, as i recall , you cant embed a report inside a matrix cell and expect that report's headers and trailers to work.
- does anybody know how i can delete this post as it is my own and i seem limited to editing it? I'd like to try my luck elsewhere but dont want to repost.
