Crystal Reports Sorting

Yahoo Archive
1
.and it worked like a charm, thanks!



Michelle Giesige



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Wednesday, April 13, 2011 3:59 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports Sorting





Yes that is exactly what we did
Grouped by Customer Name Hid GH1 and GF1 and grouped and summarized by
CustID and put the ID and Customer Name at the CustID GF2 level
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Brad Ebright" <bebright@... <mailto:bebright%40mgsmail.com> >
Sender: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wed, 13 Apr 2011 12:47:43
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Reply-To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports Sorting

Can you group it by Customer.Name, then by Customer.CustID?





From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage@... <mailto:advantage%40wcoil.com>
Sent: Wednesday, April 13, 2011 9:35 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports Sorting





Call me 5672598651
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Michelle Giesige" <mgiesige@...
<mailto:mgiesige%40randallbearings.com>
<mailto:mgiesige%40randallbearings.com> >
Sender: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Date: Wed, 13 Apr 2011 09:15:12
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Reply-To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order

and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order
and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]
3
I would create a calculated field that would be {Customer.Name} + " -
" + {Customer.ID} and group by that. Probably wouldn't hurt to display
this as the group name as well so you can easily distinguish them.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michelle Giesige
Sent: Wednesday, April 13, 2011 9:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers
with
the exact same name, but have different Customer IDs. For this
particular
report, we still want the list sorted by customer name in alphabetical
order
and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Call me 5672598651
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Michelle Giesige" <mgiesige@...>
Sender: vantage@yahoogroups.com
Date: Wed, 13 Apr 2011 09:15:12
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order
and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
5
Can you group it by Customer.Name, then by Customer.CustID?





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Wednesday, April 13, 2011 9:35 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports Sorting





Call me 5672598651
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Michelle Giesige" <mgiesige@...
<mailto:mgiesige%40randallbearings.com> >
Sender: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wed, 13 Apr 2011 09:15:12
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Reply-To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order

and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
Oops sorry thought I was replying direct
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: advantage@...
Date: Wed, 13 Apr 2011 13:35:07
To: <vantage@yahoogroups.com>
Reply-To: advantage@...
Subject: Re: [Vantage] Crystal Reports Sorting

Call me 5672598651
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Michelle Giesige" <mgiesige@...>
Sender: vantage@yahoogroups.com
Date: Wed, 13 Apr 2011 09:15:12
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order
and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
7
Yes that is exactly what we did
Grouped by Customer Name Hid GH1 and GF1 and grouped and summarized by CustID and put the ID and Customer Name at the CustID GF2 level
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Brad Ebright" <bebright@...>
Sender: vantage@yahoogroups.com
Date: Wed, 13 Apr 2011 12:47:43
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Sorting

Can you group it by Customer.Name, then by Customer.CustID?





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage@...
Sent: Wednesday, April 13, 2011 9:35 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports Sorting





Call me 5672598651
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Michelle Giesige" <mgiesige@...
<mailto:mgiesige%40randallbearings.com> >
Sender: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Wed, 13 Apr 2011 09:15:12
To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Reply-To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order

and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
8
You need to concatenate the fields as someone else already suggested
Customer Name & "_" & Customer ID = group

Will be

ABC Company_99892 99892 ABC Company $700.00

ABC Company_99893 99893 ABC Company $300.00


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of advantage@...
Sent: Wednesday, April 13, 2011 2:59 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports Sorting



Yes that is exactly what we did
Grouped by Customer Name Hid GH1 and GF1 and grouped and summarized by CustID and put the ID and Customer Name at the CustID GF2 level
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Brad Ebright" <bebright@...<mailto:bebright%40mgsmail.com>>
Sender: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Date: Wed, 13 Apr 2011 12:47:43
To: <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Reply-To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports Sorting

Can you group it by Customer.Name, then by Customer.CustID?





From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
advantage@...<mailto:advantage%40wcoil.com>
Sent: Wednesday, April 13, 2011 9:35 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports Sorting





Call me 5672598651
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Michelle Giesige" <mgiesige@...<mailto:mgiesige%40randallbearings.com>
<mailto:mgiesige%40randallbearings.com> >
Sender: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Date: Wed, 13 Apr 2011 09:15:12
To: <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> >
Reply-To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports Sorting

Crystal Reports XI R2



We have a Crystal Report that is grouped by Customer.Name and sorted in
ascending order. The problem is that it is combining those customers with
the exact same name, but have different Customer IDs. For this particular
report, we still want the list sorted by customer name in alphabetical order

and we want them all listed separately. What do I need to change to do
this?

I've experimented with changing the Group expert, but it's not right.



What it is doing now:

99893 ABC Company $1000.00



What we want:

99892 ABC Company $700.00

99893 ABC Company $300.00



Thanks,

Michelle



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]