| Author |
Message |
jjthed
Newbie
Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
|
   Posted: 27 Aug 2014 at 8:34am |
|
Hi DBlank,
Thanks a lot with the info. I did another group with a field value, but the total on the footer gives me a total on each row instead of at the end of the section. Any advise on that?
Thanks!
|
 IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Aug 2014 at 8:37am |
|
what did you group on?
|
|
IP Logged |
|
jjthed
Newbie
Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
|
Posted: 27 Aug 2014 at 10:44am |
|
I group on Category, and then sort in specific order, and it turns out each category is a group...
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 27 Aug 2014 at 10:51am |
You can hard code it as a formula like you did for the first grouping...
If Category in ["eyeliner","lip stick"] Then "Cat1" else "Cat2"
and group on that instead of category field.
The preferred method is to have some other value in a column in your data set that defines the grouping so that as your data set grows with different categories the report knows how to handle them.
Note you can use other fields to group on even if you are not displaying them in the report.
|
|
IP Logged |
|
jjthed
Newbie
Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
|
Posted: 27 Aug 2014 at 12:02pm |
|
Ah... I see. I will try that and play around to see if I can get what I want.
Thanks DBlank!!
|
|
IP Logged |
|
jjthed
Newbie
Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
|
Posted: 28 Aug 2014 at 7:03am |
|
just an update, it worked!!!!!!!!!!!!!!!!!!
I am so new at this and this is my first time designing a report from scratch. Now the structural part is done, I will move on to calculations. Will come back and ask more tips on the sum and totals if I am stuck again.
Thank you so much
|
|
IP Logged |
|
jjthed
Newbie
Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
|
Posted: 28 Aug 2014 at 12:24pm |
|
Here is a new questions:
In my detail section, I use the category field, my report now looks like this:
Item QTY Price
eyeliner 5 $7
eyeliner 3 $8
eyeliner 1 $6
I want it to look like this:
Item QTY Price
eyeliner 9 $7 (This is average price)
I used below formula to suppress the duplicate names:
{tempestimateitems.Category} = previous({tempestimateitems.Category})
Now I am stuck on how to sum up the QTY and put it in one line. And also need to average the unit price.
Thanks in advance!
|
|
IP Logged |
|
z9962
Senior Member
Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
|
Posted: 28 Aug 2014 at 9:59pm |
Create a group on
the item field,
Then create a
sum summary on qty.
Finally add an
average summary on Price Place these in the
item group header.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Aug 2014 at 3:52am |
You would also want to move the "item field" into the GH or GF next to the sum and avg results and suppress the GH and details section.
|
|
IP Logged |
|
jjthed
Newbie
Joined: 15 Aug 2014
Online Status: Offline
Posts: 20
|
Posted: 29 Aug 2014 at 7:49am |
|
I have create a group and put the "item field" in the group footer. I used the insert summery on qty but the number returned is not right..... did I do something wrong?
|
|
IP Logged |
|
|
|
