Conditional Hyperlink

[mk.ramegowda]

 

I have a report has shown below. Now I need to create hyperlink(ReportExecution) for the column "DEVICE_TYPE". The issue is if the

Device_Type = ATM, the hyperlink should be for ATM_DAILY_REPORT

Device_Type = ADT, the hyperlink should be for ADT_DAILY_REPORT

Device_Type = RECYCLER, the hyperlink should be for RECYCLER_DAILY_REPORT

CYCLE_DATE	TERMINAL_ID	DEVICE_TYPE
20151101	12231234	ATM
20151101	12231235	ATM
20151101	12231236	ATM
20151101	12231237	ATM
20151101	12231238	ADT
20151101	12231239	ADT
20151101	12231240	ADT
20151101	12231241	RECYCLE

Please let me know how to build this kind of hyperlinks.

I am using iReport 4.5.0

[kkriplani]

 

Correct me if i am wrong, You are trying to link different reports based on the parameter $P{Device_Type}:

The method that could help in doing so would be; for the link parameters in the hyperlink, under parameter name, add, _report and give it the following condition under Expression;

$P{Device_Type} == "ATM" ? "*path_of_ATM_DAILY_REPORT*" : $P{Device_Type} == "ATD" ? "*path_of_ATD_DAILY_REPORT*" : "*path_of_RECYCLER_DAILY_REPORT*"

Notes:

1) Replace the line between * * with the respective paths (excluding the *s)

2) Link the other parameters as per your requirement.

I hope this helps,
Thank you.
KKriplani