Options

LeaderDots property equivalent in RTC

poppinspoppins Member Posts: 647
edited 2014-12-31 in NAV Three Tier
Hi everyone,

Is there an equivalent of the classic property LeaderDots for 2013 R2 reports?

Thanks in advance :)

Answers

  • Options
    Jan_VeenendaalJan_Veenendaal Member Posts: 206
    Hi,
    You could do this:
    (1) Create a function in your report (in VS):
    Public Function LeaderDots (ByVal Text as String, ByVal PadLength as integer) as String
      Dim Pad as Char
      Pad = Convert.ToChar(".")
      Return Text.PadRight(PadLength, Pad)
    End Function
    

    (2) place the value you want to show in a textbox

    (3) Change the expression of the textbox like this:
    =Code.LeaderDots ( YourValue , 100 )
    
    where YourValue is the original value, and 100 is the padded length you want in the resulting string (set this to a high value).

    (4) set the 'CanGrow' property of the textbox to False
    Jan Veenendaal
  • Options
    poppinspoppins Member Posts: 647
    Hi,
    You could do this:
    (1) Create a function in your report (in VS):
    Public Function LeaderDots (ByVal Text as String, ByVal PadLength as integer) as String
      Dim Pad as Char
      Pad = Convert.ToChar(".")
      Return Text.PadRight(PadLength, Pad)
    End Function
    

    (2) place the value you want to show in a textbox

    (3) Change the expression of the textbox like this:
    =Code.LeaderDots ( YourValue , 100 )
    
    where YourValue is the original value, and 100 is the padded length you want in the resulting string (set this to a high value).

    (4) set the 'CanGrow' property of the textbox to False

    So, we have to add some VB code to accomplish this :mrgreen:
    Thanks a lot :)
Sign In or Register to comment.