Active Data Driver - ASP Project

[delu0007]

How do I view reports based on the Active Data Driver through an ASP Project? I have reports that are based on the Active Data Driver to connect to either MS Access 2000 or MS SQL Server 2000 databases. I have a VB Application and an ASP Project designed to view these reports. The VB Application is working properly, but I can't figure out how to view the reports in my ASP Project.

My ASP Project had been set up to view reports based on the Access driver (p2smon), but I changed my reports to the Active Data Driver to be able to use Access and SQL Server data.

My VB Project uses the automation server and uses SetLogOnInfo and SetPrivateData functions for each table and subreport table in the report. I am trying to use the same functions in the ASP Project, but I am getting "Type Mismatch" errors trying to use SetLogOnInfo and "Object doesn't support this action" errors with SetPrivateData.

Any Ideas? Sample code segment would be appreciated.

 

[Ibtisam]

I faced the same situation. I was trying to view my report through ASP page and connecting to sql server. It works fine, with using the activeX controls.

I think the "type mismatch" error you got because the parameter type you send to the report is not of the same type that used in the report it self.

You can get the complete code from crystaldecision site.