Hi Folks
I have an application that queries data from the Sage Accounts Program and then produces Invoices based on that data.
My report has a Page Header and Footer and pulls info from one query which gives the Main Product Details and another query which gives only the Carriage detail. Both are filtered by the Order Number.
The Detail of the report shows the product details.
The Order Number Footer shows just the carriage by extracting data from a sub-report based on the second query.
The page footer holds the total boxes.
Normally the report works fine but has never gone onto a second page. Now that it has gone onto a second page I find that the records are being duplicated....I just end up with two lots of them, one string of products followed by a second, not a duplicated line followed by another.
I have played with the group sorting and totals but can't understand why going onto a second page has forced this duplication. I have gone back to the queries and double checked that the info being extracted is not duplicated there.
Does anyone have any ideas please? I'm baffled by this one.
Thanks
Andy
I have an application that queries data from the Sage Accounts Program and then produces Invoices based on that data.
My report has a Page Header and Footer and pulls info from one query which gives the Main Product Details and another query which gives only the Carriage detail. Both are filtered by the Order Number.
The Detail of the report shows the product details.
The Order Number Footer shows just the carriage by extracting data from a sub-report based on the second query.
The page footer holds the total boxes.
Normally the report works fine but has never gone onto a second page. Now that it has gone onto a second page I find that the records are being duplicated....I just end up with two lots of them, one string of products followed by a second, not a duplicated line followed by another.
I have played with the group sorting and totals but can't understand why going onto a second page has forced this duplication. I have gone back to the queries and double checked that the info being extracted is not duplicated there.
Does anyone have any ideas please? I'm baffled by this one.
Thanks
Andy
