How to make Report Parameter visible based on value of another report parameter selection

[Mary]

Hi,

I have scenario where i have to make some report parameter visible based one Report parameter value like

in below screenshot attached if i select Audience in SelectCriteria ReportParameter  then report parameter listing all Audience value should display( and hide the Interviewee Report parameter), if Interviewee is selected in the  SelectCriteria ReportParameter then report parameter listing all interviewee should show (Audience report parameter should hide)

Please help me on this as it urgent.

Thank in advance

 

 

 

 

[Stef]

Hi Mary,

Report parameters cannot be hidden based on other report parameter.
Instead I can suggest you:

1. On report level - create cascading parameters, where values of the first parameter will control the values of the second parameter. For more details check How to: Cascading Parameters with applied filtering on data source level;
2. On data-retrieval level - interpret selected values based on your requirements e.g. if you have a specific value for a given report parameter discard other received values. For example:
   

   public DataTable GetData(int controlParam, int secondParam, int thirdParam)
    {
      if(controlParam==0)
            return MyDataAccessLayer.GetData(controlParam);
       else
            return MyDataAccessLayer.GetData(controlParam, secondParam,thirdParam);
   }

3. On UI level - you can create custom UI to let the user select values. This will let you show/hide parameter editors per your requirements. The custom UI should update the viewer's ReportSource.Parameters collection on submit. To hide the default viewer's parameters area, you can set all parameters Visible properties to false.

If you need further help, please use the support ticketing system, which guarantees you a response by Telerik representative.

Regards,
Stef
Telerik

[Mary]

Hi,

Can you please give sample example on code snippet given and for Custom UI to show /hide.

thanks in advance,

 

regards,

Mary Jain

[Stef]

Hi Mary,

If you are using the HTML5 Viewer or its MVC wrapper, please check the following tutorial:

• HTML5 Javascript widget - How To: Pass Values to Report Parameters;
• MVC wrapper - How To: Pass Values to Report Parameters.

Regards,
Stef
Telerik