ERPpals
12th November 2015, 23:05
Hello All,

As I knew this is a totally related to SSRS, but wanted to check if some one can help me. As I have posted this query earlier.
I have developed a report layout with 2 line details and validating in LN using a condition on tiscf001.pdno and cprrp100.orno, so my output was coming fine in LN, where as the same 2 line details were designed in SSRS as 2 rows in the same tablix, using Show or Hide using Expression, I tried to display the reports, but the report is displaying both rows. I have used the below validation for both rows.
Line 1: =IIf(LTrim(RTrim(Fields!tisfc001_pdno.Value))<>"",False,True)
Line 2: =IIf(LTrim(RTrim(Fields!cprrp100_orno.Value))<>"",False,True)

Request experts to help me in achieving this.

Thanks
:)

ERPpals
13th November 2015, 16:36
Hello All,

I have achieved this by the expression in Row visibility using a condition as below.

=IIf(Fields!tisfc001_pdno.Value <> Previous(Fields!tisfc001_pdno.Value),False,True)

and similarly in the second row also, I have used the same condition with field name cprrp100.orno, by this I could hide the row which ever I wanted to.

Thanks for all your help.

Cheers!!!

benito
13th November 2015, 17:19
isn't that what i said before?

link 1 (http://www.baanboard.com/baanboard/showthread.php?t=68294)

ERPpals
17th November 2015, 17:57
Hi,

Yes, thanks for your help.