report - grouping vba

[diegomarino]

hi, i have this report




as you can see, it has 3 grouping:
1) the date (black part)
2) the company left (the blue one§)
3) the company of arrival (yellow).


is there any way to change grouping, maybe using a listbox in which i can choose the grouping instances (eg just date, date and company of arriving etc etc)

i think there is some vba stuff but i'm pretty ignorant about reports.

[Welshgasman]

Always my first place of call.

https://www.google.com/search?q=repo...hrome&ie=UTF-8

[diegomarino]

thanks i found it, but i'm usure how to use

maybe:

PrivateSub Report_Open(Cancel AsInteger)  Me.GroupLevel(0).ControlSource _  = Forms!SortForm!txtPromptYou EndSub

this Forms!SortForm!txtPromptYou this is the control of ny report that will give the first grouping?

[Welshgasman]

I have never grouped via VBA, so you will have to experiment and do further research.

[diegomarino]

ok, 'ill show the result

[Welshgasman]

There has to be someone out there that has already done this, possibly for multi groups.