Eclipse Community Forums: BIRT

Home » Archived » BIRT » Merging datasets(Merge multiple datasets from same XML datasource)

Tue, 20 September 2011 13:22

Eclipse User

Hi,

I am new to BIRT. I have an XML datasource that has the following format.

<ActivityLog>
<Description>This description 1 could have a very long information and may wrap to next line.</Description>
<Description>This description 2 could have a very long information and may wrap to next line.</Description>
<Description>This description 3 could have a very long information and may wrap to next line.</Description>
<Date>2011-09-05</Date>
<Date>2011-08-05</Date>
<Date>2011-10-05</Date>
<CreatedBy>Angel</CreatedBy>
<CreatedBy>Sue</CreatedBy>
<CreatedBy>Robert</CreatedBy>
</ActivityLog>

I would like to display the data in the report in the following format.

Description(Dataset1):------------Date(Dataset2):---CreatedBy(Dataset3):
This description 1 could-----------2011-09-05--------Angel
have a very long information
and may wrap to next line.
This description 2 could-----------2011-08-05--------Sue
have a very long information
and may wrap to next line.
This description 3 could-----------2011-10-05--------Robert
have a very long information
and may wrap to next line.

But currently it is displaying the report like this.

Description(Dataset1):------------Date(Dataset2):---CreatedBy(Dataset3):
This description 1 could-----------2011-09-05--------Angel
have a very long information-------2011-08-05--------Sue
and may wrap to next line----------2011-10-05--------Robert
This description 2 could
have a very long information
and may wrap to next line.
This description 3 could
have a very long information
and may wrap to next line.

This is because in order for me to display all the information in the datasets, I had to created 3 different Tables so that I can bind the datasets to those tables.

Any suggestion is much appreciated!

Angel

[Updated on: Tue, 20 September 2011 14:38] by Moderator

Re: Merging datasets [message #727646 is a reply to message #727247]

Wed, 21 September 2011 14:26

Eclipse User

Angel,

Can you post a pic of what it looks like currently?
Also any chance to change the xml structure?

Jason

On 9/20/2011 1:22 PM, Angel wrote:
> Hi,
>
> I am new to BIRT. I have an XML datasource that has the following format.
>
> <ActivityLog>
> <Description>This description 1 could have a very long information and
> may wrap to next line.</Description>
> <Description>This description 2 could have a very long information and
> may wrap to next line.</Description>
> <Description>This description 3 could have a very long information and
> may wrap to next line.</Description>
> <Date>2011-09-05</Date>
> <Date>2011-08-05</Date>
> <Date>2011-10-05</Date>
> <CreatedBy>Angel</CreatedBy>
> <CreatedBy>Sue</CreatedBy>
> <CreatedBy>Robert</CreatedBy>
> </ActivityLog>
>
> I would like to display the data in the report in the following format.
>
> Description(Dataset1): Date(Dataset2): CreatedBy(Dataset3):
> This description 1 could 2011-09-05 Angel
> have a very long information and may wrap to next line. This description
> 2 could 2011-08-05 Sue
> have a very long information and may wrap to next line. This description
> 3 could 2011-10-05 Robert
> have a very long information and may wrap to next line.
> But currently it is displaying the report like this.
>
> Description(Dataset1): Date(Dataset2): CreatedBy(Dataset3):
> This description 1 could 2011-09-05 Angel
> have a very long information 2011-08-05 Sue
> and may wrap to next line. 2011-10-05 Robert
> This description 2 could have a very long information and may wrap to
> next line.
> This description 3 could have a very long information and may wrap to
> next line.
>
> This is because in order for me to display all the information in the
> datasets, I had to created 3 different Tables so that I can bind the
> datasets to those tables.
>
> Any suggestion is much appreciated!
>
> Angel

Re: Merging datasets [message #727670 is a reply to message #727646]

Wed, 21 September 2011 15:46

Eclipse User

Hi Jason,

Thank you for the quick reply. The pics of part of the Layout and part of pdf report is uploaded.

The schema and xml files have to be generated from a backend code and to change the code is very complex. Was wondering if we can work with the current format we have.

Specialist names were removed for confidentiality purpose.

Thanks!
Angel

Attachment: LayoutView.bmp
(Size: 762.88KB, Downloaded 223 times)
Attachment: pdfReportView.bmp
(Size: 725.91KB, Downloaded 226 times)

Previous Topic:	Flat file data source
Next Topic:	[SOLVED] Problem with OSGI platform (BIRT 3.7 on JBoss AS 6)

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 05:40:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter