Page 1 of 1
A ^Line^ as a Calculated Field ??
Posted: Fri May 05, 2006 6:46 pm
by Mel_Smith_(Guest)
Dear Friends,____ My enviro: RRW 9.0____ I want to create a calculated field of an ^image^ of an ^underline^ field on the report.____ I know this is confusing but I have one (of several) totalling lines on my report with a ^line^ that serves as an underline over a total. Sometimes I wish the total to show, othertimes not. When it does *not* display, I want the ^underline^ above it to disappear too.____ Currently, this ^underline^ field always shows when it should not.____ That is, at times, I wish to print simple ^blanks^ instead of the underline.____ Soooo, can I create a calculated field which can contain a series of blanks *or* my ^underline^ ??____TIA,____-Mel Smith____
=> ^Line^ as a Calculated Field ??
Posted: Sat May 06, 2006 9:12 am
by Gift
Try this____c_line = IIF( printing_total, "-------", " " )____where printing_total is .t. when the total should print and .f. when a total is not required______Gift
==> RE: ^Line^ as a Calculated Field ??
Posted: Sat May 06, 2006 2:25 pm
by Mel_Smith_(Guest)
Gift said:____>c_line = IIF( printing_total, "-------", " " ) __>__>where printing_total is .t. when the total should print and __>.f. when a total is not required ____Gift,____ Thanks but I wanted the ^GUI Windows Version^ of the line (like when one ^draws^ the line using the the Draw Line feature, and uses the mouse to extend the line).____ __Thanks anyway (I guess there^s no way to it ...)____-Mel Smith__
===> RE: ^Line^ as a Calculated Field ??
Posted: Mon May 08, 2006 7:22 am
by kfleming
You can place the line on a free form field whose height is set to the height of the drawn line and then set a logical condition on the band line if that helps.____Kathleen__R&R Support
====> RE: ^Line^ as a Calculated Field ??
Posted: Mon May 08, 2006 9:40 pm
by Mel_Smith_(Guest)
Kathleen said:____>You can place the line on a free form field whose height is __>set to the height of the drawn line and then set a logical __>condition on the band line if that helps. ____Kathleen,____ I don^t understand your saying that I "can place the line on a free form field" ???____ Could you amplify on that please ?____ That is, how do I place my ^line^ on a field ?? I^m puzzled.____TIA,____-Mel Smith
=====> RE: ^Line^ as a Calculated Field ??
Posted: Tue May 16, 2006 12:11 pm
by Alan_Klein
Place the graphical line on a report line where you want it. Click on the "Auto/Freeform Line" button. You can then adjust the height of the line as you wish using the margin controls that you will see appear.____Apply the logical line printing condition (as someone else suggested above) to that report line and you should be fine.