Skip to Content

Demo of How to use Input Control Values in Report Header

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:

  1. Create an Input control

          Image1.png

    2.  Make sure that Input control dependency includes the Report Body and not just a Block.

         

     Image2.png

3.  Create a formula using ReportFilter([Dimension Name]) function


     Image3.png


And it’s done. Following image shows how report header will look like after using Input control. It’s simple, isn’t it?


Image4.png


Be the first to leave a comment
You must be Logged on to comment or reply to a post.