on 09-18-2014 12:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.