Steve
If the DB Calc doesn't help then you could
Before printing the report create a variable vSumToHr, vTotalHours
SET VAR vSumTotHr INTEGER
SET VAR vTotalHours DOUBLE
In the variables for your report
Detail section
vSumTotHr = (.vSumTotHr + TotMinHrs)
Report footer section
vTotalHours = (.vSumTotHr / 60)
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Steve
Holanov
Sent: Saturday, January 31, 2009 2:32 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Adding a calculation to a report
Buddy:
I did look at DB Calc but there were very few options for calculations,
mainly a few built items such as Sum and Count.
Here is my proposed SQL:
SELECT (SUM(CALLSHET.TOTMNHRS FROM Memberbasics))/60
where TOTMNHRS is my column that is totaled (actually minutes per row)
CALLSHET is the table
I need to divide the TOTMNHRS by 60 to get hours since the data is
actually in minutes.
Thanks,
Steve
----- Original Message -----
From: Walker, Buddy <mailto:[email protected]>
To: RBASE-L Mailing List <mailto:[email protected]>
Sent: Saturday, January 31, 2009 1:57 PM
Subject: [RBASE-L] - RE: Adding a calculation to a report
Steve
Have you looked at DB Calc. If you post your SQL statement it
would help with answers or suggestions.
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of
Steve Holanov
Sent: Saturday, January 31, 2009 1:45 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Adding a calculation to a report
I have two questions about adding a calculation to a report:
1. When I create a new variable how do I add it to the report
form? Either in a header/footer or preferably at the end of the table
data in the report body?
2. I can easily define the calculation I want in SQL but cannot
get the expression builder to accept my SQL string. Any tips for this
would be appreciated.
Thanks in advance,
Steve Holanov
Shrewsbury First Aid Squad
Shrewsbury, NJ 07702
