April 6, 2012 at 5:43 pm
Hi ,
In my report using list tablix to show the customer address. The table has column like addr1, addr2, addr3. I am using three textboxes inside List to show the address. In report after the addr1 value the invoice number is there in same row.I am showing customer address left side corner and invoice information in right side.
If any addr doesn’t have value I want to hide the textbox. I tried below expression in visibility of text box
=IIF(Len(Fields!addr2.Value) < 1, true,false)
But I am getting space intermediate addr1 and addr3 in the list tablix .I need to show addr3 after addr1 if addr2 doent have any value.
I tried with placeholder and without List tablix also still same problem.
I changed my SQL query as below,
case when(Len(CUST.addr1)>1)then Ltrim(rtrim(CUST.addr1)) else ''
end+ ' ' +
case when(Len(CUST.addr2)>1)then Ltrim(rtrim(CUST.addr2)) else ''
end+ ' ' +
case when(Len(CUST.addr3)>1)then Ltrim(rtrim(CUST.addr3)) else ''
end as Address
But now I am facing different problem. Thress column value as one string so it shows as continuous string.I need to show addr1 in one line, addr2 in next line and addr3 next line. Is any way to show seperate line?
Please give your valuable suggestions to show address without space intermediate.
Thank you
April 9, 2012 at 7:07 am
You can add
& VbCRLF &
to add a carriage return/line feed to your expression.
April 10, 2012 at 3:10 pm
Thank you Daniel.
I solved the problem, i added '%' at end of addr1 and addr2 in the SQL query. In ssrs used Replace() function to replace % with vbCrLf.
I got the address in seperate lines.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply