Access MSAccess Report Engine

  • Thread starter Thread starter Rolf Gossen
  • Start date Start date
R

Rolf Gossen

Hello NG,

I would like to migrate an existing MS-Access Frontend with SQL-Server
Database to a real C# Application. The biggest Problem that I am
facing until now (I am still checking the solvability) are the
Access-Reports.

I would prefer a solution where the reports remain in the Access
Database being activated by an appropriate interface. Are there any
concepts in .NET that could be applied here.

Thanks
Rolf
 
Unfortunately the Access report engine is not a stand-alone app -- you
will need to use automation/COM Interop on top of somehow getting the
data into Access/Jet from SQL Server, which is going to be a lot of
work and probably not very performant. You might want to investigate
some of the third-party reporting software packages as an alternative.

--Mary
 
Also check out Microsoft Reporting Server at
http://www.microsoft.com/sql/reporting/default.asp
It comes free with SQL Server, or can be ordered if SQL Server was purchased
before the product was released, there is also a trial download.
They claim reports can be converted directly from MS Access, though I
haven't tried it, it should be possible for relatively simple MS Access
reports.
Additional advantages are exporting to PDF, scheduled generation/email of
reports, etc.
 
Back
Top