Printable View
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
search information on "datareport" and export to excel.
Moved to reporting section
There is also Crystal Reports as well as Access itself.
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!
what version vb?
6.0 proffessional
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