A ^Line^ as a Calculated Field ??

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Mel_Smith_(Guest)
Posts: 143
Joined: Tue Oct 10, 2017 12:44 pm

A ^Line^ as a Calculated Field ??

Post by Mel_Smith_(Guest) » Fri May 05, 2006 6:46 pm

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____

Gift
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

=> ^Line^ as a Calculated Field ??

Post by Gift » Sat May 06, 2006 9:12 am

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

Mel_Smith_(Guest)
Posts: 143
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: ^Line^ as a Calculated Field ??

Post by Mel_Smith_(Guest) » Sat May 06, 2006 2:25 pm

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__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: ^Line^ as a Calculated Field ??

Post by kfleming » Mon May 08, 2006 7:22 am

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

Mel_Smith_(Guest)
Posts: 143
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: ^Line^ as a Calculated Field ??

Post by Mel_Smith_(Guest) » Mon May 08, 2006 9:40 pm

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

Alan_Klein
Posts: 68
Joined: Tue Oct 10, 2017 12:44 pm

=====> RE: ^Line^ as a Calculated Field ??

Post by Alan_Klein » Tue May 16, 2006 12:11 pm

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.

Post Reply