ms access to asp.net

[Marty]

What is the easiest way to upgrade ms access forms and reports to
asp.net? If it means a total re-write, how do you run reports with
parameters thru an asp.net form with say date-from and date-to
parameters? Is crystal better then the built-in reports in VS 2005?
Thanks.

 

[Guest]

What is the easiest way to upgrade ms access forms and reports to
asp.net? If it means a total re-write, how do you run reports with
parameters thru an asp.net form with say date-from and date-to
parameters? Is crystal better then the built-in reports in VS 2005?
Thanks.

No, you should write a new .NET application. You cannot use MS Access
Reports without MS Access. Use Crystal Reports instead (or write a
custom web page-based report)

 

[Roland Dick]

No, you should write a new .NET application. You cannot use MS Access
Reports without MS Access. Use Crystal Reports instead (or write a
custom web page-based report)

As an alternative to Crystal, create a new .NET application that writes
the data into some backend database, link the tables in a MS Access
database and you can run Access reports on those.

Roland

 

[Mark Rae]

As an alternative to Crystal, create a new .NET application that writes
the data into some backend database, link the tables in a MS Access
database and you can run Access reports on those.

You're surely not suggesting running Access over the web...???

 

[Mark Rae]

What is the easiest way to upgrade ms access forms and reports to
asp.net?
Rewrite.

If it means a total re-write, how do you run reports with
parameters thru an asp.net form with say date-from and date-to
parameters?

Depends what reporting technology you use, and where the data is stored...

Is crystal better then the built-in reports in VS 2005?

I wouldn't say it's any better - the ReportViewer is really powerful...
http://www.gotreportviewer.com/

 

[sloan]

If you go the Crystal Report route (or whatever route for that matter), then
I'd STRONGLY suggest putting your data into a strongly typed dataset.

What I mean is that your CR should should be built on a strongly typed
dataset, and NOT talk to the database directly.
No stored procedures, no direct sql.

Now you ~can populate a dataset with a stored procedure. But make sure you
use the (strongly typed) dataset as the middle man.

Why?
Because you should view CR (or active reports, or getreportviewer.com ) as
the presentation layer. and you should NOT marry your presentation layer to
the data.
Which is exactly what you'll do if you have your CR talk directly to a
stored procedure.

By doing it this way, you can actually try different techniques.

Maybe your report can be done as a webpage as a simple <asp:repeater>
object. Maybe CR, maybe active reports.

You will have (future) choices if you do it right (seperate the data being
reported against from the presentation layer) from the get go.


Here is the basic idea at:
http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf

or even
http://scottonwriting.net/sowblog/posts/2148.aspx

 

[Roland Dick]

You're surely not suggesting running Access over the web...???

No, just using the same database tables in (offline) Access as the
webapplication does (for data entry or something). That might save the
OP from re-creating his reports in Crystal Reports, assuming that the
database design remains the same.

Roland

 

[Mark Rae]

No, just using the same database tables in (offline) Access as the
webapplication does (for data entry or something). That might save the OP
from re-creating his reports in Crystal Reports, assuming that the
database design remains the same.

Hmm - OK...

I understood from the OP that he was looking to move his entire Access app
to the web, so he would need to find a web-based mechanism for showing the
reports...

 

[gover]

SQL Reporting sevices works great for this. You can embed the report on
your web page , and the report querys the user for the parameter. If you
like, you can get the parameters from the user yourself (via code) and pass
them to the swl report to run The report then appears to be just another
page in yout web-app.

 

[Marty]

http://support.businessobjects.com/communityCS/TechnicalPapers/rtm_reportingoffadonetdatasets.pdf

This solution would be perfect if it worked in VS.NET 2005.
Specifically this line returns an error: public CustomerSales oRpt =
null;

Error 1 The type or namespace name 'CustomerSales' could not be found
(are you missing a using directive or an assembly reference?) c:
\inetpub\wwwroot\tsi_cs\Default.aspx.cs 15 12 http://localhost/tsi_cs/