Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Print detail more than one line
Message
From
02/11/1998 21:07:21
 
 
To
02/11/1998 13:57:39
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00153649
Message ID:
00153781
Views:
20
>I have some reports e.g. Item List Report etc. which print out the detail more than 1 line. My detail in report look like as belows:
>
>Desc uom ucost
>--------------------
>desc1 xxxx xxxx
>desc2
>desc3
>
>Some items have only desc1 or desc2 ... or all.
>I already defined "Remove Line If Blank" for desc2 and desc3.
>It seems like correct, but Vfp didn't print the last two lines of each page. My report should be printed as 15 detail lines per page, but it printed only 13 lines per page. How should I do ?
>Hope that someone understand my question.
>
>Thanks in advance
>amnatn



Ummm, you want to remove blank line and also print empty line at bottom!

Previous action on setting remove line is OK!

Add another Dummy Field as follow to add enough blank lines:
(Beware the Limitation On field is 255 characters.

IIF(Empty(desc1),Chr(13),"")+IIF(Empty(desc2),Chr(13),"")+....

Remember to set Strenth for Overflow to true
Print Option is: Recno()%15 = 0

Then, when print the last record at page, it will also print the addition field
to adjust 15 lines per page!

You also can add a variable to shorten the word Chr(13)!
e.g. CR is Chr(13) so that the length on that field will shorter.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Previous
Reply
Map
View

Click here to load this message in the networking platform