>>Hi All!
>>
>>I have to put 5 fields in the summary band of a report but I also want, if possible that if those fields should be empty, the "line" would be removed. The report designer I think doesn't allow "remove line if blank" in summary bands..Is there a workaround for it? Thanks!
>
>A guy from Paranaque has this tip posted in the Foxpro Advisor Mag. I think this will solve your problem.
>
>1. Create a report variable: nKeyFieldCount
>2. Calculate to COUNT
>3. Reset at the key field in the group expression
>
>Set the Print When for every object in the Group Footer band as follows:
>1. Check the "remove line if blank" option
>2. Enter the expression nKeyFieldCount > 1 in the "print only when expression is true" box.
Another simple approach which I got from UT (sorry, don't remember exactly from who) is to put the fields like:
field1;field2;field3 etc. It will automatically remove fields if blank.
If it's not broken, fix it until it is.
My Blog