Normal Topic Report Calculations (Read 2631 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Report Calculations
Mar 20th, 2005 at 10:00pm
Print Post Print Post  
Hi -

I have designed an extremely simple report; however, I am having problems with the calculation I need in the report footer.  It just isn't there.

The report consists of only two layout elements: 

Name                          Paid

John Doe                     $15.00
Mary Doe                     $15.00
John Smith                   $20.00

What I need in the report footer is a 'count' of the number of names, and a sum of the money collected.

In report designer I added the following layout elements to the Report Footer:

Count
[Total # of Subscriptions]
Name

Sum
[Total Amount Paid]
Paid

The 'visible' option is set to true.

The report is fine, however, the summary calculations do not appear.  Any suggestions as to what I am overlooking?
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Report Calculations
Reply #1 - Mar 20th, 2005 at 11:07pm
Print Post Print Post  
Do you have anything in the Group Footer for calculations?
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Report Calculations
Reply #2 - Mar 21st, 2005 at 1:21am
Print Post Print Post  
Bob -

I thought I had tried it in the group footer and it didn't work.  I just ADDED it to the group footer, though, and left a copy in the report footer - the calculation worked. 

Do I need to leave it in both places?

Also, the 'label' did not print.  Can't I have something like:  Total:  preceding the calculation?

In any event, thanks for getting me this far.  The calculations were critical.
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Report Calculations
Reply #3 - Mar 21st, 2005 at 1:42am
Print Post Print Post  
To make a label, add a Static Element above the calculation cell.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged