Report options in Visual Basic Ent. 6? 1

[cj92713696]

I'm writing an application using Visual Basic 6 (Ent. edition) and would like to know all the available options regarding reporting modules. Of course there's always Crystal (v8), but are there any others out there to do dynamic reports that are really good? Maybe even something I can use that's included w/VB. What are your suggestions?

Also, I'd like for a user to connect to a database and use a component to extract data to print. I can build a dynamic query engine that pulls data, but I'd like to add a level of flexibility where the user can also customize what to print and where. Are there any ActiveX components that allow for this level of dynamic queries that I can just plug into my app.?

* Just connect to the datastore, showcase all the fields, and allow for user selections to list and print? I know I can use Access via OLE, but I don't want to have to have an Access license for each PC.

Thanks for all your help!
CJ

 

[JohnBates]

csperber -

I have used VB6's Data Report with some success.
If you only need a very simple report, it may just be what you need.

First, establish your Data Environment, Data Connection...
- Project--> Add Data Environment; point it to your table, select the required fields

Next, Project --> Add Data Report; layout your heading and detail sections by dragging the fields onto your report.

When user runs the report, it will always display it; then there is a printer icon with which the report can be printed.

I hope this is enough to get you started.

John