Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT CHART : Multiple Dataset on one Y - Axis
BIRT CHART : Multiple Dataset on one Y - Axis [message #805137] Thu, 23 February 2012 11:25 Go to next message
Saurabh Puri is currently offline Saurabh PuriFriend
Messages: 10
Registered: February 2012
Junior Member

I have a problem creating a dynamic chart in BIRT.
The problem statement is as follows:
I have multiple tables stored in sql and user can select any number of tables for comparison on single y axis. X- axis is simply a time stamp. As there can be any number of tables selected so the dataset has to be created dynamically and the number of lines on a line chart will also be decided dynamically.

Please can you guide me how to accomplish the same.

i tried to generate the query dynamically using Java.

Please suggest if there is any other way to using joint statement as the data is huge and cause system to hang while using joint statement.

Regards
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #806295 is a reply to message #805137] Fri, 24 February 2012 19:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Are you currently using the DE API to create the report?

Jason

On 2/23/2012 6:25 AM, Saurabh Puri wrote:
>
> I have a problem creating a dynamic chart in BIRT.
> The problem statement is as follows:
> I have multiple tables stored in sql and user can select any number of
> tables for comparison on single y axis. X- axis is simply a time stamp.
> As there can be any number of tables selected so the dataset has to be
> created dynamically and the number of lines on a line chart will also be
> decided dynamically.
>
> Please can you guide me how to accomplish the same.
>
> i tried to generate the query dynamically using Java.
>
> Please suggest if there is any other way to using joint statement as the
> data is huge and cause system to hang while using joint statement.
>
> Regards
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #806303 is a reply to message #806295] Fri, 24 February 2012 20:06 Go to previous messageGo to next message
Saurabh Puri is currently offline Saurabh PuriFriend
Messages: 10
Registered: February 2012
Junior Member
Hi,

Yes i am currently using DE for making report and Chart engine API as well for creating charts.
But i wish to make template or design file and then edit it to display the charts using API.

Also i am confused with the fact whether through API's, i can plot different dataset for different series drawn on a single line chart or can execute different query on different series of Y - axis drawn on single line chart.

Please guide.

Regards




Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #807841 is a reply to message #806295] Mon, 27 February 2012 04:09 Go to previous messageGo to next message
Saurabh Puri is currently offline Saurabh PuriFriend
Messages: 10
Registered: February 2012
Junior Member
Hi Jason,

Can you please guide for the same... some suggestions for the same will be helpful

Regards
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808492 is a reply to message #807841] Mon, 27 February 2012 21:03 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Currently the designer only supports attaching one data set to a chart.
You can somewhat get around this by loading up java script arrays on
multiple hidden tables and then in chart script replace the data values,
but this does require some complex scripting. Attached is an example
that shows how to replace the series values using a js array.

Jason

On 2/26/2012 11:09 PM, Saurabh Puri wrote:
> Hi Jason,
>
> Can you please guide for the same... some suggestions for the same will
> be helpful
>
> Regards
>
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808495 is a reply to message #807841] Mon, 27 February 2012 21:03 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Currently the designer only supports attaching one data set to a chart.
You can somewhat get around this by loading up java script arrays on
multiple hidden tables and then in chart script replace the data values,
but this does require some complex scripting. Attached is an example
that shows how to replace the series values using a js array.

Jason

On 2/26/2012 11:09 PM, Saurabh Puri wrote:
> Hi Jason,
>
> Can you please guide for the same... some suggestions for the same will
> be helpful
>
> Regards
>
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808499 is a reply to message #807841] Mon, 27 February 2012 21:03 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Currently the designer only supports attaching one data set to a chart.
You can somewhat get around this by loading up java script arrays on
multiple hidden tables and then in chart script replace the data values,
but this does require some complex scripting. Attached is an example
that shows how to replace the series values using a js array.

Jason

On 2/26/2012 11:09 PM, Saurabh Puri wrote:
> Hi Jason,
>
> Can you please guide for the same... some suggestions for the same will
> be helpful
>
> Regards
>
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #808502 is a reply to message #807841] Mon, 27 February 2012 21:03 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Currently the designer only supports attaching one data set to a chart.
You can somewhat get around this by loading up java script arrays on
multiple hidden tables and then in chart script replace the data values,
but this does require some complex scripting. Attached is an example
that shows how to replace the series values using a js array.

Jason

On 2/26/2012 11:09 PM, Saurabh Puri wrote:
> Hi Jason,
>
> Can you please guide for the same... some suggestions for the same will
> be helpful
>
> Regards
>
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #809038 is a reply to message #808502] Tue, 28 February 2012 12:23 Go to previous messageGo to next message
Saurabh Puri is currently offline Saurabh PuriFriend
Messages: 10
Registered: February 2012
Junior Member
Hi,

The solution means that I should first create a hidden table where its columns are binded with data from various dataset and then setting the table rows as a global array and then populating the chart series based on this array using a script.


Is the above solution speed efficient as i have data of million lines.
Can i get around by creating a temporary table in sql which store my various selection and then use that temporary table to plot chart.

I think Sql is faster than BIRT engine... Please suggest.

Regards
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #809581 is a reply to message #809038] Wed, 29 February 2012 02:32 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I would think doing this with something on the db side would be much
quicker than loading up a bunch of stuff in a js array. I am not sure
how you are going to trigger the creation of the temp table but reading
from it into a new dataset should be simple enough.

Jason

On 2/28/2012 7:23 AM, Saurabh Puri wrote:
> Hi,
>
> The solution means that I should first create a hidden table where its
> columns are binded with data from various dataset and then setting the
> table rows as a global array and then populating the chart series based
> on this array using a script.
>
>
> Is the above solution speed efficient as i have data of million lines.
> Can i get around by creating a temporary table in sql which store my
> various selection and then use that temporary table to plot chart.
>
> I think Sql is faster than BIRT engine... Please suggest.
>
> Regards
>
Previous Topic:Chart SDK 3.7.2 - suddenly my marker lines and colors gone?!
Next Topic:Date Formatting Issue
Goto Forum:
  


Current Time: Fri Dec 03 17:30:21 GMT 2021

Powered by FUDForum. Page generated in 0.02805 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top