nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hyperlink in Crosstab report

A@vi

Hello,

Currently i am using MyEclipse Blue 7.5 birt report. I want to give hyperlink in the crosstab column.
But not able to.
I want to give hyperlink on Student Name , so that it will link to other page.
Its happening but instead of name ,it is showing the link itself in the report.It is linking to the particular page which is correct. Only i need the name in the report.

This is the code :

<extended-item extensionName="DimensionView" id="198759">
<property name="dimension">Group1</property>
<property name="levels">
<extended-item extensionName="LevelView" name="NewLevel View1" id="198760">
<property name="level">Group1/SName</property>
<property name="member">
<extended-item extensionName="CrosstabCell" id="198761">
<property name="content">
<data name="SName" id="198762">
<property name="style">NewStyle2</property>
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10px</property>
<property name="textAlign">left</property>
<property name="resultSetColumn">SName</property>
<structure name="action">
<property name="linkType">hyperlink</property>
<expression name="uri">data["urlForReport"]</expression>
<property name="targetWindow">_blank</property>
</structure>
</data>
</property>
<property name="textAlign">left</property>
<property name="width">100px</property>
</extended-item>
</property>
</extended-item>
</property>
</extended-item>

In other report I put a hyperlink in a table . it is working fine.

<expression name="uri">row["urlForReport"]</expression>

But in Crosstab report its not working.

Can anyone help ??

Thanks

Find more posts tagged with

Comments

mwilliams

Can you recreate what you're doing with the sample database and attach the reports in here so I can see what you're doing? Thanks.

A@vi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72071" data-time="1294700902" data-date="10 January 2011 - 04:08 PM">
Can you recreate what you're doing with the sample database and attach the reports in here so I can see what you're doing? Thanks. </blockquote>
 
 
Thanks for reply....... 
I had fixed this issue by doing some R&D. 
I created a dummy dataset. & added it to the crosstab group.I hide the dummy column. 
In fetch method i called the service. 
Now it is working. 
 
Thanks

A@vi

I have another problem in this report.
The Hyperlink which i am providing in the report, it shows the link with an underline in it.
But i don't want that underline to be visible.
Is there any option to remove that underline ?

Want Help.

Thanks...

mwilliams

I'll have to look into this. If the style of the hyperlink that BIRT creates isn't changeable, maybe creating your own hyperlink with an HTML tag in a text element will allow it. If I figure out a way to get rid of the underline, I will post back in here.

mwilliams

Looks like you'll have to create a hyperlink using a text control and set the text-decoration property to none. I haven't tried it, but that should work. Let me know.

A@vi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72123" data-time="1294763708" data-date="11 January 2011 - 09:35 AM">
Looks like you'll have to create a hyperlink using a text control and set the text-decoration property to none. I haven't tried it, but that should work. Let me know. </blockquote>
 
Thanks for reply... 
I have tried with text-decoration as well as text-underline property ,by setting it to none. 
But no change is affecting to the link.

mwilliams

Hmmm... I will take a look closer at this option and let you know if I find anything further.

A@vi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72130" data-time="1294767926" data-date="11 January 2011 - 10:45 AM">
Hmmm... I will take a look closer at this option and let you know if I find anything further. </blockquote>
 
Thanks for looking into the issue. 
Can we change the underline color ? Is there any such option ? 
Or it comes by default with birt report ? 
If we can change color then then we can change it to white color so that it will be invisible. 
 
Thanks 
Avinash

mwilliams

Avinash,

Try something like:

<a style="text-decoration: none;" href="http://www.google.com">hyperlink</a>

A@vi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72137" data-time="1294772731" data-date="11 January 2011 - 12:05 PM">
Avinash, 
 
Try something like: 
 
<a style="text-decoration: none;" href="<a class='bbc_url' href='http://www.google.com">hyperlink</a>'>http://www.google.com">hyperlink</a></a> </blockquote>
 
 
But this we have to write in jsp page. 
I am not using any jsp page. Directly from MyEclipse 7.5 Birt i am giving the hyperlink. 
 
This is the cell , where i am giving the hyperlink : 
This is a normal table where i am giving hyperlink . 
 
<cell id="75"> 
<property name="borderBottomColor">#000000</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftColor">#000000</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightColor">#000000</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
<property name="borderTopColor">#000000</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1px</property> 
<data id="92"> 
<property name="marginTop">0pt</property> 
<property name="resultSetColumn">studentName</property> 
<structure name="action"> 
<property name="linkType">hyperlink</property> 
<expression name="uri">row["urlForReport"]</expression> 
<property name="targetWindow">_blank</property> 
</structure> 
</data> 
</cell> 
 
 
Thanks, 
Avinash

