Eclipse Community Forums: BIRT

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

Merging datasets [message #727247]

Tue, 20 September 2011 17:22

Angel

Messages: 2
Registered: September 2011

Junior Member

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 18:38]

Report message to a moderator

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

Wed, 21 September 2011 18:26

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

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

Report message to a moderator

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

Wed, 21 September 2011 19:46

Angel

Messages: 2
Registered: September 2011

Junior Member

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 167 times)
Attachment: pdfReportView.bmp
(Size: 725.91KB, Downloaded 194 times)

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:13:26 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter