How to show "na" when value is suppressed.

29 Views

Dear all, I have report created under CR 2008 and it has parameter values which are conditional. What I would like to do is to set up those parameters in such a manner that if the parameter value is empty, the preview mode should show n/a.

For example

I have three optional parameters. Account Number, Product Code and Sales Area.

Currently if user opt out from Account number, the report shows a blank white space there. Which kind of look bad. So I was thinking that if it is possible, when a value is suppressed, it should show n/a, letting an user know that the value has not been selected instead of an empty space.

Can this be done? if yes then how?

I have setup suppression like, right click on the field~~->Format~~->Common tab~~->Suppress x+2~~->not hasvalue({Account Number}).

This allows the report not to show any company account number if not chosen in the parameter value.

How can I show "n/a".

Any help in this case would be highly appereciated.

Many thanks

Regards

Jehanzeb