Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Merging datasets(Merge multiple datasets from same XML datasource)
Merging datasets [message #727247] Tue, 20 September 2011 13:22 Go to next message
Angel is currently offline 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 14:38]

Report message to a moderator

Re: Merging datasets [message #727646 is a reply to message #727247] Wed, 21 September 2011 14:26 Go to previous messageGo to next message
Jason Weathersby is currently offline 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

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Merging datasets [message #727670 is a reply to message #727646] Wed, 21 September 2011 15:46 Go to previous message
Angel is currently offline 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

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 23:22:20 EDT 2013

Powered by FUDForum. Page generated in 0.01415 seconds