Visibility Handling

omyvadiya · 2013-11-14

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 · 2013-11-14

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

omyvadiya · 2013-11-14

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 · 2013-11-14

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

omyvadiya · 2013-11-14

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

geordie · 2013-11-16

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

skulla · 2013-11-17

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

Chinmoy · 2013-11-18

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

clausl · 2013-11-18

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 · 2013-11-20

Thanx a lot clausl..it works

Visibility Handling

Comments

Categories