sorting

rbuser

Is there a way to sort sub reports differently from the main report.
i have a list of employees and want to total the number of positions in the
main report but want to total the number of departments in the sub report.
if i group by departments then i get multiple totals for the same department
as its sorting by position.

Thanx

digitalmetaphors

The report engine will just traverse the data you provide. The subreports
print based on the detail datasets and the master breaks when the key
linking field changes value. You'll probably want to create some calculated
field on the dataset to get these values instead of trying to break away
from the master detail dataset linking.


Cheers,

Jim Bennett
Digital Metaphors