nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding multiple "check box" report parameters in a report

ashwinishankar

Hi All,
 
 I have added multiple "check boxes" a Boolean type report parameter to my report(Ex: 2 check boxes to Include SubOrder and SubQuantityOrdered). When I preview the report with the options checked, then the number of results and the visibility of the columns are displayed correctly.
 
When the options are unchecked the columns are hidden(exactly what I wanted), however, the number of records are not correct and it displays the records same(duplicates) as that of the checked options.
 
Ex: When checked the number of records should be = number of SubOrder and SubQuantityOrdered of the item.
 When unchecked the number of records should be =1
 
 
Can you please advise how to apply this feature in the report.
 
Upon check or uncheck the number of records should get accustomed.
 
Thanks,
Ashwini

Find more posts tagged with

Comments

ashwinishankar

Hi,
 
Basically, I would like to know how to hide a row when its column is hidden ?
 
I am executing a SQL script to fetch all the details of Employees, which includes columns say "Supervisor Details" and "Performance"
However, I am setting up the visibility for column Supervisor to be available only when the report parameter(Include Supervisor) is checked. Likewise "Performance" details to be shown only when "INclude Performance" report parameter is checked.
 
I am expecting the output : 
 When only Include Supervisor is CHECKED, then only the columns of Supervisor and its rows to be included and not the columns and rows of Performance, and vice versa.
 
 
But as of now, When any one option is checked, the visibility only hide/display the column, but the number of records are same.
 
 
Could you please help in fixing this issue?
 
Thanks in advance.
 
Ashwini

Clement Wong

Do you have a sample output that you can provide so that we can better understand your requirements?