Eclipse Community Forums: BIRT » Drill Through Multiple Parameters

Help

Home

Home » Archived » BIRT » Drill Through Multiple Parameters

Show: Today's Messages :: Show Polls :: Message Navigator

Drill Through Multiple Parameters [message #702816]

Tue, 26 July 2011 20:59

Rory

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.

Report message to a moderator

Re: Drill Through Multiple Parameters [message #702856 is a reply to message #702816]

Tue, 26 July 2011 22:06

Jason Weathersby

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 338 times)

Report message to a moderator

Re: Drill Through Multiple Parameters [message #1090910 is a reply to message #702856]

Tue, 20 August 2013 20:36

Jeff Sexton

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

Report message to a moderator

Re: Drill Through Multiple Parameters [message #1091525 is a reply to message #1090910]

Wed, 21 August 2013 16:16

Jeff Sexton

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.

Report message to a moderator

Previous Topic:	How to run a birt report from jsp page
Next Topic:	how to call birt report from jsp page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:10:19 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter