Using input Control values

[Former Member]

Hi All,

please help I want to get the input control value and use it in a report heading.

for intance I have input control on Profit Center if the user selects a certain profit center I would like to use that value as the report heading.

I am using webi 4.2 as a reporting tool

[yorur_oz · Accepted solution]

Hi Thato,

You can use ReportFilter function:

=ReportFilter([Your Input Control Object])

reportfilter.jpg

[Former Member · Accepted solution]

.. Right

[kohesco]

just create a table - insert your "profit center" dimension and set your input control to interact with that table.

You can format your table like something cool, set it as a horizontal table: change header, set some horizontal spacing at your table, add an selection image in the header removeheader text

[rajan_burad]

Hi Thato,

Create a variable for that dimension for which you want to have Input Control.

Now assign that variable to input control and also in the heading part.

Now whenever you'll select any value from input control that same will be displayed as your report heading.

NOTE: If you don't select any filter from input control you'll have #MULTIVALUE error so to eradicate that in report heading mention this condition:

=If (Count([Dimension])>1) Then "'Select only one value" Else [Dimension]

Let us know if it works!

Thanks,

Rajan 🙂