Eclipse Community Forums: BIRT » Graphics using dynamic parameters

Home » Archived » BIRT » Graphics using dynamic parameters(Graphics using dynamic parameters)

Graphics using dynamic parameters [message #769718]

Thu, 22 December 2011 10:30

Eclipse User

Hi everybody,

I created a report using two datasets. In the first data set I have a list of servers and possible metrics such as:

Server Metric
--------------------
Server1 CPU Usage
Server1 Memory Usage
Server1 Disk Usage
Server2 CPU Usage
Server2 Memory Usage
Server2 Disk Usage

In most cases I have the 3 same metrics for every server. I have created two dinamyc parameter which are filled with the information form this data set.

I created a second dataset which brings me all the information for each server and each metric within a range of time.

For example, I have the CPU Usage for the server1 like this:
Date;avg,min,max
2011-04-21 00:30:22:000;15;1;74
2011-04-21 17:20:03:000;8;0;66
2011-04-22 16:41:40:000;8;1;69
2011-05-04 17:01:52:000;29;9;60
2011-05-05 17:01:54:000;33;10;74

What I need to do is graph this information for each server, therefore I created a Table (grouped by server) like the attached file (report.jpg). It is in spanish but equipo=server, metrica=metric, promedio=average.

The resulting table has all the servers and all the metrics, but the graphics are not appearing. I tried the graph separatedly (changing the paremeter for values and it worked ok). What can be wrong? I´m not receiving any errors during the execution, so I have no idea where the problem is.

Regards,

Esteban

Attachment: report.jpg
(Size: 43.51KB, Downloaded 199 times)

Re: Graphics using dynamic parameters [message #769794 is a reply to message #769718]

Thu, 22 December 2011 12:10

Eclipse User

Can you put the data in flat files and change the datasets to use them
and post the report so we can run it?

Jason

On 12/22/2011 10:30 AM, Esteban Lus Bietti wrote:
> Hi everybody,
>
> I created a report using two datasets. In the first data set I have a list of servers and possible metrics such as:
>
> Server Metric
> --------------------
> Server1 CPU Usage
> Server1 Memory Usage
> Server1 Disk Usage
> Server2 CPU Usage
> Server2 Memory Usage
> Server2 Disk Usage
>
> In most cases I have the 3 same metrics for every server. I have created two dinamyc parameter which are filled with the information form this data set.
>
> I created a second dataset which brings me all the information for each server and each metric within a range of time.
>
> For example, I have the CPU Usage for the server1 like this:
> Date;avg,min,max
> 2011-04-21 00:30:22:000;15;1;74
> 2011-04-21 17:20:03:000;8;0;66
> 2011-04-22 16:41:40:000;8;1;69
> 2011-05-04 17:01:52:000;29;9;60
> 2011-05-05 17:01:54:000;33;10;74
>
> What I need to do is graph this information for each server, therefore I created a Table (grouped by server) like the attached file (report.jpg). It is in spanish but equipo=server, metrica=metric, promedio=average.
>
> The resulting table has all the servers and all the metrics, but the graphics are not appearing. I tried the graph separatedly (changing the paremeter for values and it worked ok). What can be wrong? IÂ´m not receiving any errors during the execution, so I have no idea where the problem is.
>
> Regards,
>
> Esteban
>
>

Re: Graphics using dynamic parameters [message #769841 is a reply to message #769794]

Thu, 22 December 2011 14:28

Eclipse User

Hi Jason,

I´m attaching three files, the report and two csv containing the data, on the report there are two tables, the first one references the tables but it´s hidden and it shows empty charts. The second table uses the flat files data and it shows the same chart for all the server-metric combinations.

Regards,

Esteban.

Attachment: data.csv
(Size: 22.94KB, Downloaded 182 times)
Attachment: equipos.csv
(Size: 0.29KB, Downloaded 219 times)
Attachment: graficos_test.rptdesign
(Size: 161.15KB, Downloaded 258 times)

Re: Graphics using dynamic parameters [message #771585 is a reply to message #769841]

Tue, 27 December 2011 12:31

Eclipse User

Esteban,

I still can not run the report.
You have sqlserver as one of the data sources. I did notice in the
first chart you did not bind your dataset parameters. Select the chart
and in the properties view look at the binding tab and click on the Data
Set Parameter Binding button, next click on the fx button and select the
values from the outer dataset to set the parameters for each instance of
the chart.

Jason

On 12/22/2011 2:28 PM, Esteban Lus Bietti wrote:
> Hi Jason,
>
> IÂ´m attaching three files, the report and two csv containing the data, on the report there are two tables, the first one references the tables but itÂ´s hidden and it shows empty charts. The second table uses the flat files data and it shows the same chart for all the server-metric combinations.
>
> Regards,
>
> Esteban.

Re: Graphics using dynamic parameters [message #774212 is a reply to message #771585]

Tue, 03 January 2012 09:13

Eclipse User

Hi Jason,

Sorry by the delay in my answer, I took a look at the report and the graph is binded to the dataset, I don´t undertand what you mean by "fx button", can you explain it?

Regards,

Esteban

Re: Graphics using dynamic parameters [message #774275 is a reply to message #774212]

Tue, 03 January 2012 11:15

Eclipse User

Yes you have the chart bound to the dataset but no parameters set for
it. Did you see the Data Set Parameter Binding... button? If you click
on it you can set the value for the inner data set. Take a look at the
attached example for more clarification. The table with the red box
uses a data set that needs a parameter. The parameter is set based on
an outer table column value.

Jason

On 1/3/2012 9:13 AM, Esteban Lus Bietti wrote:
> Hi Jason,
>
> Sorry by the delay in my answer, I took a look at the report and the
> graph is binded to the dataset, I don´t undertand what you mean by "fx
> button", can you explain it?
>
> Regards,
>
> Esteban
>

Attachment: nested.zip
(Size: 3.91KB, Downloaded 197 times)

Re: Graphics using dynamic parameters [message #774333 is a reply to message #774275]

Tue, 03 January 2012 13:15

Eclipse User

Hi Jason,

The link for the download is not working, can you check it?

Regards,

Esteban

Re: Graphics using dynamic parameters [message #774347 is a reply to message #774333]

Tue, 03 January 2012 13:50

Eclipse User

It worked for me. What version of BIRT are you using?

Jason

On 1/3/2012 1:15 PM, Esteban Lus Bietti wrote:
> Hi Jason,
>
> The link for the download is not working, can you check it?
>
> Regards,
>
> Esteban

Re: Graphics using dynamic parameters [message #774371 is a reply to message #774347]

Tue, 03 January 2012 14:41

Eclipse User

Hi Jason,

I mean the link for downloading the sample you sent in the previous email.

Regards,

Esteban

Re: Graphics using dynamic parameters [message #774824 is a reply to message #774371]

Wed, 04 January 2012 12:54

Eclipse User

It downloaded for me. Are you using browser of news reader?

Jason

On 1/3/2012 2:41 PM, Esteban Lus Bietti wrote:
> Hi Jason,
>
> I mean the link for downloading the sample you sent in the previous email.
>
> Regards,
>
> Esteban

Re: Graphics using dynamic parameters [message #775191 is a reply to message #774824]

Thu, 05 January 2012 09:35

Eclipse User

Hi Jason,

I downloaded ir from the forum and it worked.

I tried ruunning the report (the nested report you attached) and it is not bringing any information. If I change the parameter "orders" to IsRequired and then I select a specific order it works ok. If I uncheck the IsRequired mark it doesn´t bring any orders.
This is the same that is happening to me with my report because if I change the parameters to make them required I get the graphic in the report, the problem is I get the same graphic for all servers, if I leave the as not required the report is blank.

What can be wrong?

Regards,

Esteban

Re: Graphics using dynamic parameters [message #775281 is a reply to message #775191]

Thu, 05 January 2012 13:01

Eclipse User

Esteban,

That is because with no parameter set the query becomes
select *
from orders
where ordernumber =

where ordernumber is blank. You could always put script in the before
open of the dataset to add the where clause based on a parameter. For
example change the query in the report to

Select *
from orders

Then in the beforeOpen put:

if( params["order"].value ){
this.queryText = "select * from orders where ordernumber = " +
params["order"].value;
}

See the modified attached example.

Jason

On 1/5/2012 9:35 AM, Esteban Lus Bietti wrote:
> Hi Jason,
>
> I downloaded ir from the forum and it worked.
> I tried ruunning the report (the nested report you attached) and it is
> not bringing any information. If I change the parameter "orders" to
> IsRequired and then I select a specific order it works ok. If I uncheck
> the IsRequired mark it doesn´t bring any orders. This is the same that
> is happening to me with my report because if I change the parameters to
> make them required I get the graphic in the report, the problem is I get
> the same graphic for all servers, if I leave the as not required the
> report is blank.
>
> What can be wrong?
>
> Regards,
>
> Esteban

Attachment: nested.zip
(Size: 3.95KB, Downloaded 230 times)

Re: Graphics using dynamic parameters [message #777462 is a reply to message #775281]

Tue, 10 January 2012 09:55

Eclipse User

Hi Jason,

Sorry for the delay in my answer. I tried creating a new report as the nested you attached (which works ok) is but I can´t get it working. I noticed in the inner dataset the parameter is not bounded to the report parameter, but my inner datasource is throwing me an error that it cannot fecth the next row (see attached screen).
I´m also attaching you the report so you can take a look at it. I don´t know where the problem is.

I don´t want to abuse of your time but is there a way we can set up a webex or anything so you can take a look at the report "live" and test it?

Thanks a lot for your help.

Regards,

Esteban.

Attachment: new_report.rptdesign
(Size: 30.46KB, Downloaded 317 times)
Attachment: Dibujo.JPG
(Size: 112.43KB, Downloaded 299 times)

Re: Graphics using dynamic parameters [message #777512 is a reply to message #777462]

Tue, 10 January 2012 11:06

Eclipse User

Esteban,

Yes I can do a webex. Send me an email at jasonweathersby at windstream
dot net.

Jason

On 1/10/2012 9:55 AM, Esteban Lus Bietti wrote:
> Hi Jason,
>
> Sorry for the delay in my answer. I tried creating a new report as the nested you attached (which works ok) is but I canÂ´t get it working. I noticed in the inner dataset the parameter is not bounded to the report parameter, but my inner datasource is throwing me an error that it cannot fecth the next row (see attached screen).
> IÂ´m also attaching you the report so you can take a look at it. I donÂ´t know where the problem is.
>
> I donÂ´t want to abuse of your time but is there a way we can set up a webex or anything so you can take a look at the report "live" and test it?
>
> Thanks a lot for your help.
>
> Regards,
>
> Esteban.

Previous Topic:	Printing PS with BIRT
Next Topic:	BIRT 3.7 not show unicode characters

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 19:51:14 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter