Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Birt drill down chart(need information for showing target report on the same page)
Birt drill down chart [message #900040] Fri, 03 August 2012 11:19 Go to next message
Saurav Kumar is currently offline Saurav Kumar
Messages: 2
Registered: August 2012
Junior Member
Hi,
I am facing an issue with the Birt Drill Down Report. I have a requirement to have three level of reports. On clicking on level1 report I need to show the level 2 report in the same page. Further clicking on the level 2 report I need to show the level 3 report below level 1 and level 2 report.

Approach1 :
Created three report design file for level 1, level 2 and level 3. Selected drill through hyperlink feature and set the target report location "Same Frame/ Parent Frame". But the drill down report is actually replacing the parent report(i.e. level 1 report).

Approach 2: Used birt tag library for calling the level 1 report. but still no luck.

Kindly can you please provide some input on this.

Thanks,
Saurav

Report message to a moderator

Re: Birt drill down chart [message #900084 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900086 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900088 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900089 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900090 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900091 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900092 is a reply to message #900040] Fri, 03 August 2012 17:21 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Saurav,

Look at the attached example. It contains 3 jsp files. One that holds
two frames. The other two populate both frames. In the master report
(the one on top) I have a text element in the detail row of the first
column that contains a javascript function to update the bottom frame.

Jason

On 8/3/2012 11:19 AM, Saurav Kumar wrote:
> Hi,
> I am facing an issue with the Birt Drill Down Report. I have a
> requirement to have three level of reports. On clicking on level1 report
> I need to show the level 2 report in the same page. Further clicking on
> the level 2 report I need to show the level 3 report below level 1 and
> level 2 report.
>
> Approach1 :
> Created three report design file for level 1, level 2 and level 3.
> Selected drill through hyperlink feature and set the target report
> location "Same Frame/ Parent Frame". But the drill down report is
> actually replacing the parent report(i.e. level 1 report).
>
> Approach 2: Used birt tag library for calling the level 1 report. but
> still no luck.
>
> Kindly can you please provide some input on this.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Birt drill down chart [message #900214 is a reply to message #900084] Sun, 05 August 2012 12:55 Go to previous messageGo to next message
Saurav Kumar is currently offline Saurav Kumar
Messages: 2
Registered: August 2012
Junior Member
Hi Jason,
Thanks for your quick response. However I have a small query:
As in the example attached you have used frameset to display master and detail level report. Is there any other way to do the same. The reason why I am asking is that my application designed on JSF 1.2(which includes other components e.g. header body etc.) and I need to integrate the level 1 report inside that JSF page. However the frameset tags won't allow me to use the body tag of html/jsf page.

For the below approach :
I have two iframes that includes the two <birt:viewer> tags (one for level1 and one for level2) and while clicking on report 1 (pie chart slice or bar chart) is there any way to set the url for second <birt:viewer> tag(second level report) i.e. access the html components from inside of birt report.

Note:
I am getting out of memory error while running the 2-3 birt reports simultaneously. I have increased the app server JVM setting as you have mentioned in the forum but still no luck. Say from the future point of view if my application supports 50 odd users and all the users simultaneously access/generate the birt reports, will that create any problem for reports rendering such as "out of memory error".

Looking forward for your response.

Thanks,
Saurav

Report message to a moderator

Re: Birt drill down chart [message #900393 is a reply to message #900214] Mon, 06 August 2012 16:34 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
I assume you set MaxPermGen? Instead of using the tag libraries you can
specify the complete url for two iframes or frames. In the first report
you will have to do something similar to what I have in the example to
locate the second report and replace it when the user clicks on the
first. One thing you may want to do is do a clean install of the viewer
to tomcat and deploy the example I attached earlier and run it see how
it is done. If you want to call this from a chart you will need to use
the invokeScript as described here:
http://birtworld.blogspot.com/2009/12/calling-client-side-javascript-from.html

But instead of hiding and showing the table locate the the second frame
and reload the report in it.

Jason

On 8/5/2012 12:55 PM, Saurav Kumar wrote:
> Hi Jason,
> Thanks for your quick response. However I have a small query:
> As in the example attached you have used frameset to display master and
> detail level report. Is there any other way to do the same. The reason
> why I am asking is that my application designed on JSF 1.2(which
> includes other components e.g. header body etc.) and I need to integrate
> the level 1 report inside that JSF page. However the frameset tags won't
> allow me to use the body tag of html/jsf page.
>
> For the below approach : I have two iframes that includes the two
> <birt:viewer> tags (one for level1 and one for level2) and while
> clicking on report 1 (pie chart slice or bar chart) is there any way to
> set the url for second <birt:viewer> tag(second level report) i.e.
> access the html components from inside of birt report.
>
> Note:
> I am getting out of memory error while running the 2-3 birt reports
> simultaneously. I have increased the app server JVM setting as you have
> mentioned in the forum but still no luck. Say from the future point of
> view if my application supports 50 odd users and all the users
> simultaneously access/generate the birt reports, will that create any
> problem for reports rendering such as "out of memory error".
>
> Looking forward for your response.
>
> Thanks,
> Saurav

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:NullPointerException Platform.createFactoryObject
Next Topic:Overflow not working in BIRT runtime engine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 02:36:21 EDT 2013

Powered by FUDForum. Page generated in 0.01975 seconds