Dynamic sorting and grouping

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

Is there any way to choose the sorting and grouping of a report at run time?
We want the user to be able to choose what sorting he wants and we do not
wnat to have to write the report a number of times.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Jonathan said:
Is there any way to choose the sorting and grouping of a report at run time?
We want the user to be able to choose what sorting he wants and we do not
wnat to have to write the report a number of times.
Click to expand...

Use the report's Open event to run code to manipulate the
report GroupLevel array:

Me.GroupLevel(0).ControlSource = Forms!someform.txtSort1
Me.GroupLevel(1).ControlSource = Forms!someform.txtSort2

If you have group headers/footers with specific field
calculations, you may need to change those control's
ControlSource as well.
 
Back
Top