mwilliams

I think you're going to have to build the hyperlinks by yourself in text controls and do it the way I showed you. You'd just have to replace your data element in your post with a text element and set the type to HTML and use javascript to build the HTML link. I don't know that there's a way to change that formatting of a hyperlink in BIRT.

A@vi

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72187" data-time="1294846588" data-date="12 January 2011 - 08:36 AM">
I think you're going to have to build the hyperlinks by yourself in text controls and do it the way I showed you. You'd just have to replace your data element in your post with a text element and set the type to HTML and use javascript to build the HTML link. I don't know that there's a way to change that formatting of a hyperlink in BIRT. </blockquote>
 
Ok ... I will try with this one... 
 
Thanks

Shreelekha

Hi..

Is there any way to remove the underline?
and to change the column color when clicked on column?
I am using birt 3.2, I ahve added hyperlinks to the column,

Regards
Shreelekha

mwilliams

Take a look at this devShare post:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1311-removing-underline-from-hyperlink/

As for clicking on the value and changing the color, a user's link color usually changes by default if they've visited the link before. Are you wanting to change the link to a specific color? Let me know.

Shreelekha

Hi mwilliams,

Thanks a lot for replying.. I have made the changes,it's working fine now..

I have few doubts hope you'll help me...

1.Does Birt (open source) support client side sorting? so it should not hit the DB again.
2.Is it possible to do sorting without drill-through?
Because when i click on column header(hyperlink) it's reloading the report.
3.Is there any way to do sorting without reloading the report?

I'll be waiting for your reply.. please help me mwilliams.

Thanks
Shreelekha

mwilliams

Actuate's interactive viewer supports resorting without hitting the database again. You can find a trial on the downloads page if you want to check it out. Open source BIRT does not do this out of the box. You'd have to create this functionality on your own. You could try to use the .rptdocument to do this. Or you could also try creating multiple tables sorted different ways and hide/show the appropriate table using client side script.

Shreelekha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117475" data-time="1370762725" data-date="09 June 2013 - 12:25 AM">
Actuate's interactive viewer supports resorting without hitting the database again. You can find a trial on the downloads page if you want to check it out. Open source BIRT does not do this out of the box. You'd have to create this functionality on your own. You could try to use the .rptdocument to do this. Or you could also try creating multiple tables sorted different ways and hide/show the appropriate table using client side script. </blockquote>
 
Hi Michael 
 
Thank you for your reply:). You suggested me to use .rptdocument for sorting. 
Plesae suggest me. I'm new to birt.... 
1.How to use .rptdocument in birt hyperlink? 
2.What is .rptdocument? 
3.Does .rptdocument support client side sorting? 
 
Can you please send me a sample .rptdesign,which has used .rptdocument for column sorting 
and a client side java script to do this... 
Will be waiting for your reply... 
 
Thanks 
Shreelekha

mwilliams

I don't have an example doing this and don't have the time to create one right now. The .rptdocument is the document that is created by the run task when separate run and render tasks are used. It contains the data needed to render the report, so you could try to use this document to grab your data and re-render the report/table without re-running everything. Good luck!

Shreelekha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117496" data-time="1370880185" data-date="10 June 2013 - 09:03 AM">
I don't have an example doing this and don't have the time to create one right now. The .rptdocument is the document that is created by the run task when separate run and render tasks are used. It contains the data needed to render the report, so you could try to use this document to grab your data and re-render the report/table without re-running everything. Good luck! </blockquote>
 
Hi Michael 
 
Thank you for your quick reply.. 
How can i remove the hyperlink added to the column header for sorting.When i print the report in html format. 
I'm able to do this if report is exported as PDF. 
I'm using 
if (reportContext.getOutputFormat()!="html") 
this.action = null; in OnRender. 
I am not able to remove hyperlink if report exported as Excel.. 
Could you please help me... 
 
Thanks 
Shreelekha

mwilliams

This works for me when exporting to XLS from the viewer: 
 
onRender of label element with hyperlink 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if(reportContext.getOutputFormat() != "html"){
this.action = null;
}
</pre>

Shreelekha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117614" data-time="1371059872" data-date="12 June 2013 - 10:57 AM">
This works for me when exporting to XLS from the viewer: 
 
