Has anybody been able to query a stored procedure with parameters yet?
I can't seem to get it to work. It fails. The log indicates that the parameters are not getting passed to the stored procedure. I have them set up explicitly in the stored procedure with string values, as set up in my stored procedure.
I have added the data source to my report. I have created a query, am able to reference the stored procedure. The Reporting interface recognizes the parameters required by the stored procedure. Even if I type the values into the parameters of the stored procedure in the report, they don't get passed to the stored procedure in the database. The log shows that they are blank:
I'm not sure if this log file stays on the system, or requires sign-in, but here's a link to the log ouput for the report preview:
-
This usually happens... It's working now.
I upgraded to the latest release (5.5) and it appears to be working now.
0 -
I'm stuck on this problem, so I'm interested in knowing how you solved it.
My store procedure below works fine in SQL but fails when called through vertigis reporting. I guessing its syntax related to how parameters are passed in vertigis reporting? Does anyone have a simple working example they are able to share?
0 -
For your information, I resolved my issue by deleting and re-adding the query report fields to my VertiGIS report
0
Please sign in to leave a comment.
Comments
3 comments