Skip to Content

How to Hide a field that required in Run Time Filter Criteria – Canvas Reports

In Canvas reports as per design if we need to include particular field in run time filter , then that field needs to be present in the query output.

 

Requirement : Needed a filed in run time filter criteria but the values should not be present in the output.

 

Solution: This is achieved by the formatting options available in report center.

 

Step 1 : Add this field as the last column in the query output. (In scenario it is Employee Status)

Step 2 : Add this field in the Runtime Filters along with other values.

Step 3 : Navigate to Edit Formatting then select the last column –>Right Click–>Delete Cell(s).

Step 4: Right click the column and select Style Settings.

 

Step 5: By Default “Custom” value will be filled in the Background Color, change it to White, so the last column won’t be visible.

 

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