Visibility Handling

omyvadiya

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.

mohana_cse06

Did you try by combining them both in CAL and send to rdlc using a global text variable etc..

omyvadiya

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 = ""

](*,)

geordie

Instead of using ="" as comparison expression, try using IsNothing function.

omyvadiya

Isnothing function is also not working.
](*,)

geordie

As an alternative you could simply manage rows visibility through 3 boolean variables evaluated via C/AL in OnAfterGetRecord trigger

skulla

What is the condition you are using for the first row when both have data? How about concatenating two fields ?

Chinmoy

Can concatenating the values of both text variables into a single text variable and printing the concatenated text be an option?

clausl

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

omyvadiya

Thanx a lot clausl..it works