|
Re: BIRT CHART : Multiple Dataset on one Y - Axis [message #806295 is a reply to message #805137] |
Fri, 24 February 2012 19:52 |
|
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 #808492 is a reply to message #807841] |
Mon, 27 February 2012 21:03 |
|
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 |
|
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 |
|
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 |
|
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 #809581 is a reply to message #809038] |
Wed, 29 February 2012 02:32 |
|
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
>
|
|
|
Powered by
FUDForum. Page generated in 0.04279 seconds