I’m trying to add a header to a WEBI report that is indicative of what one of the columns is filtered on. So that when the report is PDF’d, the header shows what the report represents (what it’s being filtered by). For example, if I have a report where one of the columns is a “State”, then as it is filtered by “Nebraska”, then that is illustrated at the top of the report so that when it’s PDF’d out, the recipient knows what state the report is for.
daylon11 
(BOB member since 2012-12-11)
Hi,
Have you tried using the DrillFilter() function?
[Moderator Note: Moving from Semantic Layer / Universe Designer to WebIntelligence XI]
Marek Chladny 
(BOB member since 2003-11-27)
Try adding a table to the header section of the report, add as many table footers as you need and then, in those footer cells, write your lables and use ReportFilter([STATE]) to give you the filter values.
Alternatively, you can concatenate labels and ReportFilter() output.
Thanks!
vonwolf 
(BOB member since 2002-10-21)
I tried entering the formula into the header: =DrillFilters(State Name). Is there another way?
daylon11 (BOB member since 2012-12-11)
What was the result? Wrong data/result? An error message? Blank cell? You would need to provide more details.
Marek Chladny 
(BOB member since 2003-11-27)
You could try ReportFilter() instead.
Here’s another one:
=ReportFilterSummary([Report Name]). It wants to to tell you which block it’s on "Filter on Block 1: " so you might need to clean it up with something like:
=Right(ReportFilterSummary("Summary");Length(ReportFilterSummary("Summary"))-Pos(ReportFilterSummary("Summary");":"))
I’m guessing that your report is not in Drill mode which is why =DrillFilters() isn’t working for you.
vonwolf (BOB member since 2002-10-21)
Correct, the report is not in drill mode.
The =ReportFilter(State) works but it brings back every single state that’s available to the report, regardless of what specific state is filtered on.
daylon11 (BOB member since 2012-12-11)