Sum a field that references another sum

[sschaller]

I have a formula in the detail section of my report that references the sum of another field. I need to get a sum of this formula field but Crystal tells me I can't do that. Is there any way to achieve this? It's Crystal 9 pulling data from Timeslips.

 

[lbass]

Create two formulas:

//{@accum} to be placed in the detail section:
whileprintingrecords;
numbervar sumx := sumx + {@yourformula};

//{@display} to be placed in the report footer:
whileprintingrecords;
numbervar sumx;

-LB

 

[sschaller]

Thanks lbass that works beautifully for sums. Is there a way to use that functionality to get the average of a field instead of a sum?

 

[lbass]

//{@accum} to be placed in the detail section:
whileprintingrecords;
numbervar sumx := sumx + {@yourformula};
numbervar cnt := cnt + 1;

//{@display} to be placed in the report footer:
whileprintingrecords;
numbervar sumx;
numbervar cnt;
sumx/cnt

-LB

 

[vsimpkins]

hi, i have a client who has just gotten a new computer. she's using Timeslips 10.5 enterprise with crystal reports xi and having trouble connecting to the timeslips data. anyone have any thoughts on this. i should say also that her old machine had Timeslips 10.5 enterprise with crystal reports v8. i've searched several message boards, forums and internet, and called Sage, and getting no where.

Valerie Simpkins

http://www.pacetraining.com

 

[sschaller]

Valerie,
Crystal 11 is not compatible with any versions of Timeslips. I don't know the exact reason but I know that it doesn't work. You can use any version of Crystal up to 10 with Timeslips. Peachtree, which is owned by the same company as Timeslips, always includes a copy of Crystal and they are just going to Crystal 10 (from 9) with their newest release this summer. So I doubt Timeslips is going to be compatible with Crystal XI any time soon.

Steve Schaller
TriStar Data Systems

 

[vsimpkins]

Thanks for the info. Quick question, what is the correct data source to use with Timeslips? I had the client install version 8 on her computer, and i don't know what data source should be selected. I've tried several data source connections and it won't work. I've been unable to find any documentation on this. My client says she's the only person in her office who was using Crystal and her consultant is no where to be found. Thanks again for your help.

Valerie Simpkins

http://www.pacetraining.com

 

[sschaller]

You have to install an add-on for Timeslips that creates a datasource specifically for Timeslips. Once you install that add-on for Timeslips you will see a datasource called Timeslips. I think you may have had to pay for the code to install that add-on for Timeslips 10.5. I have Crystal config codes for every version starting with Timeslips 2005 but I don't go back any further than that. I'm not sure where you would find the config code for 10.5 at this point.

Steve Schaller
TriStar Data Systems

 

[lbass]

Valerie,

Next time please start a separate thread. Yours post has nothing to do with the current topic.

-LB