Search code examples
c#sql-serverms-accessreportingsql-server-express

Importing an MS Access report into C#

Can you please assist me with a small problem I have? It would be greatly appreciated :)

So I have an access application I am converting into C#. It is actually quite huge and makes use of multiple access databases as access is very limited. Now a problem I have come across is to do the reports in C#. I know it is possible to export the reports into XML format from Access but the problem is the client wants a SQL Server Express edition which doesn't support SQL Server Reporting services (as far as I understand). So it it possible in anyway to import those reports into C#? Or only the layout at least?

I am using the Microsoft RDLC Report Designer for Visual Studio 2017

Thanks for your time!

Edit: Or is there any alternative I can use to build reports with C#?

Solution

  • Short answer is No.

    Access reports are very specific to Access in every matter, and very different from RDLC.

    Here is an example made by a fellow of mine and me for reports created in .Net that totally mimics the reports of the old sample Northwind database:

    Northwind.NET