Page 3 of 4
Re: Running a stored procedure fails
Posted: Thu Dec 20, 2012 1:00 pm
by HighAley
Hello.
We need a little more time to prepare an answer for you.
Thank you.
Re: Running a stored procedure fails
Posted: Fri Dec 21, 2012 5:49 am
by Alex K.
Hello,
Please send us your report with test data for analysis.
Thank you.
Re: Running a stored procedure fails
Posted: Sat Dec 22, 2012 3:01 am
by davids
- StimSQL.txt
- change from .txt to .sql and run
- (5.01 MiB) Downloaded 318 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.
Re: Running a stored procedure fails
Posted: Sat Dec 22, 2012 3:02 am
by davids
Here is the latest report.
Re: Running a stored procedure fails
Posted: Sat Dec 22, 2012 1:55 pm
by HighAley
Hello.
Sorry, we need a little more time to prepare an answer for you.
Thank you.
Re: Running a stored procedure fails
Posted: Fri Dec 28, 2012 12:31 pm
by Alex K.
Hello,
Please check the modified report in attachment.
Thank you.
Re: Running a stored procedure fails
Posted: Wed Jan 02, 2013 3:48 pm
by 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?
Re: Running a stored procedure fails
Posted: Wed Jan 02, 2013 4:11 pm
by 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
Re: Running a stored procedure fails
Posted: Thu Jan 03, 2013 12:33 pm
by 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.
Re: Running a stored procedure fails
Posted: Fri Jan 04, 2013 12:02 am
by 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?