How can I conditionally call a stored procedure in RS2005 when using a command type of 'Stored Proc'?
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.
DB Reporting ToolsMicrosoft SQL ServerMicrosoft SQL Server 2005
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!