RIAS
asked on
Vb.net to produce MSaccess report
Hello,
Any Guidline/Suggestion on just a simple system that will produce a printable report using MSaccess instead of sql.
Thanx in advance.
Cheers
Any Guidline/Suggestion on just a simple system that will produce a printable report using MSaccess instead of sql.
Thanx in advance.
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>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).....
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.
ASKER
Yes,have purchased access on the pc.
and creating a report from nothing?
ASKER
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).....
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).....
ASKER
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.
ASKER
Great!Any suggestions on how to add print function for the existing access report.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers mates!!!!Will take it from here now..
ASKER
Thanks for the input.But ,my client wants a vb.net project to generate MSAccess report. Any suggestions?
Cheers