Vb.net to produce MSaccess report

Hello Andy,
Thanks for the input.But ,my client wants a vb.net project to generate MSAccess report.  Any suggestions?

Cheers

>>my client wants a vb.net project to generate MSAccess report.

If it is to print an existing report the simple suggestion I made will work.  Use a VB.Net app to use Process.Start to launch access with command line parameters.

If it is to create a report you have an incredible amount of code to write, you'd need to open a report in development mode, create and add the data source, add controls to display info where required (header, footer, body, both report and grouping).....

ps.  The first only requires the free runtime access on the PC, the second requires the purchased full version of access on the PC.

Yes,have purchased access on the pc.

and creating a report from nothing?

yup!

As I said, loads of work.  How much really depends on just what your client wants.
It is the sort of thing I'd do as a contract job.


you'd need to open a report in development mode, create and add the data source, add controls to display info where required (header, footer, body, both report and grouping).....

Ok.

It would be better to create the report in Access and then fill it through automation from your .NET program. Creating a report entirely from code in Access is doable, as Andy said, but it's a tremendous amount of work for no real benefit.

Great!Any suggestions on how to add print function for the existing access report.

Cheers mates!!!!Will take it from here now..