how to reference a data row in cross tab?

acervantes

Hi all, I need your help.

I have a cross-tab with two cross-tab cells in the "Drop data fied(s) to define rows here" .

cross-tab cells 1: kpi_name
cross-tab cells 2: recommendation_id

The "kpi_name" data has the hyperlink property set to invoke another rptdesign file.

My report requires that the hyperlink property would be set depending of the "recommendation_id" value, if the value of this field is 0 the hyperlink property of the "kpi_name" does not need to be set.

I have been testing some things but does not achieve this behavior.

Can somebody help me with an example or with some comments that help me to programm or configure this behavior?

Thanks in advanced!
ALCE

acervantes

I did a test with the following code in On_Create event of the "kpi_name" cross-tab cell.

var set_hyperlink = getValue();
this.
if( set_hyperlink == "Customer Name" ){
this.action = null;
}

where "Customer Name" is the content of one of the rows in the cross tab.

with the code: var set_hyperlink = getValue(); I'm asking for the content of the same data ( "kpi_name") and depending of this value I remove the hyperlink property with the code: this.action = null;

But I need to evaluate the content of the another cross-tab cell called "recommendation_id", if the value of this data is 0 I need to remove the hyperlink property of the "kpi_name" data.

Hope this help you to understand my requirement.

Regards,
ALCE