Group Sorting in a Table

Good morning,
I am having a little bit of an issue with the sorting of data in a report.
The report works great, but the sorting could be better.
I have the data in a Table.
I have a list of data that is grouped into three groups. The groupings are
by Project, Phase, and CostCode, in that order. I have set the Sorting in
the Table to be by Project, then Phase, and then CostCode. All of them
Ascending sort.
Project sorting and CostCode sorting is working great but the middle one,
Phase, is sorting completely opposite. It is sorting Descending. I cannot
figure it out.
Anyone have any ideas or a tip? Is this a known bug?Try going into the properties of the table pick groups edit group(the one
thats not working correctly) and try setting the sorting within the group. I
think that that should work for you.
"abillmeier" wrote:
> Good morning,
> I am having a little bit of an issue with the sorting of data in a report.
> The report works great, but the sorting could be better.
> I have the data in a Table.
> I have a list of data that is grouped into three groups. The groupings are
> by Project, Phase, and CostCode, in that order. I have set the Sorting in
> the Table to be by Project, then Phase, and then CostCode. All of them
> Ascending sort.
> Project sorting and CostCode sorting is working great but the middle one,
> Phase, is sorting completely opposite. It is sorting Descending. I cannot
> figure it out.
> Anyone have any ideas or a tip? Is this a known bug?
>
>|||Thank my friend, you nailed it spot on. I found it myself a little bit ago.
"KimB" <KimB@.discussions.microsoft.com> wrote in message
news:6C6199FB-8330-4F1A-AC1E-3FA302E7879D@.microsoft.com...
> Try going into the properties of the table pick groups edit group(the one
> thats not working correctly) and try setting the sorting within the group.
> I
> think that that should work for you.
> "abillmeier" wrote:
>> Good morning,
>> I am having a little bit of an issue with the sorting of data in a
>> report.
>> The report works great, but the sorting could be better.
>> I have the data in a Table.
>> I have a list of data that is grouped into three groups. The groupings
>> are
>> by Project, Phase, and CostCode, in that order. I have set the Sorting
>> in
>> the Table to be by Project, then Phase, and then CostCode. All of them
>> Ascending sort.
>> Project sorting and CostCode sorting is working great but the middle one,
>> Phase, is sorting completely opposite. It is sorting Descending. I
>> cannot
>> figure it out.
>> Anyone have any ideas or a tip? Is this a known bug?
>>