Hi--
I have a report to print a range of invoices. Every invoice has four parts to it: the header information, the detail information, the total, and then a resummarization of the detail by area. So I used a list report item grouped by invoice number, and put my header info, detail table, total info, and resummarization matrix in to the list. It works great. Except...page headers.
On the first page, the header is inherently in the report body which is fine. However, if the invoice goes to a 2nd or 3rd page, I have issues. I tried using ReportItems to pull the document number, date, customer name, etc in to the header. But that only works if the Report Item referenced appears on the page. So, in my case, because I have free form fields, a table, and a matrix, it is not possible for me to reference the field and ensure it always shows up when the report is paginated (for example, if I reference a field in the table, what happens when the second page just has the matrix on it?).
So, I thought I would be clever and reference two report items in the page header field (one in the table and one in the matrix, gambling that every page would end up with at least one of those objects on it) using IIF to check if the first field was null and then using the second field (placed lower in the list area). But the conditional statement does not work with reportitems, and I get an error stating such.
Any ideas? I am about to go nuts over this, as it seems so simple..I have a list object to print invoices, and i want the page header to show the invoice number, invoice date, customer number, and customer name.
Any thoughts much much much appreciated!
Thanks!
Christina
by: CGLuttrellPosted on 2009-09-10 at 23:22:33ID: 25307029
Will the matrix always be on the first page also or can it be pushed off the first page?
I ask because I just did a test where I Grouped my List items by one field and put a matrix in the List with the Grouped By field as the first grouping column, I even made turned the visibility off so it would not repeat on every line (I made the column as small as it would go also). I then put this line in my Page Header (the name of my Field happens to be called Name so that was the name the textbox got also)
=First(ReportItems!Name.va
So as long as my matrix starts on the first page, it does not matter how many pages before the next group starts, it is printing the Group Name at the top of the page for me.
HTH
Chris