Sorting the report Details section by code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Irshad Alam - 07 Sep 2005 13:03 GMT

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

Reply to this Message

Alex Dybenko - 07 Sep 2005 21:35 GMT

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

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> I want to sort the details section of the report (which is a Tabular
> View).
[quoted text clipped - 14 lines]
>
> Irshad

Reply to this Message

Irshad Alam - 08 Sep 2005 07:38 GMT

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.

> Hi,
> not sure i understand what you need, but perhaps this is something what you
[quoted text clipped - 19 lines]
> >
> > Irshad

Reply to this Message

Alex Dybenko - 08 Sep 2005 14:24 GMT

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?

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Ok, Lets take me advise me on a particular part.
> How To sort the records of a Report details section based on a
[quoted text clipped - 34 lines]
>> >
>> > Irshad

Reply to this Message