Hiding '#MULTIVALUE' 2

[astinus4]

Hello,

Does anyone know if there is a way of hiding a cell if #MULTIVALUE occurs in it? I've tried hiding the cell using the IsError function (eg IsError(<objectname>)) but that doesn't work.

Thanks...

 

[skrandel]

Why do you want to hide it? Why not eliminate the problem?

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[astinus4]

&quot;Why do you want to hide it? Why not eliminate the problem? &quot;

Basically because in the context of the report #MULTIVALUE isn't actually a problem - it just looks ugly from an aestehtic point of view.

The report has been set up to operate like an 'online search' for the users. The report is permanently in drill mode, and has multiple drill filters at the top of the page which are used to filter the contents of a single table in the body of the report.

All this is simple enough - the complication arose when the users requested that they wanted to see the filter values they'd chosen in cells in the body of the report, just above the main data table. The justification behind this request was that many people would print hard copies of the report which wouldn't show the drill filters and the options chosen.

Because there is more than one filter each of the cells appears as a #MULTIVALUE, until one value is selected from the corresponding drill filter. There's nothing really wrong with the data, but it would be nice to replace #MULTIVALUE with a blank space, or maybe even something like &quot;Option not selected&quot;.

 

[xlbo]

If(trim(Drillfilters(<Variable Name>))=&quot;&quot Then &quot;None Selected&quot; else Drillfilters(<Variable Name>)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[astinus4]

Thanks xlbo, that's exactly what I needed.