I had a little problem when deploying an application having crystal reports as a reporting tool on a client pc.
It works so well in my dev pc even installed.Since i'm using Access 2007 i used Microsoft.ACE.OLEDB.12.0 provider.
I haven't provided any password or username for the database.But it keeps asking to provide a user name and a password.
I'm using the recent version of crystal reports (SP9) for VS and the runtime for client pc.
Here is the code i used to view the report using the pull method.Any comment or modification on my coding or db connection is greatly appreciated.
Dim rep As New ReportDocument With rep .Load(ReportPath) .SetDataSource(ds) End With CrystalReportViewer1.ReportSource = rep CrystalReportViewer1.Show()