onRender of label element with hyperlink 
<pre class='_prettyXprint _lang-auto _linenums:0'>
if(reportContext.getOutputFormat() != "html"){
this.action = null;
}
</pre></blockquote>
 
Hi... 
Thank you for your quick reply... 
How to disable sorting when table does not have any data...? 
I'm using drill-through,it reloads the report each time when I click on the column header... 
This should not happen when table is empty..how to do this? 
please help me on this... 
 
 
Regards 
Shreelekha

Shreelekha

Please reply to my question Michael

Thanks
Shreelekha

mwilliams

You should be able to create an aggregation in your table to give you a "COUNT". Depending on this value, you could do the same as above, set the action to null. Hope this helps.

Shreelekha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117724" data-time="1371522325" data-date="17 June 2013 - 07:25 PM">
You should be able to create an aggregation in your table to give you a "COUNT". Depending on this value, you could do the same as above, set the action to null. Hope this helps. </blockquote>
 
Hi Michael.. 
 
Thank you for replying.. 
I have a report name example.rptdesign 
I run the birt report in html format. but the problem is when i export the report as PDF it's 
saved without extension(PDf) like `example`. 
birt report save without extension(PDF). It should save as `task.pdf`. 
 
Please help me 
 
Thanks 
Shreelekha

mwilliams

When you export to PDF from the viewer, it's not including the .pdf? Let me know. I've never seen this before. What is your BIRT version again? You said before BIRT 3.2, but there is no such version. Can you look at one of your report's xml source and see what the version info is? Thanks.

Shreelekha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117767" data-time="1371615479" data-date="18 June 2013 - 09:17 PM">
When you export to PDF from the viewer, it's not including the .pdf? Let me know. I've never seen this before. What is your BIRT version again? You said before BIRT 3.2, but there is no such version. Can you look at one of your report's xml source and see what the version info is? Thanks. </blockquote>
 
Hi.. 
Thank you for your quick reply.. 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.23" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 4.2.2.v201301221637 Build <4.2.2.v20130206-1509></property> 
Correct me if i'm wrong, my birt version is 3.2.23. 
 
When I export to PDF from the viewer, it's including the .pdf. 
But When I export to PDF from my web application where I have deployed the reports(Reports are done using birt) it's not including the .pdf? I am using all birt viewer plugins which is need.. 
 
Can you give me a solution? 
 
Thanks 
Shreelekha

mwilliams

The BIRT version is actually 4.2.2. It can be kinda confusing, I know.

If it's a problem with exporting from your app, I'll probably need to see more of how you're exporting from it. Especially since it's working fine for you from the web viewer. Let me know.

Shreelekha

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="117775" data-time="1371620292" data-date="18 June 2013 - 10:38 PM">
The BIRT version is actually 4.2.2. It can be kinda confusing, I know.

If it's a problem with exporting from your app, I'll probably need to see more of how you're exporting from it. Especially since it's working fine for you from the web viewer. Let me know. </blockquote>
 
Hi... 
 
Thanks a lot:)..It's working now.. 
I had applied sorting on column headers(drill-through). 
In Ubuntu it is working, I can click anywhere on the column header to perform sorting. 
To make it work in Ubantu(12.04). I did changed css added display:block; to column header. 
Where as in windows we have to click on the text. 
 
Please suggest me Michael 
 
Thanks 
Shreelekha

mwilliams

Not sure I'm understanding the issue. Is your column header much larger than the text and you only want the link to work when clicking on the text, but it's working anywhere within the header cell on Ubuntu? Or something else? Let me know.

Shreelekha

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="117834" data-time="1371796388"><div>Not sure I'm understanding the issue. Is your column header much larger than the text and you only want the link to work when clicking on the text, but it's working anywhere within the header cell on Ubuntu? Or something else? Let me know.</div></blockquote>Hi..Thanks a lot for your reply [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:12px;]Michael.

[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;font-size:12px;] [/color]It's a css change it's working now in windows....If I remember correctly I had asked you to send a sample report which has sorting using drill-through but it should not re-run the report when I click on column header.You suggested me to use [font="arial, sans-serif;font-size:13px;"] .rptdocument... My bad luck you were busy...

[/font][font="arial, sans-serif;font-size:13px;"] [/font] so you could not create sample report..I did a research on this but didn't get any usefull results...Michel I need your help,hope you'll help me on this..

ThanksShreelekha