Eclipse Community Forums: BIRT » Generate a Distinct Table for Each Element in Parameter Array

Home » Archived » BIRT » Generate a Distinct Table for Each Element in Parameter Array(Given an array parameter, how can i generate a table for each element?)

Generate a Distinct Table for Each Element in Parameter Array [message #1822252]

Mon, 02 March 2020 10:06

Eclipse User

Let's say i have a .rptdesign that generates using a query like

SELECT * FROM foo JOIN bar ON foo.id = bar.foo_id where foo.site in ?

The report receives an array parameter, "reportSites", and runs in an application wrapped around the ReportEngine. Currently the application renders a single table with data displayed in aggregate for all selected sites.

Our users have requested an enhancement -- the ability to submit a list of sites and out a single report file that renders one table for each of the customer selected sites. Essentially, the output should appear as if the report were generated once for each selected site with the tables extracted into a single file. Any ideas on how to accomplish this?

Re: Generate a Distinct Table for Each Element in Parameter Array [message #1822890 is a reply to message #1822252]

Mon, 16 March 2020 08:22

Eclipse User

hi. have you found a solution? it seems I have the one

Re: Generate a Distinct Table for Each Element in Parameter Array [message #1823716 is a reply to message #1822890]

Tue, 31 March 2020 11:01

Eclipse User

I have not found a solution.

Previous Topic:	More than one Data Cubes in report do not work after migrating to Birt 4.8.0
Next Topic:	Display Consolidated data in the Last page of BIRT report

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Nov 09 00:07:51 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter