Problem with Path in Drill Through

Hello,

I have a problem with the report-path in a drill through.
I try to deploy BIRT as a plugin in Lotus Notes with a main report and a drill through for some details.
So far i have two reports (main and detail) which are linked. In Eclipse everything works well, i choose a bar in the main report and then the detail report pops up. When i start this under Lotus Notes, the main report cant find the path to the detail report.
It searches in the main folder of Notes. This is because the path in the main.rptdesign is set to "detail.rptdesign" without any path information.

My problem is, how to set the right path in the main report, so that the detail report will be found under lotus notes?

Both reports are in the same plugin.jar, which is installed under notes.

I hope someone can help me.

Greets
Florian

Find more posts tagged with

Comments

cypherdj

Hi Florian, 
 
not sure if this will fix your issue, but I came across a similar problem when using Birt reports within our web application. The problem is that the drill-through functionality builds the target url for your detail report based on the frameset servlet, which, in the context of notes, does not exist. 
 
The workaround I applied was to use the URI rather than drill-through. Obviously not as elegant as you have to build the url yourself and manually map your parameters, but this might get you started. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/forum/deploying-integrating-birt-report-engine-applications/11666-non-birt-viewer-drill-through.html'>http://www.birt-exchange.com/forum/deploying-integrating-birt-report-engine-applications/11666-non-birt-viewer-drill-through.html</a>

FloridaFlo

Hi cypherdj,

first of all, thanks for the quick answer. I tried your workaround but couldnt fix my problem.
I allways get this message in notes:

"run?__report=/D:/Notes/IBM/Lotus/Notes/Tester1.rptdesign&Datum=16.08.2006&__overwrite=true"

In Eclipse i just entered "Tester1.rptdesign" as the report. Where has to be the path in the normal call? is this the right style or has the path to be in front of the "?" ?

Back to your workaround:
Where do you get the "HttpServletRequest" class?
And is the "reportContext" a basic variable or did you create it?

thanks,

Florian

cypherdj

Hi Florian, 
 
what you need to do is to find out how to invoke the run servlet from within notes, and build the URI to that effect. 
 
The example I gave is for a web application, so it will be totally different within notes. You should not be concerned with any of the HttpServletRequest as this is web specific. 
 
reportContext is a standard Birt expression builder variable. You might be able to use this to find out how to build your URI. Create a dynamic text element in your parent report, and in the expression builder, enter the following script: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
reportContext.getHttpServletRequest().getQueryString()
</pre>
 
If you can post what gets displayed in this text element, I might be able to help you in figuring out how to build your drill-through. 
 
Regards, 
Cedric

FloridaFlo

Hi Cedric,

i tried it that way and all i get in Notes is this error:

There are errors evaluating script "reportContext.getHttpServletRequest().getQueryString()":
TypeError: Cannot call method "getQueryString" of null.

So the Servlet Request is null. I dont know what i can do.
Also the fact that the detailreport in Notes shows only the URL which is called by the drill through (like this: null?__report=Tester1.rptdesign&Datum=08.05.2006) lets me think about that the parentreport must call a method or something to start the detailreport.

Is there a possibility to set interactivity by a code. So that i get the selected row and say something like engine.openReport("detailreport.rptdesign+row"date").?

Thanks again.

Florian

FloridaFlo

Hi again,

i solved the problem by myself. I recognized that i wasnt using the BIRT Viewer in my plugin. I used the Report Engine and an outputstream via html to a normal browser. So its no wonder that the browser couldnt show the detailreport because he didnt know what to do. Now i implemented the BIRT Viewer and everything works.

The only question is if the reports can be located in the plugin. Because i dont know if the viewer can access them in a jar file.

Florian

cypherdj

Glad you got it solved.

With regards to running reports embedded in a jar file, I haven't done anything like this myself, but there have been other posts about this on the forum, have a dig around and you should be able to get some assistance with that.