With regards captioned subject & the related querry posted earlier http://scn.sap.com/thread/3448439
- %TEMP% folder has all the access rights. It has been repeatedly tested & confirmed.
- BW v3.1 is installed & configured. The table used at backend is ZBOARD.
- The report fails to load even if its complete path is hard coded.
- I have also tried deploying it as IIS virtual directory but with the same results
- However using VS 2005 walkthroughs, i did try the code snippet provided for logging on to Secure SQL server as follows. The error changes to "Failed to Log On to Crystal Objects Repository"
Private Sub ConfigureCrystalReports()
Dim reportPath As String = Server.MapPath("CrystalReport.rpt")
myCrystalReportViewer1.ReportSource = reportPath
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()
myConnectionInfo.DatabaseName = "Northwind"
myConnectionInfo.UserID = "limitedPermissionAccount"
myConnectionInfo.Password = ""
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo)
Dim myTableLogOnInfos As TableLogOnInfos = myCrystalReportViewer1.LogOnInfo()
For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos
myTableLogOnInfo.ConnectionInfo = myConnectionInfo
What i need to know is
1. Do i need to pass some sort of connection string in the code behind the aspx page displaying the report ? If yes, kindly provide sample or some resource
2. What else could be wrong in this solution apart from the issues highlighted earlier like TEMP folder authorizations ?
3. Is SAP connector needed here for connection or not ? If yes than how to configure it. (The only way on www is using vs2003 & then calling the same function in vs 2008 but it is confusing in context of my project)
many thanks in advance
M Bilal Khan