Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Using several Flat Files for one chart
Using several Flat Files for one chart [message #718419] Wed, 24 August 2011 05:15 Go to next message
Jochen v. B. is currently offline Jochen v. B.
Messages: 7
Registered: May 2011
Location: Germany
Junior Member
Hi guys,

Iam currently having 7 reports that are using one Flat File (.csv) for several charts.
Due to new requirements I have to use 4 Flat Files (.csv) in these reports.
All 4 Flat Files have the same data column types.

Sounds easy but each chart in all reports needs the data of all 4 flat files.
I know that there are Joint Data Sets but in my opinion it seems kinda awkward to solve this problem with these Joint Data Sets for 4 Flat Files, because the solution would most likely look like this:

Data Set A using Flat File a
Data Set B using Flat File b
Data Set C using Flat File c
Data Set D using Flat File d
Joint Data Set 1. from Data Set A + B
Joint Data Set 2. from Data Set C + D
Joint Data Set from Joint Data Set 1. + 2.

Beside its unhandy solution, my major problem is that I need to do this for 7 reports in total which seems to be a huge time investment.

That's why Iam looking for a more efficient solution.

Can anybody help me please?

Best regards
Jochen
Re: Using several Flat Files for one chart [message #718553 is a reply to message #718419] Wed, 24 August 2011 12:28 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Take a look at this example that combines csv files:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1405-combine-csv-files/

Jason

On 8/24/2011 5:15 AM, Jochen v. B. wrote:
> Hi guys,
>
> Iam currently having 7 reports that are using one Flat File (.csv) for
> several charts.
> Due to new requirements I have to use 4 Flat Files (.csv) in these
> reports. All 4 Flat Files have the same data column types.
> Sounds easy but each chart in all reports needs the data of all 4 flat
> files.
> I know that there are Joint Data Sets but in my opinion it seems kinda
> awkward to solve this problem with these Joint Data Sets for 4 Flat
> Files, because the solution would most likely look like this:
>
> Data Set A using Flat File a
> Data Set B using Flat File b
> Data Set C using Flat File c
> Data Set D using Flat File d
> Joint Data Set 1. from Data Set A + B
> Joint Data Set 2. from Data Set C + D
> Joint Data Set from Joint Data Set 1. + 2.
>
> Beside its unhandy solution, my major problem is that I need to do this
> for 7 reports in total which seems to be a huge time investment.
>
> That's why Iam looking for a more efficient solution.
>
> Can anybody help me please?
>
> Best regards
> Jochen
Previous Topic:graphic elemet
Next Topic:Birt 2.6.1 runtime engine OutOfMemory - PermGen space
Goto Forum:
  


Current Time: Thu Jul 31 01:21:47 EDT 2014

Powered by FUDForum. Page generated in 0.01483 seconds