In this document I will be showing how to use Input Control Values in Report Header.
I have created a query to display Sales revenue for Dallas store for year 2004 (used 2 filters- Store name and Year) and I have created Input Control for Lines.
I have selected value as Accessories from input control. Now I want to use this value of input control in report header.
There are 3 simple steps:
- Create an Input control
2. Make sure that Input control dependency includes the Report Body and not just a Block.
3. Create a formula using ReportFilter([Dimension Name]) function
And it’s done. Following image shows how report header will look like after using Input control. It’s simple, isn’t it?