Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report spanning two pages
Message
From
18/04/2019 16:00:56
 
 
To
18/04/2019 11:22:05
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01668175
Message ID:
01668195
Views:
69
>>>>>Hi,
>>>>>I have to design a report which spans over two pages. So I have adjusted the papersize to 2x A4 implented all the objects and print.
>>>>>Grr printer prints perfectly page1 and page2 but report is printed 98! times.
>>>>>Any idea how to instruct I only want 2 pages and no more?
>>>>
>>>>Could it be that your current alias, when running the report, is a cursor with 98 records?
>>>>Try "report form xxx next 1 to...", may work.
>>>
>>>Rather that the current alias is not selected prior to running the report - happens when reports are run from a form which contains a grid
>>
>>Gregory,
>>Report is running from a cursor only. No form with grid involved here.
>>See my example: a .prg to instantiate a cursor and run the report after that.
>>See what happens, my printer environment indicates 98! pages. It should be only 2.
>>Regards,
>>Koen
>
>Koen, I second Martina's result: a 2-page printer is previewed when you run the report against the cursor.
>
>There is a reference to a "zzdatabase" and to a table "visite" in the report's data environment. Are you sure your 49 records aren't coming from that source? Neither Martina nor I have access to that table, so the 2 page report for us would be expected.

Antonio,
John,

Indeed I found that a table Visite was erroneously added to the dataenvironment, reccount of 49, so a 2-page report will give 98 pages!
Now after removing that table it works as intended.
Thanks !
Best Regards,
Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform