Report with group criteria problem 1

[gen13]

I am having some difficulty with the expression builder. I have created a report that has two group headers: one for City, and the other for Position. I want to make it so that if you are not in a certain City, the Position header will not show on the report, but WILL show for the City you want it shown for.
Any help is much appreciated.

 

[NorthNone]

Is this any help? In VBA:
"on format" of the Position header
If me.city = 'New York' then
me.PositionHeader.visible = false
else
me.PositionHeader.visible = true
endif

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[gen13]

Thank you VERY much!

 

[NorthNone]

Glad I could help. Thanks for the star!

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[gen13]

Unfortunately, though one problem is solved, another has revealed itself. For the Positions group header, I want to specify the order within a particular position in the report.
Say one of the positions is called Team.
I want the team members to go in a specific order, starting from the lead team member, to whoever is next in line, to the last member.
Once again, any help is much appreciated.

 

[NorthNone]

You might want to start a separate post with just this question and clarify whether you want the sort order to change based on a value or you just want to set the sort order for the report. I'll look for the new post.

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.