X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Sum A Formula, XI    
post Aug 22 2013, 02:04 PM

Posts: 486
Joined: 15-April 04
From: Georgia

Hi -
I am trying to create a total (summary) field for a report that I am creating in Crystal Reports XI that is based on a formula field. After pulling the formula field into the report, I clicked on the sigma symbol (circled in red). After doing that a box comes up (in yellow) that asks which field I want to summarize, but does not provide my formula field as an option, just the fields in the different tables.
Any advice on what I am forgetting to do in order run a total or average of the formula field? It has been about 3 years since I used Crystal Reports and I have forgotten a ton about the app.
Thanks in advance for your help.
See attached for the screen shot of the application and the fields referenced above.
Attached File(s)
Attached File  CR_Report_Layout.png ( 56.94K )Number of downloads: 5
Go to the top of the page
post Sep 5 2013, 10:29 AM

Posts: 215
Joined: 2-January 08
From: Upstate NY

I've never used Crystal Reports so take this with a grain of salt.
Have you tried creating a textbox on the "footer" section and adding the equation to sum your "formula" field of the main report? This may work, similar to Access.
I hope this helps,
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    14th December 2017 - 11:51 AM