get individual totals based on group...

[abhi900]

Hi,

I have a "group 1" section based on field "Ts.TestPurpose" and all the associated total summary like - Passed , Failed, Executed, Planned, Blocked, No Run, NA and PassRATE(%).

The Summary COUNT totals for each group are set in Group Footer section and
GRAND RUNNING TOTALS for each Summary is set in REPORT FOOTER section.

Now,
I want totals of another Field but it is from a different table "TS.TestType" and it should be only for 1 value in that table - "E2E".
I tried inserting another group 2 based on this field but overall summary figures changes to totally incorrect values.

I want to find out a way to calculate totals for each group independent of each other.

Also, for "Group 1" i want to show Summary totals which do not carry any relationship with "E2E" from the second table rather this should be shown under the second "Group 2" for E2E thus excluding E2E from Group 1 totals.

Hope i have not made it confusing,

regards

 

[IanWaterman]

Please show eaxample of the data you have then a layout of what you want to see displayed.

Ian

 

[Madawc]

Take a look at Crosstabs. You find it under Insert and it is a quick way to get a set of grouped totals that are distinct from the report groupings.

It's a little more complex if you want just some of the details. But if you have one of the higher versions of Crystal, you should be able to define a formula field with something like:

If {field} = "E2E" then {your.value}
else 0

If you are talking about linking two tables and there is not always a one-to-one link, make it a left-outer link. And note that any test on the second table must start with an IsNull test. IsNull is also the way you test when there is no record on the second table.

It always helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.



Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

It sounds like you might want to have a main report where you exclude the E2E values in the record selection formula. Then add a subreport in the report footer that uses the second table. This way the addition of the table won't affect your original summaries.

-LB