Execute Report from Asp. NET

rbuser

I'm fairly inexperienced in RB and Delphi and I think I'm over my head.

My application consists of an accounting system back office written in
Delphi 7 with SQLServer 2000. There is a web ASP.Net / SQLServer 2000
application for the general user population to enter transactions, which are
imported into the accounting systemvia stored procs. All reports are built
in Delphi / Report Builder. The two parts of the application do not interact
directly except for one report. We will be implementing the RB report
server, which should solve all problems, but we're not quite ready for it.

I'm looking for a simple temporary solution for this one report. I need to
execute a delphi app to create this report from the web side, create a PDF
and display it in a webpage on the web side. I had a brainstorm and tried
creating an Active form, putting on the webpage and running it. It seems to
work ok but it seems to have an issue recognizing the ADO Connection. I
suspect there are bigger problems with this method. Can anyone suggest a fix
or a better solution?

Thanks, Mark

nardmoseley

1. One option is to use RB Server Edition - even if its just one report.

This solution will require the least amount of development time and effort.
I recommend first working thru the tutorials in the RB Server Developers
Guide. Then download our ASP.NET example from

www.digital-metaphors.com/tips/AspDotNetWebTier.zip


2. The other alternative I recommend is to use Delphi to create a COM object
that can be called from the ASP.NET application. (Delphi and .NET both
contain good COM support).