Drill-Down from Reports

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
hyperlink. Then the property editor will show the hyperlink property.

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
hyperlink. Then the property editor will show the hyperlink property.

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:
You will need to click the table cell that is going to contain the
hyperlink. Then the property editor will show the hyperlink
property.


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.


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

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.

var serverURL = reportContext.getAppContext().get("SERVER_URL"); 

if (serverURL == null) serverURL = ""; 

serverURL + "#action=com.ibm.team.reports.viewQuery&queryUUID=_mVyU4F2mEd-W45bJdtcjpA&name=User%20Assigment%20details%20-%20by%20user%20v2"

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:

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.


var serverURL =
reportContext.getAppContext().get("SERVER_URL");

if (serverURL == null) serverURL = "";
serverURL +
"#action=com.ibm.team.reports.viewQuery&queryUUID=_mVyU4F2mEd-W45bJdtcjpA&name=User%20Assigment%20details%20-%20by%20user%20v2"

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.

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