Eclipse Community Forums: BIRT » How to calculate SUM cumulative times type of string?

Home » Archived » BIRT » How to calculate SUM cumulative times type of string?(How to calculate SUM cumulative times type of string in format HH:mm:ss)

How to calculate SUM cumulative times type of string? [message #768509]

Tue, 20 December 2011 04:34

Eclipse User

I have cumulative times in format HH:mm:ss and they display how much time did some record been in specific status. In database they are all STRING values.
How to calculate SUM of that times? should I use some sql expression or some BIRT function for this?
This is the example with statuses.
For this example I must exclude from result statuses CLOSED and ADDINFNDD.
So the final result should be : 00:01:59+00:00:05+34:20:58+00:00:07 = 34:23:09

Thanks for help!!

Attachment: CUMULATIVE.jpg
(Size: 19.44KB, Downloaded 2293 times)

[Updated on: Tue, 20 December 2011 04:45] by Moderator

Re: How to calculate SUM cumulative times type of string? [message #768729 is a reply to message #768509]

Tue, 20 December 2011 12:03

Eclipse User

Take a look at this example:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1450-time-string-sum/

I would just use a dataset filter to remove the sums you do not want.

Jason

On 12/20/2011 4:34 AM, cankovicv wrote:
>
> I have cumulative times in format HH:mm:ss and they display how much time did some record been in specific status. In database it is all STRING values.
> How to calculate SUM of that times? should I use some sql expression or some BIRT function for this?
> This is the example with statuses.
> For this example I must exclude from result statuses CLOSED and ADDINFNDD.
> So the final result should be : 00:01:59+00:00:05+34:20:58+00:00:07 = 34:23:09
>
> Thanks for help!!
>

Re: How to calculate SUM cumulative times type of string? [message #769233 is a reply to message #768729]

Wed, 21 December 2011 11:10

Eclipse User

Thank you Jason you are legend!!!

Can I ask you one more question which is not so related with this topic?

I use parameter in some data set which asks for the name of the COMPANY and result is some graphic (not list table result).
When I use only one company graphic is correct.

But when I use % for displaying all companies the result is blank graphic. Does this cant be done through the parameters - for graphic results?

Parameter is defined as required and string text box, and data set is calling parameter COMPANY like ?

index.php/fa/6524/0/

Thanks again

Attachment: parameter.jpg
(Size: 46.55KB, Downloaded 2193 times)

Re: How to calculate SUM cumulative times type of string? [message #769764 is a reply to message #769233]

Thu, 22 December 2011 11:38

Eclipse User

Can you post the report? You may want to add a table for testing to see
if the dataset is returning values. I am attaching an example that
uses a like query.

Jason

On 12/21/2011 11:10 AM, cankovicv wrote:
> Thank you Jason you are legend!!!
>
> Can I ask you one more question which is not so related with this topic?
>
> I use parameter in some data set which asks for the name of the COMPANY and result is some graphic (not list table result).
> When I use only one company graphic is correct.
>
> But when I use % for displaying all companies the result is blank graphic. Does this cant be done through the parameters - for graphic results?
>
> Parameter is defined as required and string text box, and data set is calling parameter COMPANY like ?
>
>
> Thanks again

Attachment: likequery.zip
(Size: 3.60KB, Downloaded 359 times)

Re: How to calculate SUM cumulative times type of string? [message #772693 is a reply to message #768509]

Fri, 30 December 2011 06:23

Eclipse User

Hi Jason,

sorry I can not open your example. Here is my report if you can find the problem. When I use ? to select all companies I am getting blank result.
I think that data set is OK in general, probably it is the problem with like query.

Thanks for help

Attachment: ChangeRequests Delivery Date1.rptdesign
(Size: 128.96KB, Downloaded 373 times)

[Updated on: Fri, 30 December 2011 06:24] by Moderator

Re: How to calculate SUM cumulative times type of string? [message #774248 is a reply to message #772693]

Tue, 03 January 2012 10:28

Eclipse User

I did not see any like clauses in your query. In my example I use:
select *
from products
where productname like ?

You may also want to verify that you have the string quoted like:

select *
from products where productcode like'%'

Jason

On 12/30/2011 6:23 AM, cankovicv wrote:
> Hi Jason,
>
> sorry I can not open your example. Here is my report if you can find the problem. When I use ? to select all companies I am getting blank result.
> I think that data set is OK in general, probably it is the problem with like query.
>
> Thanks for help
>

Previous Topic:	Column sum based on another column
Next Topic:	MySQL JDBC Driver 5.5 troubleshooting

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 05:51:24 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter