Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Table of one month, sum data from timestamps ofone day
Table of one month, sum data from timestamps ofone day [message #1357359] Thu, 15 May 2014 13:37 Go to next message
dominik geiler is currently offline dominik geiler
Messages: 1
Registered: May 2014
Junior Member
Hi all,

warning first: i am totaly new to birt.

i have that sql statement:

SELECT *   FROM gp8.rc_orders, rc_reports
where gp8.rc_orders.Timestamp_PLC_Start between rc_reports.Starttime and rc_reports.Endtime


The table and output looks like:

ID_Machine  ID_Function	 Timestamp	OrderNo  	running_meters_needed	running_meters      Timestamp_PLC_Start  	Timestamp_PLC_End	Laufzeit	uc_offset_min


3	1	01.04.2014 21:35	3421418		2021	0		01.04.2014 21:34	01.04.2014 21:34	0			60				
3	2	02.04.2014 07:40	3421418		2021	2079	        01.04.2014 21:34	02.04.2014 07:40	256			60				
3	1	07.01.2014 05:01	3327005		2640	0		07.01.2014 05:01	07.01.2014 05:01	0			60				
3	2	07.01.2014 08:29	3327005		2640	2634	        07.01.2014 05:01	07.01.2014 08:29	208			60				
3	1	07.01.2014 08:30	3327004		240	0		07.01.2014 08:29	07.01.2014 08:29	0			60				
3	2	07.01.2014 08:44	3327004		240	234		07.01.2014 08:29	07.01.2014 08:44	14			60		
[...]


Now i want to make a month report.
From day 1 to 31 and not each timestamp.
I want to sum the "running_meters".
Should looks like:
3	1	01.01.2014 24044			
3	2	02.01.2014 35078	


Have i to use an other sql-statement or can i use birt for doing it?


Hope you understand my problem.


cheers
Re: Table of one month, sum data from timestamps ofone day [message #1371773 is a reply to message #1357359] Wed, 21 May 2014 14:36 Go to previous message
Kristopher Clark is currently offline Kristopher Clark
Messages: 130
Registered: January 2013
Senior Member
dominik geiler wrote:
> Hi all,
>
> warning first: i am totaly new to birt.
>
> i have that sql statement:
>
> SELECT * FROM gp8.rc_orders, rc_reports
> where gp8.rc_orders.Timestamp_PLC_Start between rc_reports.Starttime and
> rc_reports.Endtime
>
>
> The table and output looks like:
>
>
> ID_Machine ID_Function Timestamp OrderNo
> running_meters_needed running_meters Timestamp_PLC_Start
> Timestamp_PLC_End Laufzeit uc_offset_min
>
>
>
> 3 1 01.04.2014 21:35 3421418 2021 0 01.04.2014
> 21:34 01.04.2014 21:34 0 60
> 3 2 02.04.2014 07:40 3421418 2021 2079
> 01.04.2014 21:34 02.04.2014 07:40 256 60
> 3 1 07.01.2014 05:01 3327005 2640 0 07.01.2014
> 05:01 07.01.2014 05:01 0 60
> 3 2 07.01.2014 08:29 3327005 2640 2634
> 07.01.2014 05:01 07.01.2014 08:29 208 60
> 3 1 07.01.2014 08:30 3327004 240 0 07.01.2014
> 08:29 07.01.2014 08:29 0 60
> 3 2 07.01.2014 08:44 3327004 240 234
> 07.01.2014 08:29 07.01.2014 08:44 14 60
> [...]
>
>
> Now i want to make a month report.
> From day 1 to 31 and not each timestamp. I want to sum the
> "running_meters".
> Should looks like:
>
> 3 1 01.01.2014 24044
> 3 2 02.01.2014 35078
>
>
> Have i to use an other sql-statement or can i use birt for doing it?
>
>
> Hope you understand my problem.
>
>
> cheers
>

Hi Dominik! Are you wanting to sum running meters in the footer? From
the palette there is an aggregation item that you can place in the
footer. Once you've dragged that onto the report you can select what to
aggregate and what aggregation function you want. If you want a running
sum you can use that or use some SQL magic for it too, let me know if
you have any questions :)
Previous Topic:External Connection - Netezza
Next Topic:xls export failing for large data Birt 2.6.2
Goto Forum:
  


Current Time: Tue Oct 21 10:38:41 GMT 2014

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

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