Eclipse Community Forums: BIRT » Putting one row of a dataset to several table groups

Home » Archived » BIRT » Putting one row of a dataset to several table groups

Putting one row of a dataset to several table groups [message #1014784]

Tue, 26 February 2013 08:12

Eclipse User

Hi,
I have a dataset with following simple example structure:

Column1: Subject
Column2: Category

I have created a table based on this dataset which groups on category.

The problem now is that category may contain several values (and I dont know how many before running report!) like this: category 1;category 2

At the moment BIRT creates a group called category 1;category2. But what I need are two groups (splitted at Wink

- the dataset row needs to be placed twice in the table.

Any ideas how to realize this?

Thanx a lot!

Mark

Re: Putting one row of a dataset to several table groups [message #1014911 is a reply to message #1014784]

Tue, 26 February 2013 13:24

Eclipse User

So, you have data like:

Subject | Category
Subject1 | Category1
Subject1 | Category2
Subject2 | Category1
etc...

And want to see something like:

Subject1
Category1
Category2

Subject2
Category1

?

Or something else? If I'm misunderstanding, could you please clarify with some sample data or a sample report I can run? Thanks!

Re: Putting one row of a dataset to several table groups [message #1015026 is a reply to message #1014784]

Wed, 27 February 2013 03:49

Eclipse User

Hi,
no, following data situation:

Category | Subject
category 1 | Testdata 1
category 1 | Testdata 2
category 2 | Testdata 3
category1;category2 | Testdata 4

Following grouping should be presented in table:

category 1
---- Testdata 1
---- Testdata 2
---- Testdata 4
category 2
---- Testdata 3
---- Testdata 4

As you see, Testdata 4 is assigned to two categories (and maybe more in productive), that is my problem. Do you have any ideas?

Thanx!

Bye

Mark

[Updated on: Wed, 27 February 2013 04:28] by Moderator

Re: Putting one row of a dataset to several table groups [message #1015279 is a reply to message #1015026]

Wed, 27 February 2013 21:34

Eclipse User

You could use a scripted dataSet to split the dual category row into two rows. To do this, you'd just need to store the values from the original dataSet into arrays or something. Then, you'd access these arrays in your scripted dataSet to create your new result set. You could either split the rows when storing the values into your array(s) or split them when processing your data in the scripted dataSet. Let me know if you have questions.

Re: Putting one row of a dataset to several table groups [message #1015335 is a reply to message #1015279]

Thu, 28 February 2013 04:31

Eclipse User

The problem is that data is already provided by a Java scripted data set provided by a different vendor, so I have no possibility to change that.
Is there the possibility via a report scripting event to manipulate data that is provided by an existing datasource (and duplicate the row)?

Mark

Re: Putting one row of a dataset to several table groups [message #1015431 is a reply to message #1015335]

Thu, 28 February 2013 09:53

Eclipse User

Yes. That's what I described above. Take a look at this thread. It has a design that shows what I described above. If you have access to the script in the original dataSet that defines the rows, you don't need to create a new dataSet, you can simply modify the existing code to do this.

BIRT Exchange Forums - Create Multiple Rows out of a Single SSV Field

Previous Topic:	Birt Excel Issue
Next Topic:	split x-axis label into two lines

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 09:43:17 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter