Conditional Jump to Report in SRS 2000

[dldev]

Hello, I've been researching this for some time. Does anyone know if you can conditionally jump to a report? Something like this:

=iif(Fields!TEST.Value = "?????" And Fields!TEST2.Value > 0, TestDetailReport, "")
I've tried this based on the text color also but keep getting errors like this:

The expression for the textbox ‘TESTBOX’ contains an error: [BC30451] Name 'TestDetailReport' is not declared.

Is what i'm trying to do here just not possible?

Thanks,
Dennis

 

[nickdel]

Dennis, "iif" is a MS Access function and not SQL Server.

Nick

 

[ESquared]

Please ask your question in forum SQL Server Reporting Solutions.

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

[sub]The best part about anything that has cheese is the cheese.[/sub][/color]