Subtotals, Grand Totals, and Summeries - Not showing

[Estandridge]

Ok, have another question for you guru's of Crystal Reports.. All of you have been a lot of help and it is greatly appreciated, haven't been able to find many resources like this anywhere. So on to my question:

First, I still don't understand the difference between subtotals, grand totals, and summeries, anyone have a simple definition? Seems like they all add the numbers in a specified way.

Second, On the report I'm working on, (Why couldn't they have given me a simple one to learn the basics?), I'm trying to calculate total sales for a specified month by year. I've done this before with no problem, but this time with the fields I'm using, everytime I try to get a total I get 0's across everything. I tried even just including three fields through the report expert (Year, Month, and Total Sales), and the totals still came up as 0's even thought there are values coming up in the origional fields. Anyone have any thoughts on this, or why subtotals wouldn't work at all?

Thanks for your help!!

 

[synapsevampire]

You might want to read up on the 3 pass system Crystal uses for processing data.

There are a few ways to create totals, based on the version of your software, which you didn't share.

A simple example would be the choices offered by right clicking a number in the details section and selecting Insert:

Grand Total: Used to get a total for that field for the entire report. This is performed at the Read level pass so the number could be available anywhere in the report.

SubTotals/Summaries: These are similar in how they are implemented and are used to get totals at group levels (or you can select multiple groups and even Grand Totalsa all at once in some versions) and are available anywhere in the report, not just after the details (though the default will be for them to be created at the group footer level, you can drag them to the header).

Running Totals: These are performed at the printing pass, so a group level total would only be available at the group footer after the data has been read at the detail level.

You might try reading up at the BO site and at kenhamady.com, another excellent resource.

-k

 

[synapsevampire]

SOrry, I didn't address your concern about the totals.

Other people don't know which type of total you're using, what it's totaling, nor where it is in the report, so please at least supply basic information.

There's also the 3 formula method for doing calcs:

Group Header:
whileprintingrecords;
numbervar MyNum:=0;

Details:
Group Header:
whileprintingrecords;
numbervar MyNum:=MyNum+{table.field};

Group Footer (you'll display the results here):
whileprintingrecords;
numbervar MyNum:=0