DeniedABrain
Programmer
I'm new to Crystal Reports and don't really know what I'm doing.
I have a vb.net windows app with a reportviewer.
I've designed a report with cr9 which gets it's data from a stored Procedure. the stored Procedure has three input parameters. When I refresh the report in the designer, I am prompted for values for the parameters, then the sp is called and the report is refreshed.
When I open the same report in my app, it prompts for the parameters, then displays nothing in the report viewer.
I added logging to the sp so that I could check what values are being passed to the sp, but the sp doesn't even get called when the report is refreshed. I have save data with report turned off.
I've tried adding in a routine to loop through the parameters and manually request them from the user. This still presents a blank report.
My code is:
Private Sub Display_Report()
Dim crDoc As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
With crv
.ReportSource = txtPath.Text
.Refresh()
.Show()
End With
End Sub
I've tried it without the .Refresh(), without the .Show(), even with .RefreshReport() All to no avail.
Thanks for your help.
I have a vb.net windows app with a reportviewer.
I've designed a report with cr9 which gets it's data from a stored Procedure. the stored Procedure has three input parameters. When I refresh the report in the designer, I am prompted for values for the parameters, then the sp is called and the report is refreshed.
When I open the same report in my app, it prompts for the parameters, then displays nothing in the report viewer.
I added logging to the sp so that I could check what values are being passed to the sp, but the sp doesn't even get called when the report is refreshed. I have save data with report turned off.
I've tried adding in a routine to loop through the parameters and manually request them from the user. This still presents a blank report.
My code is:
Private Sub Display_Report()
Dim crDoc As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
With crv
.ReportSource = txtPath.Text
.Refresh()
.Show()
End With
End Sub
I've tried it without the .Refresh(), without the .Show(), even with .RefreshReport() All to no avail.
Thanks for your help.