Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure not called on .refreshreport

Status
Not open for further replies.

DeniedABrain

Programmer
Aug 4, 2003
1
AU
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.
 
hi
is your app design to run crystal 9 version report?
you need to have all the dll loaded

cheers

pgtek
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top