How can i suppress a field through a paramater? 1

[jspur2003]

Im using Crystal 8.5 and I want to write a formula in my paramater so When the user that accesses the report chooses Yes in the paramater then it will show the particular field if they Choose No it will suppress the field

My paramater field name is {?Show costs}
They can select either Yes or NO
field that it needs to suppress is {ILT_COST}
If they choose YES then a quick ex below
ITEM COST PRICE
1001 15 30
1005 12 25

If they choose NO it should show
ITEM COST PRICE
1001 30
1005 25
Any help with this formula would be great Thanks

 

[rosemaryl]

Dear jspur2003,

Select both the column header(cost) and the field{ITL_Cost}, right click, format objets/common tab, x-2 formula editor box to the right of the suppress (do not check suppress) and enter the following:

Uppercase({?Show costs}) = 'NO'

That should do it. I uppercased the parameter, because I like to take out user errors from my formulas...

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[jspur2003]

Thanks that works great