Ordering of Details in Report

[33216CLC]

I am having a little difficulty in ordering a report by Employee Name rather than Id Number. I already have many reports that are odered by Employee Name, but one seems to be different. I use Crystal reports 7 as my reporting engine, VB6 for programming, and Access 2000 (97 format) as database engine. I attempted to order the table with this information using code in my program, but nothing happened.

Any ideas?

Thanks

 

[MalcolmW]

The report may be grouped by EmployeeID, rather than Employee Name.
If it is, add another group to the report, using Employee Name. Drag it to outside the EmployeeID group. Format the new group header and footer sections to suppress, so that you don't have extra white space on your report. Malcolm

 

[33216CLC]

Actually, Malcolm, the report is grouped by Company Number, then by Location Number. The very same grouping is applied to another report which is coming up ordered by Employee Name.

In designing this report, I copied the layout of another report, changed the field references, and changed how the report is grouped. In totalling the count of employees at each location I used, "Count ({employee.Full Name}, {employee.Location})" as the Formula. In totalling the Company's employee count I used, "count({employee.Employee Id})".

Could any of this have an effect on the results I am getting?



Thank you, Malcolm.

 

[kenhamady]

Formulas can't change the order of the report. Open the sort window and tell use what you see. Report - Sort Records.

This will list your groups, and the subsequent sorts, in the order that they are used. If there isn't a sort, move the field you want to sort on to the right. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[33216CLC]

I thought not. Here is what appears in the Sort Feilds list:

Group#1:employee.companyid-A
Group#2:employee.location-A

I tried your suggestion and it nipped my problem right in the bud.

Thanks Ken