Sorry to ask such a simple question but I was hoping someone might be able to help me.
I am creating a very simple report which just totals a value for records in the same Class and Sub Class.
So I have a Leading Subsummary showing the Class and the Sub Class. I can get this to work when I sort by the class id and Sub Class and group by the same fields
- Code: Select all
nclassid asc, csubfull asc
however when I change the class id to point to the related table description (to get my list in alphabetical order) the whole thing just grinds to a holt.
- Code: Select all
books_to_classification.cdesc asc, csubfull asc
Is it not possible to use a relationship in a subSummary Group by?
Revised: Ok it does actually work if you go away a leave it to process but with under 3000 records in the table and 130 classifications surely this should run relatively quickly?
Any help would be appreciated.
Caroline