Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access subtotal in detail

Status
Not open for further replies.

slwilli

Programmer
Sep 24, 2002
5
US
I am new to Crystal (using 8.0) and need to be able to create a formula on detail lines that use the total of that detail. How do I do this?
 
you need to use variables and the 3 formula method to do this.. Please have a look at the FAQ area there is a very good FAQ on this. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
 
You can reference a subtotal at the detail level without variables by writing the subtotal into the formula. For instance the following formula will tell you what percentage a detail numeric field is of the subtotal for that field:

{table.Field} / Sum ( {table.Field} , {table.GroupField} ) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top