Skip to Content
0
Former Member
Mar 22, 2010 at 01:53 PM

asp.net and Crystal Report with Oracle Data

310 Views

This is my first project to allow internal users to run Crystal Reports from an intranet application so I am new to the subject. Basically I simply need to insert a CrystalReportViewer control onto a asp.net page.

Environment: MS IIS web server. Development tools: Visual Studio 2005 (or 2008), Crystal Enterprise Version 10 (or Crystal Report for .net)

I have already got some previously designed Crystal reports that access Oracle data via an odbc connection. Question: Do I need to change the report to access Oracle data via an MS sql server? I mean do I need to change my report to receive data via stored procedure, after creating a new stored proc (in MS Sql Server) to retreive Oracle data.

I asked this because:

1) the tutorial VS2005_Walkthroughs.pdf available from this website only describes how to use a Ms sql server as source of data.

2) Users do not need to enter database creditials again if we enable integrated Windows security

3) I've tried to keep the Crystal Report as it is. Then I run into a problem when the user try to access the report via a web page. The browser keeps requesting database logon information from the user again and again. However, when I run in debug mode (under Visual Studio), the logon screen displays only once and the report appears to work.

Thanks.