printing

[bells]

Other than using Printer.print
can anyone suggest a better way of
printing a database from VB program


thanks

 

[johnwm]

You could use the built-in DataReport (Project|Add DataReport)

You could use a 3rd party tool such as Crystal Reports

You could export to Word/Excel

As your question is fairly open, it's a bit difficult to be more specific. Try reading all of faq222-2244 to find how to get better answers.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[bells]

Well i am trying to use DataReporter but still have a problem

I am trying to print from a recordset which extracts data
using the GROUP BY statement

i.e

strSQL= "Select Region, Sum(myTable.Q1) as q1 FROM myTable GROUP by region

myRedordset.open strSql, myconnection

the problem is once i droped a textbox in the datReporter
how can i associated each textbox on the reporter with
the value in the Recordset.
i know if it was not group by i could just put the
name of the field in the DataField property of a textbox
in the reporter then i just have to set the the recordset to the rporter and call it but since i have the Group by statement i have to come up with a way of showing for all regions i am stuck any idea please

 

[JeffTullin]

bells:
The thread started with 'is there another way to print than Printer.Print'
But the question is now more to do with datareporter.
I think a different thread topic is more likely to get you results, especially if you include DataReporter in the topic.

I personally have not used dats reporter.
However, assuming it MUST have the same kind of features as most other reporting tools, then normally the details of the report live in a 'details' section.


A report usually breaks down into sections, and takes the form:

Report Heading Section <put the title and date in here>
Page heading section <maybe column headings here>
Group heading section <if you group by area, show area name here>

Detail section <the actual repeating variables - for you this would be Region and Q1 side by side>

Group footer <totals over the group>
Page footer <page number>
Report Footer <totals over report>

Is that any help?

 

[bells]

I apologize for the confusion JeffTullin
well i will start another thread on DataReporter

Thanks