summary problem 3

[buffy13]

Hello,

This is my problem I have at the moment. I know how to make a summary but I would like a selection out of that summary. For example: I only want to see the summary of the hours from a certain activity, not all the activities. what kind of formula should I use?

 

[dgillz]

If you just want to see the totals and not the details, you do no tneed any formula at all. Just right click on the detaisl section, and select hide section.

If you only want certain groups, then you need a group selection formula. Click on report, edit selection formula, group, and enter a formula like:

Sum({YourField},{YourGroupingField})>100

This will only show those groups with a sum greater than 100.

If you only want to see certain values of {YourGroupingField}, that would be a record selection formula. CLick on report, edit selection formula, record and enter a formula like:

{YourGroupingField} in ["ABC","DEF","XYZ"]

This would have the effect of limiting the values of {YourGroupingField} to the list above.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[buffy13]

My report looks something like this:

Activity Description Hours worked
PRT dffdfdj 5,00
VER dfkjdkfjdkl 3,00
ZIE dddkfj 2,00
VER dlfkdfk 8,00

Total hours: 18,00

Now I would like a summary next to the total hours summary for only the hours with the activity 'VER'. It should something like this then:

Activity Description Hours worked
PRT dffdfdj 5,00
VER dfkjdkfjdkl 3,00
ZIE dddkfj 2,00
VER dlfkdfk 8,00

Total hours: 18,00
Total hours activity VER: 11,00

Sorry if I'm not describing the problem well.

 

[dgillz]

What version of crystal are you using?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[buffy13]

Version 10

 

[dgillz]

I do not own 10, but in v8.5, insert, field object, running total field, make the runnint total a Sum() opraton, evaluate based on a formula, make the formula {Activivty}="VER", reset = never.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

You could try:

if {table.activity} = "VER" then {table.hoursworked}

Then right click on the formula and insert a summary (sum) to get the conditional subtotal.

-LB

 

[buffy13]

Thank you for your help, the formula workes perfectly