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

Display up to 3 IMAGES dynamically depending on status

Started by bioCam, 11 Aug 2010 08:41:04 AM

Previous topic - Next topic

bioCam

Hello, I need to create a report to display Complaint_Type images in place of text (only if there is a Complaint_Type 1, 2 or 3) for the Cust_ID.  I think I need to create conditonal styles but not sure the steps.  I would appreciate any tips and advice.  Thank you.

Using sample data to illustrate:-

Cust_ID, Cust_Name, Date, Complaint_Type
1101, Jane Doe, 2010-01-04, 1
2394, John Boy, 2010-05-10, 1
1101, Jane Doe, 2010-06-04, 2
1101, Jane Doe, 2010-06-24, 1
3003, Fred Not,  2010-06-24, 0

Report:
------------------------------------
Customer Name: Jane Doe
Complaint: Image1, Image2
------------------------------------
Customer Name: John Boy
Complaint: Image1
------------------------------------
Customer Name: Fred Not
Complaint: - none -
------------------------------------


 

Lynn

Using a render variable is another possible approach and pretty simple when all you want to do is show or not show something based on a condition.

In your example, you could set the render variable for image1 to be a boolean: Complaint_Type = 1 and another render variable for Complaint_Type = 2 for image2, etc. Then you could have another boolean for Complaint_type not in (1,2,3) which would be the render variable for your text.

You can use conditional style also. Click on image1 and select the conditional style property; select advanced conditional style; click the icon for new advanced condition; use expression Complaint_Type = 1; Click the pencil next to remaining and future values and specify box type none (or visible No) in the advanced tab.


bioCam

Hi Lynn,  The render variable works perfect.  I am also going to trying using the conditional style as well.  Thank you so much again.  Now, I can move to the next obstacle in my list :)