How To: Call stored proc from a formula

[Waz816]

Cr 9.0
SQLServer 2K

Is it possible to call a stored procedure from a formula?

My stored proc has 3 parameters. I can live with those parameters being hard coded if I can create a formula for each parameter combination. It returns a single count value depending on those parameters. I have 4 other procs that return similar data, but for different processes.

Any help would be appreciated. Thanks in advance.

 

[GMcNamara]

I don't think this is possible. You can however incorporate the stored procedure into your SQL Command and the results of the proc become a part of your dataset.

 

[synapsevampire]

You might handle this by placing the SP as the data source for a subreport and passing the parms to the sub, though I'm not sure, I've never tried it.

If you're using an external programming language you can do this (such as VB).

-k