Producing Reports

[rasty1611]

Hi,

can anyone please enlight me in how can I produce reports with Visual Basic? I am using Adodc's to extract data and present them in forms through a Datagrid, but I also wish these data (extracted with an SQL statement) to be printed as a report.. But I don't know how to do it. Can anyoone pls heeelp?

thx

[juanmf]

search information on "datareport" and export to excel.

[Hack]

Moved to reporting section

There is also Crystal Reports as well as Access itself.

[rasty1611]

No, you didn't understand. I am developing a system for users and besides viewing fields from the database I want to give to the user the possibility of printing data... So I cannot use Access or excel. I want to have a button, lets say, and that button when pressed prints the data. Please suggest something more appropriate.

thx a million!

[PeterBorroloola]

what version vb?

[rasty1611]

6.0 proffessional

[PeterBorroloola]

if you've got the vb6 cd, look in x:/common/tools/vb/crysrept

this is crystal reports 4.x - once loaded, you can add the Active X component to vb, add it to your project, and use this to draw up reports.

format the report in the CR application, then call it from vb by:

crpReports.ReportFileName = "whatever.rpt"
crpReports.Destination = 0 ' show report in window first
crpReports.PrintReport

where crpReports is the cr4 object added to the project.

a warning: cr is up to version 11, cr4 is considered hopelessly outdated. But the developer edition of cr11 (the only one you can call from vb) costs US$600 - I'm prepared to put up with cr4 for now.

good luck, this may open a can of worms, Peter