#Crystal reports runtime download x64 code

Note - SO doesn't like VB comments and wants to call them (and subsequent lines) literal strings instead. MyTableLogonInfo.ConnectionInfo = mењњonnectionInfoД¬rystalReportViewer1.ReportSource = myReport MењњonnectionInfo.DatabaseName = '' - leave database name blank MyReport.Load(Server.MapPath('ReportName')) - name of the crystal reportДim myTables As Tables = ДЇor Each myTable As In myTablesДim myTableLogonInfo As TableLogOnInfo = myTable.LogOnInfo Then, in the Page_Init handler, re-apply connection info: Dim mењњonnectionInfo As ConnectionInfo = New ConnectionInfo() In case that link dies, the solution is in two steps:ДЇirst, import these: Imports CrystalDecisions.Shared

#Crystal reports runtime download x64 code

This article provides code examples and a link to MSDN explaining the ConnectionInfo class and how it works in this context. Essentially, the authentication details are reset on a postback and need to be reassigned in the Page_Init handler. This is a common problem with embedding Crystal Reports in ASP pages. We must call the parameter's name without any additional character such or ?, just only the parameter's name itself. RptH.ExportToHttpResponse(ExportFormatType.PortableDocFormat, .Response, false, 'GL') RptH.SetParameterValue('Date_To', todate) Д¬rConnectionInfo.ServerName = 'YOUR SERVER NAME' Д¬rConnectionInfo.DatabaseName = 'YOUR DATABASE NAME' Д¬rConnectionInfo.UserID = 'YOUR DATABASE USERNAME' Д¬rConnectionInfo.Password = 'YOUR DATABASE PASSWORD' ДЇoreach ( CrTable in CrTables)Д¬rtableLogoninfo.ConnectionInfo = crConnectionInfo Д¬rTable.ApplyLogOnInfo(crtableLogoninfo) RptH.SetParameterValue('Date_From', fromdate) RptH.Load(Server.MapPath('~/Rpts/G1.rpt'))

TableLogOnInfo crtableLogoninfo = new TableLogOnInfo() Д¬onnectionInfo crConnectionInfo = new ConnectionInfo() TableLogOnInfos crtableLogoninfos = new TableLogOnInfos() Then we we must give database access to the report because without login to database the report will not be opened.ДЄnd here is the code: ReportDocument rptH = new ReportDocument() NOT rptH.SetParameterValue('?Date_From', fromdate) //incorrect We should pass the parameter value like this: rptH.SetParameterValue('Date_From', fromdate) //correct