Sorting the report Details section by code

[Irshad Alam]

I want to sort the details section of the report (which is a Tabular View).
The sorting to based on a Field/Control. What code should I write to do it.

I posted the same question to report groups, sorry the answer was not useful.

My situation is that I have made a report (Tabular view)and has grouped it
on a Field/Control. So the related data displays normal on the details
section and all is fine. But my requirement is additional to that, I want to
sort the data available in the detail section based on a particular
field/control of the Detail section.

Please advise

Irshad

 

[Alex Dybenko]

Hi,
not sure i understand what you need, but perhaps this is something what you
need:
http://www.pointltd.com/Downloads/Details.asp?dlID=45

 

[Irshad Alam]

Ok, Lets take me advise me on a particular part.
How To sort the records of a Report details section based on a Field/Cotrol
"EmplCodes"

Please answer me in code method, so that I can use it at details section,
which will give further idea to solve it.

Very best regards.

Irshad.

 

[Alex Dybenko]

Hi,
You can try to use Report Open event to set order:

Me.OrderBy = "EmplCodes"
Me.OrderBy = true

Why dont you set this in report "Sorting and Grouping" dialog?