Hiding null values in a column in SAP Crystal Reports

SAP SAP CRM SAP Testing

In SAP Crystal Reports, I have to show some of the numerical values of a column and if the sum is coming 0. I want to hide that.

I have written below formula however it still shows ‘0’ value:
* IIF ( ToNumber({Choice_.Choice1}) > 0 , true, false) >> Gives Count. Need Sum
* NOT(ISNULL({Choice_.Choice1}))
* IF( ToNumber({Choice_.Choice1}) > 0) then ToNumber({Choice_.Choice1})

0 0

1 Answer

Anil SAP Gupta

Answered on 23rd Apr, 2018

I am not sure where this formula is written. You have to write this formula in suppress part of Section Expert.

To open section expert, right-click Report Header -> Section Expert  click x->2 or suppress

Also, note that you can write the formula in any section where data is present in your report. Try below formula

ToNumber({Choice_.Choice1}) > 0 //You have to ensure choice1 should always a numeric value else report throws exception

0 0

Would you like to add a better answer?

Hiding null values in a column in SAP Crystal Reports

Follow

Newsletter