showing a space instead of a "#"

[Former Member]

Is it possible to show a blank instead of a "#" (not assigned). That is, whenever a value is #, I want to show it as a blank instead of #. Is this possible?

[Former Member]

Hi,

Please go to the properties/settings of the query. There you can replace 0 with #, or # with 0, or anyother figure, but I don't think blank is possible.

Thanks,

Saket

[Former Member]

You can use a Macro to replace # with a blank.

Hope this helps.

Bhargava

[Former Member]

Hi Sista,

Can you explain in detail how to use the macro?

[Former Member]

But then I would have to use Analyzer. I show all my reports in WAD.

[Former Member]

I dont think thats possible to replace unassigned to someother value dynamically, work book would be a workaround.