Sorting and grouping a report through code

[zevw]

I have a field in my report called "Srt". I would like to have this field sometimes sorted in ascending order and sometimes in descending order based on users choice. The default is in ascending order.

The Sorting and grouping in the report looks like this:

Grp1 | Ascending ===> This field is grouped
Srt | Ascending ===> Not grouped

How can I change it to descending order

I tried this code but I could not get it to work.

Reports("Summary Report").Controls!Srt.SortOrder = True

I get this error message

object doesn't support this property or method.

Thanks in advance for your help!!

 

[zevw]

Is there anyway to have something sorted even though it is not grouped?

 

[zevw]

I figured it out regardless if the "Srt" is grouped or not you still refer to it as a group. If it is on the second line/group you would code it as follows.

Reports("Summary Report").GroupLevel(1).SortOrder = True

1st line is .GroupLevel(0)
2nd line is .GroupLevel(1)
3rd line is .GroupLevel(2)

Thanks, and I hope it helps someone else in the future!!