Crystal reports

[J. Freed]

I would like to be able to run a Crystal report from within VBA. (Yes, I know
about Access reporting, but I need to be able to run a report with more
columns than Access can do. Yes, I know lots of columns is usually bad report
design, but this is a series of crosstabs and we definitely need lots of
columns).

Crystal is embedded in VS, but I can't seem able to find any code for how it
would work in VBA. Any leads? TIA......

 

[Rui]

I am going to hazzard a guess although I never tried it.

If you have crystal installed in the machine, you should be able to add it
as a reference, just in the same way you would do it for any other dlls (i.e.
word)

then you will have to try things like

dim cristalReport as CrystalReportReference
set cristalReport = new CrystalReportReference()

just like you do it with any other dll.

 

[J. Freed]

You're correct, that's what I'm trying to do. What I'm looking for is a
resource that will tell me exactly what the names and syntax are to invoke
the dll. Instead of trial and error I'd like to find out exactly what I need
to make it work.