Non-BIRT viewer and drill-through

Hi there, 
 
sorry for the re-posting of this thread, I originally posted in the designing reports forum, but I guess it's more a deployment issue. 
 
I have built a team report, listing activity count for each user, and a user report, which shows the individual activities for a specific user. 
 
Using BIRT designer, I added a drill-through from team report to user report, and tested it the preview, works a charm. 
 
Now, the reports are actually displayed in a viewer I developed, rather than the BIRT viewer, but the URL submitted on drill-through uses the BIRT viewer framset servlet. 
 
So I came to the conclusion I should use URI instead of drill-through. Not as elegant, but works fine. 
 
However, I currently hardcode the base url (<a class='bbc_url' href='http://localhost:8080/myApp/.../displayreport.jsp?reportName=myReport&myParam1=...)'>http://localhost:8080/myApp/.../displayreport.jsp?reportName=myReport&myParam1=...)</a>. While this is fine to prove the concept, a dynamic version of this will be required in production. 
 
Within the Birt report, is there a way to access the base url maybe through the reportContext object? I could not see an appropriate method. 
 
Thanks, 
Cedric

Find more posts tagged with

Comments

cypherdj

I managed to get this functionality working with my own viewer using a URI rather than drill-through. 
 
Basically, when I initialise the report engine, I pass in the PageContext object. Using the following code, I extract the requestURL: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
HttpServletRequest req = (HttpServletRequest) context.getRequest();

String reqURL = HttpUtils.getRequestURL(req).toString();
</pre>
 
I then set a config property on the report engine: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
reportEngine.getConfig().getAppContext().put("requestURL", reqURL);
</pre>
 
This can then be used by any report requiring drill-through to build the hyperlink: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
reportContext.getAppContext().get("requestURL") + "?__report=" + targetReport + "&recordID=" + row["recordID"]
</pre>
 
Hope that helps, 
Cedric

vishalkp

Hello Cedric,

I was finding help regarding passing the target report name dynamically in chart interactivity.

The thread you posted is somewhat helpful for me but you have mentioned that u have to initialise the report engine, I pass in the PageContext object. Using the following code, I extract the requestURL:

can u please tell me that where i have write this code.(Initailise, beforerender, on which event exactly)

it would be great help if u tell me some solution regarding your Thread
and if possible regarding passing the target report name dynamically in chart interactivity.

Thanks,
VishalKP

cypherdj

Hello VishalKP,

I think there might be some confusion here. The problem I am describing is to perform a drill-through using the BIRT APIs, therefore using java.

If I understand correctly, you wish to dynamically open a different report depending on which area of the chart is clicked by the user. Am I correct?

If you could provide more information about what you're trying to achieve, I'll be more than happy to help if I can,

Regards,
Cedric

vishalkp

Hello Cedric,

Thanks for your reply.
Yes you are right.

I had to open the report dynamically by clicking the parent report's y-axis, depending upon the value in the database in the linkto field for child report.

i did it successfully by publshing the child report and creating its rptdocument and giving that path in the URL of parent chart's y-axis interactivity.

Thank you for your thread, as it given me direction to go to...

Thanks again & sorry for delay in reply.

VishalKP.