Reports and column sorting buttons

[DevAccess]

Hello

I would like to have twisties on column on the report which would sort the given column at anytime.

I dont want the way we do it on grouping and sorting which is predeifined by our program, but need dynamic way and I should be able to sort any columns at any given time.

Thanks

 

[Ranman256]

You HAVE to sort using grouping/sorting.
That's why they built it.

 

[Minty]

You can replicate those controls on a form, but not on a report as far as I know.
If someone needs to manipulate the data that much export it to Excel.

 

[sxschech]

You could set up sort options in the form that calls the report and use vba to alter the sort of the report.