borders in reports

lamis
lamis Member Posts: 46
in NAV Three Tier
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,

Answers

  • kriki
    kriki Member, Moderator Posts: 9,124
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Sowkarthika
    Sowkarthika Member Posts: 102
    Instead of hiding the textbox you can hide the value displayed in textbox.

    IIF(Fields!HideTotalQuantity.Value = "False",sum(Fields!Item_Qty_.Value) ,"")
  • lamis
    lamis Member Posts: 46
    I have tried to put this in the expression of the field but it didn't work!
  • Antoniomvalls
    Antoniomvalls Member Posts: 34
    edited 2017-05-10
    Or you can put the border in the above field...
    Giving thanks is always wellcome
  • lamis
    lamis Member Posts: 46
    how can this be done?
  • Antoniomvalls
    Antoniomvalls Member Posts: 34
    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

    Giving thanks is always wellcome

Categories