
REPORTS and VB 4.0: Access or Crystal??
You can access reports from Access, but you must do it via OLE. I was
going to use this method, but found having access and vb loaded at the same
time used up too much ram. Also, by the time I was done, I had pretty much
written an access program. For example, after you create an instance of
access (which takes a long time to load), you must tell access to open the
database, open the report, etc. My program had no vb command in it.
Crystal Reports is a lot smaller and you can do some really nice things
with it. I usually end up writing a small vb program to create a temporary
database, then use crystal to do a crosstab, or just print the information.
This way has worked pretty good.
Let me know if you want to see how to access Access' forms/reports from vb.
Quote:
> Hello,
> I have some questions regarding Reports. I'm currently working on a
> little project in VB 4.0. Data is stored in an access database and it
> is necessary for the project to generate reports.
> Since I'm more accustomed to working with Access (7.0) than Crystal
> Reports I was wondering if it is possible to print reports - made in
> access - from code, preferably without having to open Access.
> Anyone have any ideas on this?
> Is it true that one can make nicer reports with Access than with CR?
> Please respond by email (too) since the news server at work doesn't
> get much messages and if it does they're delayed.
> Thanks in advance,
> Michiel Magne