Stop drill-throughs in Excel export

How would I stop BIRT from placing the hyperlinks in an Excel spreadsheet when I export a BIRT report?

Find more posts tagged with

Comments

Please see attached example, you can set the action to null if the outputFormat is xls:

if(reportContext.getOutputFormat()=="xls")
this.action=null;

TheRealDea

Maybe I did something wrong. When I run my report/export, the field disappears. Ideally, the aggregate would stay and the hyperlink would go away. Is that what you code would be doing? Would I click the aggregate, then choose the script tab, then on-render --> is where I post your text?

TheRealDea

Sorry about my pre-mature response. Eclipse was not saving properly. It is working for me just fine. Thank you.

mwilliams

Another way would be to create 2 identical elements, only 1 without the hyperlink. Hide the hyperlinked one for XLS and the other one for all other outputs. Tianli's suggestion is probably the better one though.

mwilliams

Tianli,

That would be a good example to post in the devShare if you would. Thanks.

Tianli

This example has been posted in devShare please see:<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/540-little-trick-disable-the-hyperlink-according-to-the-output-format/'>Little trick: Disable the hyperlink according to the output format - Tips & Tricks - BIRT Exchange</a><br />
<br />
Thanks