He tratado de llamar un reporte desde ASP Net. El reporte está hecho de un store procedure que recibe parámetros. Lo que no logro hacer es pasarle los parámetros de forma dinámica. He hecho esto:
Dim Report As New Reporte2
'Dim report As New Prest_Comerciales
Dim exportOpts As New CrystalDecisions.Shared.ExportOptions
Dim diskOpts As New CrystalDecisions.Shared.DiskFileDestinationOptions
'================
Dim pv As New CrystalDecisions.Shared.ParameterValues
Dim pdv As New CrystalDecisions.Shared.ParameterDiscreteValue
'================
diskOpts.DiskFileName = "c:\Reporte.pdf"
Report.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize
Report.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.DefaultPaperOrientation
Dim crTables As CrystalDecisions.CrystalReports.Engine.Tables
Dim crTable As CrystalDecisions.CrystalReports.Engine.Table
Dim crConnInfo As New CrystalDecisions.Shared.ConnectionInfo
Dim crLogOnInfo As CrystalDecisions.Shared.TableLogOnInfo
crTables = Report.Database.Tables
For Each crTable In crTables
crConnInfo.DatabaseName = "DatabaseName "
crConnInfo.ServerName = "ServerName "
crConnInfo.UserID = "UserID "
crConnInfo.Password = "Password "
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo = crConnInfo
crTable.ApplyLogOnInfo(crLogOnInfo)
Next
'================
pdv.Value = txtFecha.Text.Trim
pv.Add(pdv)
Report.DataDefinition.ParameterFields(0).ApplyCurrentValues(PV)
¿Alguien me puede ayudar? |
