Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two pages per record
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00023111
Message ID:
00023412
Views:
27
>It almost works, but I forgot to mention that I only want page 2 to print if there is something in the memo field. (I didn't bother with =AFIELDS() because I found that cString went way over 254 characters. There seemed little point in making cString1, cString2 etc.) I also discovered that I would get a "not UNION compatible" error if I tried to use SPACE(254), SPACE(4), or "" as memo, so I put the memo field "as is" in both parts of the SELECT. In order to get rid of unnecessary page two's, I added a WHERE !EMPTY(memo) to the second SELECT. That clause gave me a cursor which only repeated records that had !EMPTY memos. I put all my text fields in the group1 header and put the memo field in the group2 header. However, the report still insists on printing the group2 page for every record, even though most of these records have an empty memo and listorder=1.
>
>I don't understand why FoxPro doesn't make it easier to do this. I should think a multiple page per record fixed-format report would be a routine task.


you should be able to tell the report to erase the line if the memo field is blank, but if you're forcing the memo field (group2) onto a second page, there may be trouble.
Previous
Reply
Map
View

Click here to load this message in the networking platform