borders in reports

lamis

Hello,
I have a report which includes a field (sum(Fields!Item_Qty_.Value) ). I want to make it optional, So I created on the request page boolean variable (HideTotalQuantity). Once it is selected then the totals won't be shown.
But my problem is, The field has a border, when i select the hide total quantity, the value and the border disappear.
I just want the value to disappear and not the border.
Please advise.
Thank you,

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

Sowkarthika

Instead of hiding the textbox you can hide the value displayed in textbox.

IIF(Fields!HideTotalQuantity.Value = "False",sum(Fields!Item_Qty_.Value) ,"")

lamis

I have tried to put this in the expression of the field but it didn't work!

Antoniomvalls

Or you can put the border in the above field...

lamis

how can this be done?

Antoniomvalls

if it is a table then select the above cell and put there a bottom border if it isnt u can put a line instead of the border in the field