| Author |
Message |
rdseal
Newbie
Joined: 18 Jun 2009
Online Status: Offline
Posts: 23
|
   Topic: Grouping Problem for newbie. Please help!!!
Posted: 18 Jun 2009 at 3:45am |
|
Hi all,
First I want to say thanks to all contributors as I have been using this forum as a first resort for help if I was stack with my new reports and I was able to find my answers without any problem up until now... Please help!
My current sample report:
ConsignREF lines Supplier Source
(String) items Date .
HD111984 ANT 25 50 FGS 18/03/09 OS
HD111984 ANT1 51 175 SID 14/03/09 OW
HE101526 M TR4 1 1 COS 10/02/09 EC
HE101526 TR2A 1 3 DIJ 02/02/09 OW
HE101526 TR1 16 20 AE CO 10/03/09 OW
HE101526 TR2 3 4 AE CO 10/03/09 OW
HE101836 FGTR 4 5 BINV 05/02/09 OW
HE102549 OIS4 1 9 GHYG 12/03/09 TR
We receiving orders for our clients from various suppliers consolidate them and send them out as one order.
Our main System allocates order number (AB123456) where AB- type of order and 123456 numeric no. unique for this order.
Our Stock Control System is independent from the main System. I am forced to use (AB123456 XXXXXX) as Consignment Ref. where XXXXXX is diffrent every time we receive an editional stock for the existing order as system will not alow me to use same AB123456 again.
Please note that ConsignREF in Stock Controll System is (string).
My question is how can I Groupe ConsignRef so all entries for order that containing same 123456 are consolidated and showing on one page so it makes easier to process complete order?
I guess I will have to use a formula as Groupe sort order???
If you need more info please ask.
Many thanks in advance.
Edited by rdseal - 18 Jun 2009 at 7:30am
|
|
read read read
|
 IP Logged |
|
|
rdseal
Newbie
Joined: 18 Jun 2009
Online Status: Offline
Posts: 23
|
Posted: 18 Jun 2009 at 5:30am |
|
Forgot to say I am using Crystal Reports 2008.
Thanks
|
|
read read read
|
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 18 Jun 2009 at 7:02am |
could use formulas and group on them. if there is always a space or the first part is of uniform length.
for the consignment group
mid({table.consignRef}, 10)
for the partnumber group
mid({table.consignRef},3,6)
now all of the consignment will be grouped together along with all the part numbers.
HTH
|
|
IP Logged |
|
JohnT
Groupie
Joined: 20 Jan 2008
Online Status: Offline
Posts: 92
|
Posted: 18 Jun 2009 at 7:05am |
If I understand correctly, your consignREF field is xx999999 and you want to sort on the last 6 characters regardless of the first 2 alpha characters. Is that correct ? If so, you can create a formula that strips off the last 6 characters and use the formula in your group. The formula could be:
Mid(ConsignREF,3,6)
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 18 Jun 2009 at 7:13am |
NOt sure exactly what you want but here are a few options for some formulas that may make it groupable for you:
left({table.consignref},8)
or
left({table.consignref},instr({table.consignref}," "))
or
mid({table.consignref},3,6)
or
mid({table.consignref},3,instr({table.consignref}," ")-3)
|
|
IP Logged |
|
rdseal
Newbie
Joined: 18 Jun 2009
Online Status: Offline
Posts: 23
|
Posted: 18 Jun 2009 at 7:27am |
|
Hi and thanks for the reply.
I am trying to use
mid({Intake1.ConsignRef},3,6)
but I am keep getting an error "A constant expressions is required here" when I am trying to save it in Formula Workshop - Group Sort Order Formula?
|
|
read read read
|
|
IP Logged |
|
rdseal
Newbie
Joined: 18 Jun 2009
Online Status: Offline
Posts: 23
|
Posted: 18 Jun 2009 at 7:29am |
|
Tabel called
Intake1
Line called
ConsignRef
Thanks
|
|
read read read
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 18 Jun 2009 at 7:31am |
At the risk of you getting 3 more answers here... Create a formula field with the
mid({Intake1.ConsignRef},3,6)
and then sort (or group) on that formula field.
|
|
IP Logged |
|
rdseal
Newbie
Joined: 18 Jun 2009
Online Status: Offline
Posts: 23
|
Posted: 18 Jun 2009 at 7:38am |
Originally posted by DBlankAt the risk of you getting 3 more answers here... Create a formula field with the
mid({Intake1.ConsignRef},3,6)
and then sort (or group) on that formula field.
I am keep getting an error "A constant expressions is required here" ???
|
|
read read read
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 18 Jun 2009 at 7:43am |
So you are in the Formula WorkShop, you created a New Formula Field Called something like "Sort Field" and then you put:
mid({Intake1.ConsignRef},3,6)
and as crystal syntax and you get this error?
|
|
IP Logged |
|
|
|
