CR data source connection to the Excel by VB .NET

[sylvianbca]

I am using Crystal Report 2020. I have an Excel file as the data source.

I create my crystal report template base on this document

https://www.sap.com/documents/2020/11/a046b61d-bd7d-0010-87a3-c30de2ffd8ff.html

I connect data source through :

OLE DB (ADO) --> Microsoft Office 12.0 Access Database Engine OLE DB Provider

I input information as follows :

Data Source: C:\DataQuery\Database\MonthlyBalance.xlsx

Office Database Type: Excel

User ID: Admin

Password: <NIL>

Jet System Database: <NIL>

Jet System Password: <NIL>

As since the data source is an Excel file but not the sql server. Is it possible to call up the crystal report template and print to printer by using VB .NET code?

[DonWilliams · Accepted solution]

Please stop posting the same question in multiple locations, stay on one post and respond as rquired.

https://answers.sap.com/questions/13832252/how-the-code-setdatabaselogon-logon-to-excel-data.html

[DonWilliams]

Yes you can,

Get SP 33 for VS 2022 here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

See my blog on how to upgrade:

https://blogs.sap.com/2020/10/30/upgrading-a-visual-studio-2008-2019-.net-project-with-the-latest-cr...

Use the sample app as a demo on how to select the printer using POC, if using P2P the printer must be set in the RPT file in the Page Setup.

Printing Crystal Reports in .NET