I`m trying to print some kind of reports, and i`ve heard that using crystal reports is an easy way of doing it. I´m using VB 6, but crystal reports is only installed in vb 5. Can you help me?

Well, sorry. I should have given a little bit more information.

I want to print a bill. I´m trying to print data from an access database and i`m using ADO.

Thank you again.

Pulky.


Thank you.

[Edited by Pulky on 12-08-2003 at 06:17 PM GMT]

Hi,

What sort of reports, are you printing data from a database, if so what DBase do you use and what connection DAO or ADO.

It may help in deciding the best way to print your report, there's more than one way to skin a cat.

Shady

____________________________
I don't wanna die... but I ain't keen on livin' either

Well, sorry. I should have given a little bit more information.

I want to print a bill. I´m trying to print data from an access database and i`m using ADO.

Thank you again.

Pulky.

Hey Pulky,

There are quite a few methods to extract data from DBs to Crystal report.
The two easy methods are:

Method 1:
a. ADD a DSN from ODBC Data Source Administrator.
b. Open your DB and write a TABLE & PARAMETER query to select set of records.
c. Open Crystal report, select the DSN (a).
d. Select the table (b)
e. Design your report, set report option to 'Refresh Data'.
f. Call the report from VB of run outside VB IDE.



Method 2:
a. ADD a DSN from ODBC Data Source Administrator.
b. Open your DB and write SELECT query to select set of records.
c. Open Crystal report, select the DSN (a).
d. Select the table (b)
e. Design your report, set report option to 'Refresh Data'.
f. Use 'Select Expert' option of Crystal report to filter data.
g. Call the report from VB of run outside VB IDE.

OK,

So now we know what you are doing there are a couple of options.

You could use crystal report, of which I have no knowledge myself, if this is the way you wish to proceed I cannot advise you.

Or you could simply use the built in printer commands in VB.

Or you could create a template for your bill in Excel and have VB transfer the information from your DB to the spreadsheet.

It's time to decide!!!

Shady

____________________________
I don't wanna die... but I ain't keen on livin' either