[RESOLVED] Is datareport what I need?

Hi im using DAO and access with vb6 [no ado or sql]

I have a database that is used to aorse data collected from a user in recursive cycles by a vb6 app.

I need the app to be able to print a report at the end that doe not just give me a list of records but instead will take have the date and title in the head
and display the number of types of parts used/scraped

IE an eg of my db record:

Date; time; opID; p1serial; part type; part num; fault; location; rep serial; board count;

I need the report to say a total of x boards processed (total in db) on date xx/xx/xxxx

then; so parts with number xxxxxxx had fault xxxx from location xxxxxx
etc

I can easily writ functions inside my app to get the neccessary numbers etc but I havnt a clue where to start wit code for the report.
was lookin around online and it doesnt seem that reports a really used in this kind of way, am I wrong? anyone feel like helpin a dunce out? ;}

I cannot use much outside of vb6 and access though.

thanks very much in advance :D

If you are familiar with Access, then I'd suggest you write the report using that and just call it from your Vb app.

Ok I just reread my complete idiots guide to access and made up a quik rport in access.

how do I call this in vb? (to preview and then print)

should prob be more detailed. I need to print it without leaving the application and without access opening in the background as access i A)not installed on the machines this runs on (just the vb runtime files) and B) for report data security.

I just came across some code on the internet that I thought would do the job, and seems to be the way this is done, but it does open access. It used the docmd object etc.

Hi,

In your vb 6.0 application, Add a reference to Microsoft Access Object Library, then add a code using

Code:

---

DoCmd.OpenReport "report name", view type

---

There was also a post I started regarding this topic...Do a search on this forum...


Greg:)

Quote:

---

Originally Posted by KGComputers

Your going to create queries in your database then set the record source property of the data report...

---

Whew If i knew that at the start I prob wouldnt have needed post at all!

*now goes in search of notes on query building......* :D