multiple parameters / subreports? -- without scripting?

Hi-

*noob mode on*

I'm wondering if it is possible to create a report that asks for iterative parameters without scripting or whether I need to take a subreport approach to this problem.

What I want to do is have a set of parameters (one for a start date, one for an end date) that the user fills in, and which are then presented to the database to retrieve the db's partition list. Using that partition list to narrow down the data, I wish to present a combo box with valid choices for a different parameter (customer groups) that exists within the previously selected data. [Only some of the groups are going to be valid within our timeframe.]

I'm thinking that I either need to script some of this, or create a subreport for the 2nd query but am unsure if that report can also have parameters that the user can change.

Any advice before I get too far into this would be great.

Find more posts tagged with

Comments

wli

Can you try out cascadeing parameter in BIRT? Using the starting and ending date as the parent parameters to limit the DB partition child parameter.

MII-Rich

I was able to make progress on a solution using cascading parameters, by prompting for the dates first.

That however is not what I want to do.

I want to interrogate table A to get the oldest record [based on some SQL] - this will give me the starting range of dates that I can present to the user. I can use the current date as the ending range. This also gives me the db partitions that are in use, [which I want to use to limit the number of rows returned].

I then want to present to the user only data present in those partitions, but which they have the option to select over.

Ideas?

Thanks in advance,
-R

rmurphy

You could do as you suggested in your initial post which is to create an initial report that provide the first level of detail with Hyperlinks to a sub-report.

Another approach would be to create your own parameter collection screens. You could use the DE API for this, or build collection pages using the JSP Tags.

Rob