Skip to Content

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


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply