How to display two different subreports using hide

hello,

  Is there a way to display to two different subreports. I used the switch code below is does not seem work for me.

=Switch(IsNothing(Fields!ProductStatusCode.Value) 
or Fields!ProductStatusCode.Value=0 
or Fields!ProductStatusCode.Value=1 
or Fields!ProductStatusCode.Value=3, "/Products/NotradeMarkinfo",
Fields!ProductStatusCode.Value=2, "/Products/trademarkInfo")

May 29th, 2015 4:04pm

Hi Xitum,

You should have two differents subreports into your matrix or table columns. See the following sample below: 

The expression in SubReport1 is :

=iif(IsNothing(Fields!ProductStatusCode.Value) 
or Fields!ProductStatusCode.Value=0 
or Fields!ProductStatusCode.Value=1 
or Fields!ProductStatusCode.Value=3,true,false)

The expression in SubReport2 is the opposite :

=iif(IsNothing(Fields!ProductStatusCode.Value) 
or Fields!ProductStatusCode.Value=0 
or Fields!ProductStatusCode.Value=1 
or Fields!ProductStatusCode.Value=3,false,true)

Best R

Free Windows Admin Tool Kit Click here and download it now
May 30th, 2015 10:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics