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:
- Report has a conditional variable to drive the display of links and
- Report has a ParamDisplayValue layout calculation that has Render Variable set on a completely different conditional variable and
- 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.
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.