Hello everyone,

I have recentlty developed a web application across my clients intranet. We used ASP with Interdev 6.0 and SQL server as the backend.

They have now come to me asking me to develop some reports that can be accessed via a drill down within the app. They don't have Crystal Reports so this is not an option. Can anyone suggest an alternative to using crystal reports to publish dynamic reports via the web and ASP?

Thanks in advance,
Jeff

you may use ACCESS database for reports.
use ACCESS reports tools and you can be accessed via a dril down
within the app. create form on ACCESS and put form on Intranet etc.

But if I create them in access will they have any of the limitations that access has? There is potential for many users and I know access isn't great as your user base increases.

Also, can these reports just be called as web pages? Or how do you display them via a browser?

Jeff

check out http://www.datadynamics.com/Products...tFeatures.aspx

The ActiveReports v2.0 product (not the .NET version as you mention VID 6 and ASP) is not too expensive and it can be used from within VB, Access, ASP - a lot of different environments. Basically anywhere you can instantiate a COM object.

You wont need the Pro version unless you want to give the users the ability to develop reports of their own, on their own.

Hope that helps.

ADDED --> Prices are less expensive at places such as Programmers Paradise, etc...

you can save report as html formate.

for this right click the ACCESS report and save as database access page. It will create html file, html file you can use in browser

secondly, you may create forms in ACCESS database, and link the form witht the reports. and save forms as database access page, it will
create html file, html file may be use in browser.
but you have to work on it, you will need to create link
in forms with the reports.html pages.

if you have problem in creating forms with reports link you may simply create reports html pages. for this,

right click the reports
and send to mail recipient (as attactment) it will send all reports html pages to your e.mail address.