RDLC report conversion

northernernortherner Member Posts: 67
edited 2011-02-25 in NAV Three Tier

I'm trying to get up to speed with RDLC reporting.

On the Customer/Item Sales report (report 113), in the classic version, we've got an extra option called 'Summary Report', and in the Integer, Body (1) section there's some code to show the output of the section or not:
IF SummaryOnly then

I've created a new Boolean called 'Hidden' and added this to the report as an invisible field in the same body section. In the RDLC layout, I have also added this as an invisible field on the Table Row. I want to set a visibility expression to show or hide the whole row depending on the value of the field. However - there's already an expression there and I'm not sure how to modify it. The existing expression is
=IIF(Fields!ValueEntryBuffer__Item_No__.Value = "",true,false)

Can anybody suggest what this needs to be changed to?



  • ara3nara3n Member Posts: 9,253
    The code checked if Item No. is blank then print the values otherwise no.

    Leave the logic as is and add your to it
    =IIF(Fields!ValueEntryBuffer__Item_No__.Value = "",TRUE,FALSE) and 
    (not SummaryOnly)
    Ahmed Rashed Amini
    Independent Consultant/Developer

    blog: https://dynamicsuser.net/nav/b/ara3n
  • northernernortherner Member Posts: 67
    That was a good hint, thanks :-)

    I think I've got it working with
    =IIF((Fields!ValueEntryBuffer__Item_No__.Value <> "") and (fields!Hidden.Value = false),FALSE,true)
Sign In or Register to comment.