data element in a cell - cross tab

Hi, I'm using Birt Designer 2.3.1

I need to change the hyperlink property of a data element in a cell in the Header section in a cross-tab.

I'm using the function onCreateCell( cellInst, reportContext ) to refer to the cell with cellInst.getCellType() == "header"

I get a value data of a data element ("kpi_recommendation_id") in the cell with:

rec_id = cellInst.getDataValue("kpi_recommendation_id");

But HOW can a modify the hyperlink property of the "kpi_recomendation_id" data element?

Hope someone can help me !!!

Regards,
ALCE

Find more posts tagged with

Comments

mwilliams

Hi ALCE,

If you could explain more about what you're looking for, that'd be great. Also, it'd be helpful and probably quicker if you could create a report with the sample database similar to what you're working with now, so I can use it to try to help. A description of what you're wanting based off the sample report would be best.

Thanks.

acervantes

Thanks Michael for your reply, I have created an example as you asked. 
 
As you can see in my example ( Master-crosstab-hyperlink.rptdesing) there are two elements: status_id and ORDERNUMBER in the column header of the crosstab. 
 
The ORDERNUMBER element has an hyperlink to another report ( Detail-crosstab-hyperlink.rptdesing) with a parameter. 
 
The behavior that I need is that the hyperlink property of the ORDERNUMBER element must be set depending of the status_id value. 
 
In my example the status_id is a consecutive number, in order that you can help me with my requirement, you can assume that if the status_id is 1,3,5 the hyperlink property of the ORDERNUMBER element must be set to link to the detail-crosstab-hyperlink.rptdesign, if the status_id is 2,4,6 the hyperlink property does not need to be set. 
 
Hope this can help you to understand my requirement. 
 
Regards, 
ALCE 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi ALCE, 
 
If you could explain more about what you're looking for, that'd be great. Also, it'd be helpful and probably quicker if you could create a report with the sample database similar to what you're working with now, so I can use it to try to help. A description of what you're wanting based off the sample report would be best.

Thanks.</blockquote>

mwilliams

ALCE,

Ok, I think I understood exactly what you were meaning this time. Check out this version of the report design. It's just a couple simple lines of code in the OnRender event of the data item with the hyperlink. It's disabled for 2, 4, and 6.

Hope this helps. Let me know.

acervantes

Michael, thanks a lot! 
 
It was really easy, i was trying with some difficult code and your solution was not complicated. 
 
Tnanks again for your help. 
 
Best Regards, 
ALCE 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">ALCE, 
 
Ok, I think I understood exactly what you were meaning this time. Check out this version of the report design. It's just a couple simple lines of code in the OnRender event of the data item with the hyperlink. It's disabled for 2, 4, and 6. 
 
Hope this helps. Let me know.</blockquote>

mwilliams

ALCE,

Glad I could help!

Let us know whenever you have questions.