I have a system DSN on my machine for developing reports and connecting to my SQL Server database. I have used a stored procedure, which can accept 3 numeric parameters but requires only one to work, to develop my report. As I was developing the report, I was able to preview the report with the data. Everything seemed to be working fine. I closed the report and when I re-opened it, I was no longer able to view any data. I am not saving the data with the report so I passed the parameter required and nothing would show in the preview pane.
Ordinarilly, if I select view Database-Show SQL Query, I would see the following: EXEC Accident.dbo.usp_incident_details_report 683, NULL, NULL.
Instead I am seeing this: {call Accident.dbo.usp_incident_details_report;1(?,?,?)}.
There seems to be nothing that I can do to correct this but since it is a rather long report, I would rather not have to re-create it. Any help would be appreciated.
Ordinarilly, if I select view Database-Show SQL Query, I would see the following: EXEC Accident.dbo.usp_incident_details_report 683, NULL, NULL.
Instead I am seeing this: {call Accident.dbo.usp_incident_details_report;1(?,?,?)}.
There seems to be nothing that I can do to correct this but since it is a rather long report, I would rather not have to re-create it. Any help would be appreciated.