sort order in CRXI

[karnd]

Hi,

I am working on the sort orders on DEPTNAME field but it has to do based on the SORTORDER field.

Note:For now, the SORTORDER field has only 50 records sorted(1 to 50) out 200 records(rest of are all ie 150 are NULL).

So the DEPTNAME should have to do Sort based on SORTORDER field.
DeptName field is not grouped by.

Could you please provide some ideas.

Thanks a lot,

 

[Turkbear]

Hi,
Not sure I follow, why can't you use the SORTORDER field as the Sort by object?

Or Group on that field and place the deptname in the details..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[karnd]

Hi,

Let me clear:
The items displayed on the report looks like this:
GH1
GH2
GH3
Details a
Details b
GF3
GF2
GF1

so in the details a, i have a DeptName field which needs to be displayed but only thing is it has to be sorted using the SORTORDER field.

From your reply, i am not sure how to do in Crystal reports

"why can't you use the SORTORDER field as the Sort by object"

I hope it is clear now.

thanks
Could you please little bit elaborate.