Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can one run a Microsoft SQL Server stored procedure from a QV application and use it to write a report? If so how can this be accomplished?
Regards.
Chris
First you create a connection to the database and then you execute the stored procedure.
SQL Exec MyStoredProcedure(Parameter1, Parameter2, ...etc );
First you create a connection to the database and then you execute the stored procedure.
SQL Exec MyStoredProcedure(Parameter1, Parameter2, ...etc );
Many thanks Gysbert most appreciated
Example below, where the parameters are pointing to Qlikview Variables, that can be changed via an Input Box on the Qlikview front end.
Still figuring it all out!
ODBC CONNECT TO Extreme;
SQL EXECUTE dbo.spUPS
@Shipper = [$(vShipper)],
@OrderNo = $(vOrderNo),
@OrderAmount = $(vOrderAmount)
Thank you very much Alan