2 Stored Procedures for 1 Report

[stnkyminky]

I've got one report that will function from two SP's. During one function the report will need one stored procedure.

During another, separate, function the report will need to
use the other SP.

How do I change the SP refence on the fly for the report? Scott
Programmer Analyst
<><

 

[synapsevampire]

I think that you'll need to use a parameter and 2 subreports (or one).

Then based on the parameter, you can suppress whichever report is pointing to the wrong datasource.

If you're doing this from code, such as ASP/CSP/VB/etc., then you can do this in code.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com