Crystal Sort before grouping

Yahoo Archive
1
The issue I am having is with the summaries using this method. If I
do a summary at the level of the second group it breaks it down for
each group above. I am trying to see if I can write a formula to do
this.

--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Just put two groups in and suppress the higher group from the
report
> view
>
>
>
> Gary
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Michael McWilliams
> Sent: 16 October 2007 15:31
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Sort before grouping
>
>
>
> Is there any way to sort above a grouping? For instance I have
Jobs
> with numbers 1 through 100 on a vb field. I want to sort by the
> number and then below that group by Part Number. I can only get it
to
> group and then sort.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Is there any way to sort above a grouping? For instance I have Jobs
with numbers 1 through 100 on a vb field. I want to sort by the
number and then below that group by Part Number. I can only get it to
group and then sort.
3
> Is there any way to sort above a grouping? For instance I have Jobs
> with numbers 1 through 100 on a vb field. I want to sort by the
> number and then below that group by Part Number. I can only get it to
> group and then sort.

For creative sorting, I usually create a formula field and then sort/group on
that. You can get around a lot of numbers vs. text issues that way as well.

Mark W.
4
--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > Is there any way to sort above a grouping? For instance I have
Jobs
> > with numbers 1 through 100 on a vb field. I want to sort by the
> > number and then below that group by Part Number. I can only get
it to
> > group and then sort.
>
> For creative sorting, I usually create a formula field and then
sort/group on
> that. You can get around a lot of numbers vs. text issues that way
as well.
>
> Mark W.
>
Or you can just create a group for the number, without the need for a
formula. Have the number grouping as group 1 and the Part Number as
group 2. You can choose whether or not to display (hide or suppress)
the header/footer.

-Matt

Fleetwood Fixtures
5
That did it.
--- In vantage@yahoogroups.com, "matt_rodenbaugh" <mattr@...> wrote:
>
> --- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@> wrote:
> >
> > > Is there any way to sort above a grouping? For instance I have
> Jobs
> > > with numbers 1 through 100 on a vb field. I want to sort by the
> > > number and then below that group by Part Number. I can only
get
> it to
> > > group and then sort.
> >
> > For creative sorting, I usually create a formula field and then
> sort/group on
> > that. You can get around a lot of numbers vs. text issues that
way
> as well.
> >
> > Mark W.
> >
> Or you can just create a group for the number, without the need
for a
> formula. Have the number grouping as group 1 and the Part Number
as
> group 2. You can choose whether or not to display (hide or
suppress)
> the header/footer.
>
> -Matt
>
> Fleetwood Fixtures
>
6
Well it works if I don't need summaries, but when I go to do a
summary of the Prod Qty by Part Number I just get one for every one.
--- In vantage@yahoogroups.com, "Michael McWilliams"
<mmcwilliams22@...> wrote:
>
> That did it.
> --- In vantage@yahoogroups.com, "matt_rodenbaugh" <mattr@> wrote:
> >
> > --- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@>
wrote:
> > >
> > > > Is there any way to sort above a grouping? For instance I
have
> > Jobs
> > > > with numbers 1 through 100 on a vb field. I want to sort by
the
> > > > number and then below that group by Part Number. I can only
> get
> > it to
> > > > group and then sort.
> > >
> > > For creative sorting, I usually create a formula field and
then
> > sort/group on
> > > that. You can get around a lot of numbers vs. text issues that
> way
> > as well.
> > >
> > > Mark W.
> > >
> > Or you can just create a group for the number, without the need
> for a
> > formula. Have the number grouping as group 1 and the Part
Number
> as
> > group 2. You can choose whether or not to display (hide or
> suppress)
> > the header/footer.
> >
> > -Matt
> >
> > Fleetwood Fixtures
> >
>
7
Just put two groups in and suppress the higher group from the report
view



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: 16 October 2007 15:31
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sort before grouping



Is there any way to sort above a grouping? For instance I have Jobs
with numbers 1 through 100 on a vb field. I want to sort by the
number and then below that group by Part Number. I can only get it to
group and then sort.





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