Dynamic Data Report
Posted on 2002-04-01
The application I am building requires some relatively simple reporting capabilities. Primarily I need to incorporate the ability to print the contents of a Mshflexgrid when the user requests.
The application is a data mining application where a user could import virtually any file for analysis purposes. As such it is impossible to build a static Data Report.
My first thought was to utilize the Data Report in VB6, but found that it doesn't seem to allow dynamic creation of reports.
I worked with the printer object, but found it sucked particularly if the data went past the margins. In other words it was too complex to program properly.
The only thing I think of to work here is to dump the contents of the ADO recordset/datasource into a RichTextbox then printing from that.
As a followup, is there a dialog box OCX or something that can be used to set the options of the printer object? IE margins, zoom, etc? Seems really stupid to have an object like that and nobody built an OCX to set properties. I already am using the common dialog control to present the typical vanilla print options, but I need to be able to scale the printout to fit a page, set margins, etc. just like every other program on the planet.