How to exclude particular group summary from crystal report

[senweb]

Hi,

Can any one help me to find a solution for the follwing:

i don't want to show a selected group summary - how to do this?

Ex:
Group names are: A, B, C, D

all the above groups having sum() in its group footer.
here i don't want to show sum() of Group B and the rest
should be displayed.

Expecting your valuable reply in this regard.

By Sensa.

 

[lbass]

You can just right click on the summary->format field->suppress->x+2 and enter:

{table.groupfield} = "B"

-LB

 

[senweb]

Thanks for your valuable reply - its working fine but still i need some more information to reach my expected result.

as in the above example group B summary can be avoided through your help tip.

But in grand summary its showing along with group B summary.

expecting your valuable support in this regard - please.

regards,
sensa.

 

[lbass]

You could create a formula like this:

if [table.groupfield} <> "B" then
{table.amt} //field you are summing

Place this in the detail section and insert summaries on it at the group and grand total levels.

-LB

 

[senweb]

Thanks for your valuable reply.

i inset this formula in detail section

if {TempNewComm.Status} <> "(C) Spot Commission"
then {TempNewComm.PrdVlu}
else 0

but it says that the formula is wrong - required boolean.


please help me to solve this.

 

[lbass]

You need to create this formula in field explorer->formula->new and then drag it to the detail section.

-LB

 

[senweb]

Finally i done but in grand total its included while summing up.

i mean: i can able to show empty figure for the required group head's summary. But in grand total its included.

How can i remove a particular group head summary in grand summary.

expecting your valuable reply in this regard please.

 

[lbass]

You should be right clicking and inserting a summary on the same formula at the grand total level. It will not include the C values.

-LB

 

[lbass]

PS. I should have mentioned that this method cannot be used if you have record inflation--where values are duplicating because of table joins. In that case you would have to determine the pattern of duplication and then use running totals where you sum {TempNewComm.PrdVlu} and use a formula to evaluate on change of some field so you can eliminate the duplication, e.g.,

(
onfirstrecord or
{table.field} <> previous({table.field})
) and
{TempNewComm.Status} <> "(C) Spot Commission"

Reset never for a grand total or on change of group for a subtotal.

-LB

 

[senweb]

Dear Ibass,

I like to show report from one table only.
with grouping as:

Group A: Status
Group B: Worker code

And group summary for Group A & Group B
and Grand Summary at the bottom of page.

Here i don't want to show "Group A" summary if it is equal to "(C) Spot Commission" in Grand Summary.

Note: i don't want to show the summary but have to show the details.

Hope you understand better now.
Please help me to get a solution in this regard.

Expecting your valuable reply.

Thanks & Regards,
Sensa.

 

[lbass]

My suggestions have not changed. I think you need to show some sample data at the detail level with the results you are getting from using the conditional formula or the running total (if you have row inflation--you haven't explained that) and then explain what you are expecting to see.

-LB

 

[dev1212]

The solution provided by lbass should work. I used the same formula logic many times before. Creating summary on formula that returns number will work.