Home » Archived » BIRT » Graphics using dynamic parameters(Graphics using dynamic parameters)
| Graphics using dynamic parameters [message #769718] |
Thu, 22 December 2011 15:30  |
 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 181 times)
|
|
|
| Re: Graphics using dynamic parameters [message #769794 is a reply to message #769718] |
Thu, 22 December 2011 17:10  |
|
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 #771585 is a reply to message #769841] |
Tue, 27 December 2011 17:31 |
|
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 #774275 is a reply to message #774212] |
Tue, 03 January 2012 16:15 |
|
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 179 times)
|
|
| | | |
| Re: Graphics using dynamic parameters [message #774824 is a reply to message #774371] |
Wed, 04 January 2012 17:54 |
|
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 #775281 is a reply to message #775191] |
Thu, 05 January 2012 18:01 |
|
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 202 times)
|
|
| |
| Re: Graphics using dynamic parameters [message #777512 is a reply to message #777462] |
Tue, 10 January 2012 16:06 |
|
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.
|
|
|
Goto Forum:
Current Time: Fri Apr 19 22:39:24 GMT 2024
Powered by FUDForum. Page generated in 0.03886 seconds |
] 
Search
Help
Register
Login
Home
