Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-06-04 : 05:35:45
|
| Hi ! Can I define navigation from one report to another one on condition, for example, if field value is not null? |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-04 : 09:38:36
|
| On the navigation tabe for the report, in the section where you specify a "sub report" to navigate to, you should be able to use an expression that evaluates to some value(ie: true, false, etc.), the sets the navigation destination to the report.IE: iff( "field_to_test", "report1", "report2")If field_to_test is true, report1 is used, otherwise report2.Sorry I cannot provide more specifics, I am not at home where all my software and documentation is. I believe the above should work.Talk sense to a fool and he calls you foolish. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-04 : 13:26:07
|
quote:
Originally posted by Tasta
Hi ! Can I define navigation from one report to another one on condition, for example, if field value is not null?
give as navigation option something like=IIF(Fields!yourfield.value,"Your drilldown report",nothing) |
|
|
|
|
|
|
|
|
Navigation in SSRS on condition