2 Column Report - Group Header Help (easy I'm sure)

[Elana]

I have a 2 column report that lists clients by Salesperson. I want the salesperson's name to only show on the left-hand column, not over both columns. Any suggestions? Thanks

 

[Rich]

GroupBy the salesperson. Select sorting and grouping from the toolbar.
HTH

 

[Elana]

Thanks, but I've already completed that step. My concern is with the header showing the name of the salesperson...Currently it prints over both columns...I want it to print over just the first column. Any ideas?

 

[Rich]

Allow duplicates no?

 

[yippie_ky_yay]

Hi Elana,

I know this post is old but it's given me hope! I have the opposite problem, I need my group headings to go across both columns.

Your problem may have been that you had the salesperson name in the page header where I think you want to put it in the group header.

If you have done this and the group header still crosses both columns, please let me know - this problem has plagued me for months!

-Sean

 

[Elana]

Hi - I solved the problem with this code placed in the On Format event:

If Me.Left > (3.5 * 1440) Then
Me.txtSalesperson.Visible = False
Else
Me.txtSalesperson.Visible = True
End If

Can't remember where I found that code - believe it was on the MS Knowledge Base tho.

HTH
E

 

[yippie_ky_yay]

Thanks Elana!

-Sean