Showing posts with label conditional variable. Show all posts
Showing posts with label conditional variable. Show all posts

Thursday, July 5, 2012

Defect - Conditional Variables based on Members + Drill + Render Variable

There are times when you would want to use conditional variables to hide/display drill through links in a crosstab. If your condition is based on levels its easy to achieve this using levelNumber roleValue. If your condition is based on member names then there is a possibility that you may run into errors under the following scenario:

  1. Report has a conditional variable to drive the display of links and
  2. Report has a ParamDisplayValue layout calculation that has Render Variable set on a completely different conditional variable and
  3. You drill up/down on the member and then you select a value in a report page prompt and re-run the report you may run into the error: RSV-RND-0089 Failed to evaluate expression
This does not happen if you remove the render variable property on the layout calculation or you select prompt values and then carry out a drill activity

To avoid this, create a caption() member, set that as a property of the row member and modify the condition to be based on this member.