[AccessD] Crystal 2008 Question

All,

I have a curiosity question.  I have never worked with Crystal Reports, but I have heard about it a bit.  How does it compare to using Access for reporting?  I find the reporting capabilities of Access to be quite powerful.  Is Crystal even better?

Thanks,
Brad




-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Doris Manning
Sent: Tue 1/11/2011 7:41 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Crystal 2008 Question
 
Crystal is seeing Footer1-Field1 as a formula based on adding up all the
Field1 entries and dividing by the number of Field1 entries to get the
average of Field1.  You could try creating your own formula
Sum(Average(Field1)).

Doris Manning
Senior Developer & Database Administrator
Hargrove Inc. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
Sent: Monday, January 10, 2011 11:00 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Crystal 2008 Question

I don't know if anyone can help me with this question but here goes:
 
I am trying to create a crystal report with groupings.  In the detail
records, I 
have field (Field 1) that is averaged in a group 1 footer field 
(Footer1-Field1).  That works fine.  My issue is when I get to grouping 2. 
How 
do I sum Footer1-Field1?  When I click on the field and and choose Insert, 
Summary; I do not get an option for Summing (I get Maximum, Minnimum, Count,

etc.).  It appears that Crystal is seeing Footer1-Field1 as a string (or is 
something else is going on).  If I could sum each of the Footer1-Field1
fields 
the problem would be solved.  

 
If I click on the orginal field (Field 1), I can select the option insert, 
running total.  I do not get this option when I click on the group 1 footer 
field (Footer1-Field1).  Can I not total a footer field as I would in
Access.
 
 
Thanks!
 
Dale


      
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.