Skip to Content
0
Former Member
Dec 22, 2009 at 09:20 PM

PRINTING FIELD, SUPRESS OR SHOW

17 Views

Using Crystal XI, I need to control the printing of a discount price field, to print or supress. I have created a parameter to select YES or NO if the user wants to show the discount price of an item. I also have added a formula to the select expert, I don't think this is where it belongs?? @Disc is a formula to convert string to number, {?DISC} is the yes no parameter.

The formula is : (if {?DISC} = "YES" then {@Disc} <> 0 else {@Disc}= 0) In formatting, I have supressed the field if it is -0-.

The report only shows items with discounted price with "YES" and when you pick "NO" the report only shows non discounted items, we want to see all items, discount or not, just not always see the discount price. We want the column to "hide" not select which items appear.

Thanks for your help.

Jayne

Edited by: Jayne Neal on Dec 22, 2009 10:20 PM