Skip to Content
0
Former Member
Nov 05, 2013 at 03:30 AM

SAP Crystal Reports, VS 2008, IIS v7 & SAP BI/BW

21 Views

Greetings!

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 = ""
SetDBLogonForReport(myConnectionInfo)
End Sub

Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
ConfigureCrystalReports()
End Sub

Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo)
Dim myTableLogOnInfos As TableLogOnInfos = myCrystalReportViewer1.LogOnInfo()
For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos
myTableLogOnInfo.ConnectionInfo = myConnectionInfo
Next

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