Trouble with totals

[raja2008]

Crystal reports XI R2
SQL server 2000 database


Group 1: PersonAssignedTo Total
Group 2: PersonSubmittedTo Total


Now my problem is The PersonSubmittedTo is also
in PersonAssignedTo ,I need the totals of PersonSubmittedTo (which will be the totals of that PersonSubmittedto from all the PersonAssignedto groups )to be displayed at the PersonAssignedTo level.

I tried using a running total with a formula like PersonSubmittedTo=Groupname1 but i'm getting the error "Running total cannot be referd to a print time formula"

I hope i'm clear.

I can't find a way to do it.Please help.
I looked around and didn't find much.

 

[HowardHammerman]

You will need to create a sub-report and link it to the main report using the id of the person assigned to as the linking field. You will need to insert logic so that you don't count self-assigned items.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[raja2008]

Thank you very much .that worked But i'm trying to avoid the Subreport,is there a calculation i can do to get it.

Group1: A Totals Atotal 5(2+3)
Group 2:
A 2
B 3
c 1
Group1: B BTotal 4(3+1)
Group2:
A 3
B 1
C 2
D 1

this is basically how the data is.
I want the totals to show up next to them.

Thank you.

 

[HowardHammerman]

No, you must use a sub-report.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[lbass]

Maybe I'm misunderstanding, but if the totals you want are at the report level (all A's in the report; all B's in the report), you could create two formulas:

//{@A}:
if {table.personsubmittedto} = "A" then {table.qty} //or 1 for a count

//{@B}:
if {table.personsubmittedto} = "B" then {table.qty} //or 1 for a count

Then create two additional formulas for the group #1 header section:

//{@sumA}:
sum({@A},{table.personassignedto})

sum({@B},{table.personassignedto})

Format {@sumA} to suppress using:

{table.personassignedto} <> "A"

Format {@sumB} to suppress using:

{table.personassignedto} <> "B"

-LB