Eclipse Community Forums: BIRT » Problem when adding totals

Home » Archived » BIRT » Problem when adding totals

Problem when adding totals [message #160657]

Fri, 12 May 2006 10:31

Eclipse User

Originally posted by: overfused.gmail.com

I have a big problem. I am using an SQL query to get totals from my table.
I'm doing all using the query in the data set part. Everything displays
fine. Then I'm using another data set to extract more totals from another
table and this is also working fine. Same thing goes for a third query.
The problem comes when I try to add these totals. Adding the totals from
the first query is not problem but as soon as I try to substract the
totals from the other two is when I run into trouble.

This is more or less the scenario

Name Amount
Cost Total $
Tax Total $ > this all comes from my query in Data Set1
Shipping Total $

Adjustments
Returns $ > this one comes from another query in Data Set2
Cancellations $ > this one comes from a third query in Data Set3

Adding the quantities from Data Set1 is no problem.. Subtracting the
quantity from Data Set2 and Data Set3 is the big problem since my
Total.sum has no access to these two rows ?

Does anyone know of a solution or a workaround?

Your help would be greatly appreciated.

Regards and thanks in advance :)

Tom.

Re: Problem when adding totals [message #161146 is a reply to message #160657]

Mon, 15 May 2006 14:50

Eclipse User

there might be something fishy with your "merged" sql querries. try to
declare some internal variables in your report that store all the totals
for each table and then add the values of those variables at the end or
wherever you want to display that sum.

cristian

Previous Topic:	format page number
Next Topic:	Request for Comments regarding an article (Callisto + BIRT)

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Nov 05 01:45:35 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter