Only showing one case of group 2

[Former Member]

I have group1 as Department and group2 as order type. I am trying to show simple thing like this.Sum of order amts by order type but this is what is displaying:

Dept            Ordertype

Medals      $100

Schools     $100

Trophy       Internet

                $300

but only shows the first order type

the problem is only shows one order type only for 1 of the departments, the last one. but all departments have many order types.

why does it show only 1 time

[abhilash_kumar · Accepted solution]

Hi Paul,

Is '$100' a value in the 'order type' column?

You would need to make sure you aren't suppressing Group #2 and displaying the info on Group #1. Suppress Group#1 and move everything to Group #2.

-Abhilash

[Former Member · Accepted solution]

it's showing only the last order type we have not all the others.

the group1 is the department. i have that on report footer 1.

the ordertype i have following that on

Report footer a

[Former Member · Accepted solution]

Hi Paul,

You need to create two groups 1) Department 2) order type.

Create a summary of Order Amount and placed that in second group footer "order type".

Hope the above information will help you.

-Naga

[Former Member · Accepted solution]

that what i am doing but it only shows one of the order types - here i hav image of the code. maybe you can see what is wrong here.

[Former Member · Accepted solution]

Hi Paul,

when i observed you screenshot you placed group 2 content in report footer, you need to move that to above groupfooter1.

--Naga.

[Former Member · Accepted solution]

this has 2 thngs needed. the last of the Departments, does not show order types At  ALL

the others are ok but the user wants the department to show first and then the order types.

[Former Member · Accepted solution]

Hi Paul,

To achieve that

1) you need to display Group header1 and group header 2 then move the group footer1 contents to group header1 and move the group footer2 contents to group header2.

2)Supress both group footer 1 & 2.

hope the above information will help you...

--Naga.

[Former Member · Accepted solution]

Hi Paul,

One more alternative way  i.e

As usually your workaround not to change..Please replace the group footers fields means like that

Group Footer 2 : {Group#1 Name}      {R Total 5}

Group Footer 1 : {Group#2 Name}      {R Total 6}

See all order types display or not?  I hope this seems to work..

Please make sure ASAP

tHANKS,

DJ

[Former Member · Accepted solution]

Hi Paul,

I think when you go with DJ work around that totals will be change. and also the groups names will be repeat depend on the sub groups.

Any way try that and let us know the status...

--Naga.

[Former Member · Accepted solution]

its' not quite doing correctly. It's not tallying correctly, not bringing in all the amounts to the total.

I think the issue is we want to show the total of all the order types first not after them., it's not natural way. When I put group1 in header1  and group2 in group 2 footer, it's correct amounts for the order types. so maybe i can just do a separate total for the dept.

Maybe I need 'whileprinting records' which i have not done before.

[Former Member · Accepted solution]

Hi Paul,

can you attach the report with saved data, i will check and update you.

--Naga.

[Former Member · Accepted solution]

Can I mail to your email or inbox, I dont' see any here.

[Former Member · Accepted solution]

Hi Paul,

you can click on my profile and my email is available there.

--Naga.

[ido_millet]

None of the Header/Footer gymnastics is relevant for this scenario.  Since you wish to see Grand Totals not by the top level of grouping, 2 good options are:

1. Simply insert a CrossTab (you can set Row to OrderType...)

- or, if the layout of a CrossTab is too restrictive -

2. Insert a Subreport grouped by OrderType at level 1.

[Former Member]

Hi Paul,

Order type is placed in gh1 or gh2...Please make sure

Need to check 'keep together' option in section expert for the particular section..

Provide any screenshot or more information.

Thanks,

DJ