Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Graphics using dynamic parameters(Graphics using dynamic parameters)
Graphics using dynamic parameters [message #769718] Thu, 22 December 2011 10:30 Go to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 88 times)
Re: Graphics using dynamic parameters [message #769794 is a reply to message #769718] Thu, 22 December 2011 12:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 #771585 is a reply to message #769841] Tue, 27 December 2011 12:31 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 65 times)
Re: Graphics using dynamic parameters [message #774333 is a reply to message #774275] Tue, 03 January 2012 13:15 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 67 times)
Re: Graphics using dynamic parameters [message #777462 is a reply to message #775281] Tue, 10 January 2012 09:55 Go to previous messageGo to next message
Esteban Lus Bietti is currently offline Esteban Lus Bietti
Messages: 21
Registered: October 2011
Junior Member
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.
Re: Graphics using dynamic parameters [message #777512 is a reply to message #777462] Tue, 10 January 2012 11:06 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Tue Jul 29 13:14:56 EDT 2014

Powered by FUDForum. Page generated in 0.02887 seconds