Advertisement

05.20.2008 at 07:49PM PDT, ID: 23419517 | Points: 250
[x]
Attachment Details

How can I conditionally call a stored procedure in RS2005 when using a command type of 'Stored Proc'?

Asked by freedo55 in SQR, MS SQL Server, SQL Server 2005

Tags: ,

Hello All,

I'm using SQL RS 2005 and have a report where we want the report to run a different stored procedure depending on if a condition is true.  I've set my 'command type' to stored proc and can type in the name of a stored procedure.  If I type in just one stored procedure, it runs fine.  But if I try to use a =IIF(condition, if true run stored proc 1, if false run storedproc 2) but the exclamation (run) button is greyed out.  Does anyone know how I can do this?  Thanks.Start Free Trial
[+][-]05.20.2008 at 08:32PM PDT, ID: 21611967

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 08:35PM PDT, ID: 21611983

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 08:37PM PDT, ID: 21611994

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 08:47PM PDT, ID: 21612022

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 08:54PM PDT, ID: 21612038

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.20.2008 at 09:29PM PDT, ID: 21612131

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2008 at 03:30PM PDT, ID: 22683045

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628