Dynamic Crosstab Report & Dynamic Labels (1 Viewer)

keiths · Apr 14, 2006

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.

Fear Naught · Apr 19, 2006

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

keiths · Apr 19, 2006

Registering a dll or ocx

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.

Fear Naught · Apr 21, 2006

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.

lemon_balm · Sep 19, 2006

Crosstab Report

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

keiths · Oct 2, 2006

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.

Dynamic Crosstab Report & Dynamic Labels (1 Viewer)

keiths

Registered User.

Attachments

Fear Naught

Kevin

keiths

Registered User.

Fear Naught

Kevin

lemon_balm

Registered User.

keiths

Registered User.

Similar threads

Users who are viewing this thread