If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Can a table row be rendered conditionally

Started by jmadam, 16 May 2013 12:15:39 PM

Previous topic - Next topic

jmadam

I have a report that contains a table. The Page -> Data -> Query property has the query, qryRCN, that contains the field I am using to define the boolean variable, IsFinal.
Where the expression is [qryRCN].[FINAL_ROLL_FLAG] = 'T'
I attempted to conditionally render a table row by assigning the Table Row -> Conditional -> Style Variable property to use the variable IsFinal.
When attempt to verify report, I get:
RSV-VAL-0032 The following expression is not valid: [qryRCN].[FINAL_ROLL_FLAG] = 'T'. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'. The variable named '[qryRCN].[FINAL_ROLL_FLAG]' is invalid.

Lynn

Is your data container a list? If so, navigate to the list level properties and click on the "Properties" property. Then click the check box next to your query item that the condition is based on.

That error message is telling you that you are referring to something in your query that isn't associated in any way to the data container. Adding it to the properties establishes that association and should allow your conditional style to work.

Personally I'd use an advanced conditional style with boxtype set to none and specify that style for each column in the list rather than using a style variable. It just seems easier to me, but to each his own :-)