This is a combination of a sample database from Lebans web page, and an activex dll I found that works really well in rotating the labels for reports in any direction you want.
There are two databases in this zip file. One comes with the activex control and shows you a number of ways you can utilize it. The other is the dynamic crosstab report, with the tilt control added to it.
You need to register the activex dll before running these databases.
Many people have asked about both subjects. Including how to total columns of data with dynamic crosstab reports.
Well, it is all in here.

This seems great but how do you install and register the DLL??

You can put the dll in any directory you want. Use the regserver command or find a utility for registering dll's that does it quickly for you.

Many thanks. I have now managed to register the DLL using regsvr32.exe but the DLL had to be in C:\windows\system32 or I got an error.

Hi Keith

I don't suppose you have access to a 97 version of the crosstab report at all. I am having real trouble creating the dynamic totals for my report and any help would be greatly appreciated. I originally used the sample database from the Lebans homepage and a few tweaks provided by solutions.mdb but cannot get any further

Regards

Jason

No, I do not have anything in access 97.
You will find there is less and less out there as time goes by.
I would suggest upgrading things to "at least" access 2000.