Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PB:Accessing Crystal reports lying Crystal Report Server using ASP.NET

Status
Not open for further replies.

Videla

Programmer
Jul 28, 2005
98
US
Hi All,
I have a Business Objects Server running in a Seperate Machine with Crystal report Server. I have IIS Server running in seperate machine. My problem is i am trying to access a crystal report in Business Object Server from ASP.NET(IIS). Below is the code i use to connect.

Dim serverName As String = "119.0.0.0"
Dim mySessionMgr As SessionMgr = New SessionMgr
Dim myEnterpriseSession As EnterpriseSession = mySessionMgr.Logon( _
"Administrator", "test", serverName, "secEnterprise")
Dim myEnterpriseService As EnterpriseService = _
myEnterpriseSession.GetService("InfoStore")
Dim myInfoStore As InfoStore = New InfoStore(myEnterpriseService)
myEnterpriseService = myEnterpriseSession.GetService("PSReportFactory")
Dim psrfObject As Object = myEnterpriseService.Interface
Dim myPSReportFactory As PSReportFactory = CType(psrfObject, PSReportFactory)
Dim queryString As String = "Select SI_ID, SI_NAME, SI_PARENTID From CI_INFOOBJECTS " _
& "Where SI_PROGID='CrystalEnterprise.Report' " _
& "And SI_NAME Like 'row_color'"
Dim myInfoObjects As InfoObjects = myInfoStore.Query(queryString)
Dim myInfoObject As InfoObject = myInfoObjects(1)
Dim myReportSource As ReportSource = myPSReportFactory.OpenReportSource(myInfoObject.ID)
cv.ReportSource = myReportSource

Output
-----
"Failed to Logon Databasse"

Other Details
-------------
1)Crystal Report Ver: XI
2)Business Objects Server Ver:XI
3)IIS 5.0
4) row_color is my crystal report name.

Question:
---------
1)Can any one help me, How to set the log on parameters to acesss the crystal Report from ASP.NET.
2) ANy other way to access the Crystal report froom Crystal report Server.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top