filter summary

building reports webintelligence
1

Is there any way to change the format of the =reportfiltersummary() results?

The information returned is very good, but takes up too much space.

i’ve tried using =drillfilter() but drill filters only allows single value filters and we need multi-value filters.

If we right click on a column and click filter, we can multi-select filter values and =reportfiltersummary() will display them as report filters, but using =reportfilter() in order to format the information nicely does not return the filter values as expected.

Any ideas?

esiegel (BOB member since 2009-11-09)

2

OK…an update…
if I use =ReportFilter() on the object in question and the filter is placed on the REPORT section in the structure rather than in the BLOCK section where the field resides…it returns the expected data.

Question is…how do I get the users to understand that?

esiegel (BOB member since 2009-11-09)