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.
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.