Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Print only when the expression is true
Message
 
To
18/12/2003 08:04:59
Suhas Hegde
Dental Surgeon
Sirsi, India
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00860289
Message ID:
00860320
Views:
20
>hi,
>i have tried a lot to figure this out but drew a blank.
>
>I have a report where the text has to appear only once in the details band. however this text has to apper only when the field it relates contains characters..
>there are a lot of these type of pairs (about 60).
>when i use a condition like in the print only when the expression is true like len(alltrim(thisfield))>0 the text prints repeatedly.
>i tried to set norepeat and the supalways in the frx to true but did not help and this is driving me crazy.
>how should i solve this ?

Obviously, you could put the field in the header or footer. But if you need it in the detail band for design reasons, you can add an "nDetailCount" report variable which counts and resets each group. Then in your Print When for the field, ndetailcount=1.

Although I'm not sure why your current "print when" and "Remove Line if Blank" doesn't work for you. Sounds like it should.

Debugging reports can be a pain, but you could drop a field on the report with your Print When expression just to verify that it's what you expect.

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform