Running a stored procedure fails

[HighAley]

Hello.

We need a little more time to prepare an answer for you.

Thank you.

[Alex K.]

Hello,

Please send us your report with test data for analysis.

Thank you.

[davids]

StimSQL.txt

change from .txt to .sql and run

(5.01 MiB) Downloaded 245 times

I had to trim many records to save this script, so please let me know if I removed some records that prevent you from saving the sp.

I will load the updated report next.

[davids]

Here is the latest report.

icrpt3a.1.mrt

Latest version

(47.24 KiB) Downloaded 444 times

[HighAley]

Hello.

Sorry, we need a little more time to prepare an answer for you.

Thank you.

[Alex K.]

Hello,

Please check the modified report in attachment.

Thank you.

[davids]

Well, the report will actually run without throwing an error. However, since I am not running the same edition as you, I do not have the form for populating the variables and so cannot verify the results in the report.

What changes did you make so I know how to do it in my reports?

[davids]

Ok, using your report, I was able to see the changes to the data type for the date fields. I copied those changes and was able to get my report to run without errors (I thought I had already tried that, but perhaps not all at once).

However, I am still unable to get it to prompt for user input and no data displays in the report

[Alex K.]

Hello,

Can you please describe the next moment in your report:
The data source parameters are used, in which the variables are used, which take a value from the data source. The loop occurs. The variable cannot be obtained because there is no data in the data source. The data source cannot get the data, because the values or the variables are not set.

Thank you.

[davids]

I had an issue with my connection string. I was able to get the report to run and show the data, but I cannot get the param form to display so the user could change the param values.

Your screen shot shows this form, how do I enable it with my edition?