What are some of the best/recommeded ways to producing Reports with
VB.

Can you run  Access Reports through VB?
Is Crystal Reports writer the only choice?

Please Email any replys...thanks

I await any Reports!

Duane

I've experienced both VB-report, Crystal reports and reports directly to the printer-object
in VB (heavy coding needed).

My experiences:
                        MS-Access report   Crystal Report       Printer-object (VB)
----------------------------------------------------------------------------------------
Creating reports        Easy               Fair                 Difficult
Database-connect        Very easy          Fair                 via VB: Easy
Speed                   Good               Poor                 As for VB ("Very" Good)
Integration             Poor               Good                 Very good
Run-time files          To many files      CR-dlls/OCX/VBX      No files needed
                        needed (MSARN200)  needed
Macrofunctionality      Very Good          Poor                 VB-functions (Very Good)
----------------------------------------------------------------------------------------
If your reports isn't to advanced, I would recommend using the Printer-object instead of
using Crystal Reports. If you have "advanced" reports using graphics etc, you should
use Crystal Reports or MS-Access. If you use CR you still have to code forms for
report input-parameters (for SelectionFormula). If you use MS-Access, I will recommend that
you create a small Access-program that you execute through the AutoExec-macro. Then
you could start MS-Access (or MSARN200.EXE - Access free runtime version) with
a VB-SHELL-command.

My recommendation: Create your own function-library with functions for creating reports using
the Printer-object. It's the fastest and most integrated solution.

If MS could sell MS-Access report-generator as a separate product for VB (instead of CR), reporting
would have been much easier, dont you think?

Comments, anyone?

__________________________ ________________________________ ________________________
Frode Petter Gilberg          Visual C/C++, Visual Basic          Visual Software as

http://www.visual.no/frode ________________________________ ________________________

[Snip, Snip, Snip]

IMHO...

Randy Gritton

--
"The spell checker keeps changing my name to 'Butthead'!"  
   -- The Better Half 9/26/95