Hello,
I'm using Visual Foxpro 6.0 and I'm having a problem with a report.
In the report I have, I use 2 sql-statements to fill my report.
The first part of the SQL-Statement fills the header : no problems there.
The second part is a repetitive Detail: also no problems.
I also have a footer with information: a memo field of a table (taken from the first SQL-statement). It prints just under the detail band: that's the way I want it to.
BUT:
Now I want to print that footer on the next page. That didn't look like a problem : just assign a new Group to that part of the footer and make it use a new page....... but that didn't work.
I've tried it in many ways: Group in a Group and the info in the footer, but every time it was either printed twice (because of the repetitive information from the detail-band): so under every detail-item the footer info, or just once , but not on a new page....
Does anybody know how to get a piece of information (memo field of a table) printed at the top of the SECOND page of a report, considering that on the first page is a header with information and a detail band (or is information that's shown more than one time) ???
Please is there anyone who also has done something like this and can help me ???
Thanks in advance for your time,
Greetings,
Remco Terpstra