Running a MSSQL Server stored procedure

[Anonymous]

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

[Gysbert_Wassenaar · Accepted solution]

First you create a connection to the database and then you execute the stored procedure.

SQL Exec MyStoredProcedure(Parameter1, Parameter2, ...etc );

[Anonymous]

Many thanks Gysbert most appreciated

[rustyfishbones]

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)

[Anonymous]

Thank you very  much Alan