I've got to add some custom reports to a current VB6 application with the data coming from SQL Server.
The reports need to have logos, grids as well as the required data and they may span multiple pages.
Other than basic text reports, I've never had a need to do reporting in VB6 before and I'm looking for some advice.
I've been googling and looking through the forums here and it seems the DataReport is what most seem to use (please correct me if I'm wrong), but from what I've found, I'm not sure it suitable.
The following are my usage requirements:
- Report is purely for printing purposes. The application will be running on a server and will just print a report at the end of a process.
- The database is SQL Server. It's location will change from my dev machine once at the customers.
- Report would be better a template external to the program.
- Would be useful if the report output could be saved to the server (or printed as PDF).
My findings related to the above are as follows:
- Datareport seems to require the report to be viewed before printing.
- You need to set up a connection in advance. I didn't see an example using a dynamic connection.
- Customers have a habit of changing their mind. It would be useful if the report could be external. It seems datareports are compiled into the application.
- Similarly to the first point, I couldn't see an example without user intervention.
I'm just looking for some pointers in the right direction.