Grouping Levels

[Dave_Griffin_(Guest)]

We have a client who requires a report with 7 levels of grouping, they are using MSSQL 2000 as a database platform.____The report previews ok, but when trying to return to the report designer R&R crashes.____If one level of grouping is removed the report works fine.____I have created a very similar report with the same number of group levels for another client who are using Oracle, without any problem at all.____Any help you can give with this would be greatly appreciated. ____Dave.

[kfleming]

Try creating 10 character calculated fields for each group field rather than selecting group field names directly from the table.__So if my group field was CUSTOMER.ADDRESSLINE2__I would create a calculated field called ADD2 whose expression would be:__CUSTOMER.ADDRESSLINE2__and I would select ADD2 as the group field.______Kathleen__R&R Support