Drill-Down from Reports
HI,
I have created reports where I display Work Item ID's. I want to enable drill down from the report to open up these Work Item ID's if the user so chooses. How do i go about that. regards Bharani |
10 answers
Use the same URL that is used to open work items in the WEB UI.
|
Use the same URL that is used to open work items in the WEB UI. Hi Rafik, Where do i specify the url so that an automatic link is created. regards Bharani |
|
Click the report item that you want to behave like a link (a table cell is an example); then click the tab named Hyperlinks in BIRT's property editor and input javascript similar to this:
var serverURL = reportContext.getAppContext().get("SERVER_URL"); if (serverURL == null) serverURL = ""; serverURL + "#action=com.ibm.team.workitem.viewWorkItem&id="+row |
|
Sorry to get back late on this.
Where do I find the hyperlink in property editor. Could not find it in my report. i have attached a screenshot. |
|
You will need to click the table cell that is going to contain the hyperlink. Then the property editor will show the hyperlink property.
|
On 4/5/2010 10:07 AM, rjaouani wrote:
You will need to click the table cell that is going to contain the You also may need to replace the Data element with a Dynamic Text element. james RTC Reports Team Lead |
On 4/5/2010 10:07 AM, rjaouani wrote: You will need to click the table cell that is going to contain the You also may need to replace the Data element with a Dynamic Text element. james RTC Reports Team Lead Hi James, I have a similar requirement. I managed to establish the hyperlinks and it works fine. But I need to pass a report parameter from report A to report B to refine the query on the second report. Was under the impression that the the URL will change based on a parameter I send from report A and URL needs to manipulated to have that parameter included n the URL. It does not seem to be so in my case (URL of the target report remains same irrespective of parameter sent). Any suggestions/pointers in that direction would be of great help. Thanks & Regards, Mohan. |
|
On 5/10/2010 3:38 AM, mmksri76 wrote:
jmoodywrote:On 4/5/2010 10:07 AM, rjaouani wrote: Hi James, I have a similar requirement. I managed to establish the hyperlinks and it works fine. But I need to pass a report parameter from report A to report B to refine the query on the second report. Was under the impression that the the URL will change based on a parameter I send from report A and URL needs to manipulated to have that parameter included n the URL. It does not seem to be so in my case (URL of the target report remains same irrespective of parameter sent). Any suggestions/pointers in that direction would be of great help. Thanks& Regards, Mohan. You can construct the URL using Javascript, which should have access to the param[] objects for the report. Does that help? james RTC Reports Team Lead |
Hi James, Was away from office for some time. I have Java script written something like below in the URI field of hyperlink section on first report (as explained in the previous posting of this thread.
I do not see any place holder in the URL to manipulate / replace the parameter in the URL, as explained in WI_ID case. I think am missing something here. Requesting you to elaborate a bit on making param[] object accessible to the java script. Thanks, Mohan. |
|
On 5/18/2010 7:38 AM, mmksri76 wrote:
If you want to use, for example, a data set row, then you just use row as part of the construction of the URL. If you want to use a report parameter you can use params. If you want to use a javascript variable, just use it as normal. So for example, in your case you'd probably want the last line to be: serverURL + "#action=com.ibm.team.workitem.viewWorkItem&id=" + row; james RTC Reports Team Lead |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.