how to create an "optional" merge field for a user definable report
hello one and all,
i have created a report with say the name and address listings. i use two merge fields to consolidate the address fields into only two lines, like on a mailing envelope.
prior to the report, i have an input screen to allow the user to option whether they want the address to show on the report. if the user choses not to see the two address merge fields, what is the best method to deactivate those merge fields and then slide the report part upwards so as not to have that blank space there?
thank you in advance, lucas
i forgot to mention that i am using fm10advanced under snow leopard and win7.
Create a calculation:
Case ( ShowAddress ; <YourAddressFields> )
'ShowAddress' is a Number Field. If the user checks 'Show address' then the fields content is 1 otherwise it is 0 or empty.
Put the calculation field on your layout in place of the other mergefields. Use sliding as you suggested.