Supress Group Header with coding? 1

[DVDGirl]

Is there a way to suppress the group header through coding? I have a form that has a combo box: (a) Sort by Team, (b) Sort by Player.

That goes to a report that has a group header, Team, and the data is sorted by Team Name. However, I would like the same report to also be sorted in alphabetical order by Player Name.

Is this possible, and if so, could you please tell me how to implement this? Thank you in advance!

-DVD Girl

 

[THWatson]

DVDGirl
In the report's properties, you can set a second sort level, sorting first by the Team Name, and then secondly by the Player Name.

Tom

 

[DVDGirl]

Hi Tom -
Thank you for responding, but I'm sorry, I guess I didn't explain my scenario clearly enough. I would like one report that has two different views: (1) Sorted by Team or (2) Sorted By Player.

I would like the user to choose how they want the report sorted from a combo box on a form. After clicking "OK", the one report could dynamically sort based on the user's selection.

I just would like to know if this is possible. I know I could just create two separate reports to accomplish my goal, but I was just wondering if there is a way to do it in one report. Thank you again!

-DVD Girl

 

[THWatson]

DVDGirl
Well, I wondered. Now I understand.

Sure, there's a way to do what you want.

Have a look at thread703-773697 and see if Duane Hookom's solution in that thread will do it for you.

Tom

 

[DVDGirl]

Thanks, Tom! I just have to tweak it a little, but otherwise, the thread you pointed me to gives me just the info I need! Thank you very much!

 

[THWatson]

Glad you have it working!

Tom