Skip to Content

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.

 

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