Eclipse Community Forums: BIRT » Drill Through Multiple Parameters

Home » Archived » BIRT » Drill Through Multiple Parameters

Drill Through Multiple Parameters [message #702816]

Tue, 26 July 2011 16:59

Eclipse User

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 18:06

Eclipse User

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

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

Tue, 20 August 2013 16:36

Eclipse User

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 12:16

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 10:36:47 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter