mibuso.com
Home› NAV Three Tier
Options

Visibility Handling

omyvadiyaomyvadiya Member Posts: 124
edited 2013-11-20 in NAV Three Tier
Hi,
I have a report in Nav 2009 R2.
I have 2 fields which is some txt data, which prints well when both fields have data.
But when 1st field has data and the other is not having data.. the data of 1st must be extended to the empty space of 2nd.
Similarly when the 2nd has data, it must overlap the 1st's empty space and must continue to its space, and must not go in 2nd line.

Comments

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    Did you try by combining them both in CAL and send to rdlc using a global text variable etc..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • Options
    omyvadiyaomyvadiya Member Posts: 124
    Both the values are coming from variables in CAL, but handling there visibility is the problem.
    I tried creating 3 different rows in rdlc with different visibility.

    1. with both have data.
    2. only 1st <> "" and 2nd = ""
    3. only 2nd <> "" and 1st = ""

    But if both have data its prints the correct row (1. with both have data.)
    When (Only 1st <> "" and 2nd = "") then its prints, but it prints, but at the same time the 1st condition is also true. and it prints both.
    and the same happens with -> Only 2nd <> "" and 1st = ""

    ](*,)
  • Options
    geordiegeordie Member Posts: 655
    Instead of using ="" as comparison expression, try using IsNothing function.
    * Daniele Rebussi * | * Rebu NAV Diary *
  • Options
    omyvadiyaomyvadiya Member Posts: 124
    Isnothing function is also not working.
    ](*,)
  • Options
    geordiegeordie Member Posts: 655
    As an alternative you could simply manage rows visibility through 3 boolean variables evaluated via C/AL in OnAfterGetRecord trigger :)
    * Daniele Rebussi * | * Rebu NAV Diary *
  • Options
    skullaskulla Member Posts: 140
    What is the condition you are using for the first row when both have data? How about concatenating two fields ?
    Suresh Kulla
    ArcherPoint, Inc http://www.archerpoint.com
    Blog: http://www.navisionworld.com
    skkulla
  • Options
    ChinmoyChinmoy Member Posts: 359
    Can concatenating the values of both text variables into a single text variable and printing the concatenated text be an option?
  • Options
    clauslclausl Member Posts: 455
    Here is what you need:
    =iif(Len(Fields!Field1.Value) = 0, "", Fields!Field1.Value & " ") & iif(Len(Fields!Field2.Value) = 0, "", Fields!Field2.Value)

    I suggest you also read my Filtering "Best Practice" blog post:
    http://mibuso.com/blogs/clausl/2013/07/06/filtering-and-visbility-best-practice/

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • Options
    omyvadiyaomyvadiya Member Posts: 124
    Thanx a lot clausl..it works :)
Sign In or Register to comment.