>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