December 22, 2009 at 2:10 pm
Hello and Merry Christmas/Happy Holidays or whatever works!
The report I'm doing has several pages. Each report page will depend on the unique number supplied i.e. each time a new invoice number is supplied, a new report (starting on a new page) will begin.
The reports I've done so far depend on parameters supplied to a query or stored proc. which paginates the data depending on properties set. Then it just runs to the end of the data.
However, now I need to print an invoice with no header (so the header can't repeat on each page). I know I can add a page break to the end of each report. But the report has to begin again with a new invoice.
I don't know how to do this.
So far, all I can do is print the first invoice of the batch and stops.
Can someone help?
thanks,
Paul
December 23, 2009 at 3:31 am
Hi,
I think all you need is a to put the data in a table and add the invoice number as a group. You can then edit the group and tick the box for 'page break at end' this will then force a new page after each change in the invoice number.
Give it a go and let me know how it goes.
Thanks.
December 23, 2009 at 8:26 am
Yes, that works. Thanks!
December 23, 2009 at 11:20 am
I still have a problem with my report. I have several tables within a parent table as suggested but some of the datasets aren't found by the report.
That is to say, each sub table has a different data set. When I run the report without them being wrapped in another table, this works OK. But inside another table, some of them get the error:
"The Hidden expression for the table <table> refers to the field <field>. Report item expression can only refer ..." etc
Yet if I set the parent report dataset to <table> then the error is eradicated. It does flag another table with the same problem but I can only set one dataset per table.
How do I fix this?
thanks,
Paul
December 29, 2009 at 2:32 am
Hi, I think from reading your error message it seems that you have changed the data source and one of the fields or expressions in your report is referring to the old data set. I would make a note of the field name in the error and then check the expression/field and make sure it is referring to the correct dataset.
January 5, 2010 at 1:50 pm
Yes, I've checked that. Neither the dataset name or field has changed (or at least, not changed explicitly). The only change I've made is to place my tables within a rectangle and then inside another table. Clearly it's this that makes the difference as to why the report can't find my datasets. But I don't know why.
I've looked on other blogs and it appears to be a common problem. Some claim that this is fixed in 2008 but that doesn't help me too much.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply