Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Drill Through Multiple Parameters
Drill Through Multiple Parameters [message #702816] Tue, 26 July 2011 20:59 Go to next message
Rory  is currently offline Rory Friend
Messages: 7
Registered: July 2011
Junior Member
Hello,

I'm trying to create a drill through report. My master report contains sales by territory in a certain time period, and compares current to previous year
I have three parameters in the master report. PrevYear CurrYear and MothDay parameters. My detail report will contain sales by product group for the territory you click on. this report will contain the same three parameters but also needs a parameter for the territory, correct? I'm confused on how I should be bookmarking in the detail report and how to pass the parameters through.
Re: Drill Through Multiple Parameters [message #702856 is a reply to message #702816] Tue, 26 July 2011 22:06 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Rory

You may want to look at this:
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/drill/index.php

When building the hyperlink for the master report it should discover
which parameters are available in the detail report and you can assign
them to values in the current container for the hyperlink (in most cases
this will be a table). Take a look at the attached two reports.

Jason

On 7/26/2011 4:59 PM, Rory wrote:
> Hello,
>
> I'm trying to create a drill through report. My master report contains
> sales by territory in a certain time period, and compares current to
> previous year
> I have three parameters in the master report. PrevYear CurrYear and
> MothDay parameters. My detail report will contain sales by product group
> for the territory you click on. this report will contain the same three
> parameters but also needs a parameter for the territory, correct? I'm
> confused on how I should be bookmarking in the detail report and how to
> pass the parameters through.
  • Attachment: drill.zip
    (Size: 5.43KB, Downloaded 116 times)
Re: Drill Through Multiple Parameters [message #1090910 is a reply to message #702856] Tue, 20 August 2013 20:36 Go to previous messageGo to next message
Jeff Sexton is currently offline Jeff SextonFriend
Messages: 2
Registered: August 2013
Junior Member
This is an old post, but I have run into this same question.

What should the bookmark be when there are multiple parameters for the detail report? The example, which works fine, has only one parameter. I've made a detail report with two parameters. The master does correctly discover the parameters in the details report, but I can't put anything in the bookmark field that works. The link always says the bookmark is invalid when deployed to jBoss.

It works perfectly when previewed however.

Thanks
Re: Drill Through Multiple Parameters [message #1091525 is a reply to message #1090910] Wed, 21 August 2013 16:16 Go to previous message
Jeff Sexton is currently offline Jeff SextonFriend
Messages: 2
Registered: August 2013
Junior Member
I resolved this question.

If I change the link type from bookmark to table, and leave the bookmark field blank, it works.

I am a bit foggy on what these options are really doing though.
Previous Topic:How to run a birt report from jsp page
Next Topic:how to call birt report from jsp page
Goto Forum:
  


Current Time: Tue Dec 23 01:38:25 GMT 2014

Powered by FUDForum. Page generated in 0.01717 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software