ERPpals
21st October 2015, 20:04
Hello Guru's
I have a situation, we have developed a report in LN and that has 2 different detail layouts (A and B), in my choice, If I select A then details of A will be printed and vice versa for details of B. Now, the same report layouts has been designed in SSRS and I have created them as 2 different rows with common header. Now when I run the report I'm able to see the result in SSRS,but its displaying both layouts and as per selection the data is populated and other as a blank layout. Could someone help me to change this behavior and populate only one layout as per the selection.

Regards

benito
21st October 2015, 20:56
can you try selecting the whole row (layout), click on visibility, show or hide based on Expression. example of expression below:

=iif(TRIM(Fields!T_TNUM.Value) <> TRIM(Parameters!Parameter1.Value),True,False)

you need to decide what triggers the value True or false

ERPpals
21st October 2015, 21:45
Hi,

Thanks for your quick turnaround, unfortunately its not working.