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; } } }

hyperlinks in aggregation table fields

romanga

Hi,

I creates an aggregation field in my table. It is integer. It counts how many open tickets exist. Now i want to click on this number of tickets and get another report that will show me all open tickets with their description. how can I create the hyperlink on this aggregation field.

Thanks
Roman

Find more posts tagged with

Comments

kclark

What your trying to do is called a drill through report. There are examples of how to do this in Eclipse under Report Examples > Drill to Details. You can also find a tutorial at <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/389-birt-drill-through/'>this devshare</a>

romanga

The problem occures when I use fields that from type text (I created text fields with my logic. HTML type). This fields have no <hyperlink> tab in their properties and also this script is not working in this case. ( it does work when field is from other type. )

importPackage(Packages.org.eclipse.birt.report.model.api); 
importPackage(Packages.org.eclipse.birt.report.model.api.elements); 
 
dataHandle = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("bbb"); 
 
 
ac = StructureFactory.createAction(); 
ah = dataHandle.setAction( ac ); 
ah.setLinkType("drill-through"); 
ah.setReportName("DetailTwo.rptdesign"); 
ah.setTargetFileType("report-design"); 
ah.setTargetWindow("_blank");

how can I create hyperlink from this text field to another report? 
thanks.

Tubal

<blockquote class='ipsBlockquote' data-author="'romanga'" data-cid="111026" data-time="1351601192" data-date="30 October 2012 - 05:46 AM">
The problem occures when I use fields that from type text (I created text fields with my logic. HTML type). This fields have no <hyperlink> tab in their properties and also this script is not working in this case. ( it does work when field is from other type. )

how can I create hyperlink from this text field to another report? 
thanks. </blockquote>
 
If your fields are already HTML text, is it possible to create the hyperlink as part of your text in your logic? 
 
Instead of putting "myText" in your text field, you would put "<a href="www.myreportserver.com....myReport.rptdesign">myText</a> 
 
Another option would be to make your field a data field, put your text in quotes to make it text rather than data, and then use the hyperlink properties on that field.

romanga

Tubal, THANKS!

Your advice useing data field is working fine! And it has hyperlink options!

(I knew that I could create hyperlink in HTML text, but it my case it would be very complicated)