Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Grouping Post Reply Post New Topic
<< Prev Page  of 2
Author Message
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 03 Oct 2016 at 5:52am
How are you grouping? Do you have other groups in your report? What are they>

You will need to group by this formula BEFORE you do any grouping by item number in order to get this to work.

-Dell
IP IP Logged
TanyaCVV
Newbie
Newbie
Avatar

Joined: 06 Sep 2016
Online Status: Offline
Posts: 17
Quote TanyaCVV Replybullet Posted: 03 Oct 2016 at 6:53am
There is a group # 1 :
{INVENTORY.WHSE} in {?BV99IN01FromWarehouse} to {?BV99IN02ToWarehouse} and
{INVENTORY.CODE} in {?BV99IN03FromPartNumber} to {?BV99IN04ToPartNumber} and
{UNIT_OF_MEASURE.SELL_UOM} = 1 and
(if instr({?BV99PC01FromProductCode},"?") = 0 // when there are no wildcards
    then {INVENTORY.PROD} in {?BV99PC01FromProductCode} to {?BV99PC02ToProductCode}
else lookslike({INVENTORY.PROD},{?BV99PC01FromProductCode})) and
(if not({?BV99IN23IncludeHeldItems})
    then {INVENTORY.HOLD} = 0
else
    {INVENTORY.HOLD} < 2) and
{INVENTORY.INV_DESCRIPTION} in ["GOLDEN STARTENA (layers - extra small crumble) 25k", "GOLDEN LAYENA TEX 25kg", "GOLDEN LAYENA L 25kg", "GOLDEN GROWENA 25kg", "HORSE BLOCK 25KG", "HORSE PLUS 25 KG", "BMZ 3KG", "ATHLETE HORSE 20kg", "Apple chunks 10Kg", "APPLE CHUNKS - 1 kg Package", "EQUILIBRIUM OPTIMAL 25kg", "EQUILIBRIUM EQUILIZER 25kg", "EQUILIBRIUM INTEGRI-T 25kg", "EQUILIBRIUM FIBRA CLASSIC 25kg", "EQUILIBRIUM FIBRA PLUS 25kg", "EQUILIBRIUM PRO PLUS 25kg", "EQUILIBRIUM TRIMAX 20kg", "EQUILIBRIUM SPORT XT 20kg", "EQUILIBRIUM MATERNITY XT 20kg", "VELOCI-T MAX 20kg", "VELOCI-T TRADITION 20kg", "OMOLENE SENIOR ACTION 20kg", "OMOLENE SPORT PLUS 20kg", "OMOLENE SPORT 200 20kg", "OMOLENE MATERNITY 300 20kg", "EVOLUTION SENIOR 20kg", "EVOLUTION SPORT ELITE 20kg", "EVOLUTION JUVENILE 20kg", "EVOLUTION MATERNITY 20kg", "SIMPLICI-T NATURE 25kg", "SIMPLICI-T PRO GRAIN 25kg", "SIMPLIC-T PRO 25kg", "SIMPLICI-T ORIGINAL 25kg", "SIMPLIC-T FIBRA 25kg"] and
(if {?BV99IN27IncludeItemsOfType} = 1
    then {INVENTORY.TYPE_KEY} <> "V"
else if {?BV99IN27IncludeItemsOfType} = 2
    then {INVENTORY.TYPE_KEY} = "V"
else {INVENTORY.TYPE_KEY} >= "" )

and a Group # 2 :shows the same formula in select expert.

I do not know how to check other information about these groups.  The only group I made was # 2, # 1 was already in the report ( I am editing a report that is prebuilt into the software business vision by sage)

So how do I fix this then or proceed?
Tanya Vander Vecht
IP IP Logged
TanyaCVV
Newbie
Newbie
Avatar

Joined: 06 Sep 2016
Online Status: Offline
Posts: 17
Quote TanyaCVV Replybullet Posted: 03 Oct 2016 at 7:03am
So I did some more digging. The first group is grouping by a different formula field called @part number in ascending order. If I remove this group though then all of my items in the report except for one (unsure why) disappear and nothing shows under the group 2 headings as specified in my formula?
Tanya Vander Vecht
IP IP Logged
TanyaCVV
Newbie
Newbie
Avatar

Joined: 06 Sep 2016
Online Status: Offline
Posts: 17
Quote TanyaCVV Replybullet Posted: 03 Oct 2016 at 7:05am
Sorry for the multi-replies.

I moved my group 2 into the group 1 position and changed it so it does not suppress and now it is working correctly. Thanks for your help.
Tanya Vander Vecht
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.