I am having another issue, my parameters are not being passed back to the stored procedure.
I set up the parameters in the SP as @Fromdate and @ToDate. Then I initally removed the original parameters from the report expecting the SP to cause the prompt for the dates. But the report didn't ask for them. So I put them back on the report. The report now prompts me for the dates, but the SP is not seeing them.
I am getting the following message: "Failed to retrieve data from the database" "Procedure or Function expects parameter
'@FromDate', which was not supplied". How do I get the report to pass the parameters to the SP?