Buddy, thanks very much. I'll do this next time I get access to the db. I can
only get there about once a week but I will let you know how it goes. Regards,
Steve
----- Original Message -----
From: Walker, Buddy
To: RBASE-L Mailing List
Sent: Saturday, January 31, 2009 2:54 PM
Subject: [RBASE-L] - RE: Adding a calculation to a report
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
To: RBASE-L Mailing List
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
