how to display Tables with Row Visibility Property

Business Central/NAV Developers Forum
1

Hi,

My Problem is I generated a report with Three Tables in body section and in Request Page CHeck FOr Option variable of

Item,Item Variant,Item Cross Reference Options are there

So my Problem is When i Give Item For Check for FIRST TABLE Will Display Thats why i am taking a variable Itemb is a boolean variable and i write a code in OnPreReport

IF CheckFOr=CheckFor::“Item” THEN

ITEMB:=true

ELSE

ITEMB:=false;

and in table1 visibilty Property IIF(FieldS!ITEMV.Value,False,True)

When i Give Item Variant For Check for Second TABLE Will Display Thats why i am taking a variable ItemV is a boolean variable and i write a code in OnPreReport

IF CheckFOr=CheckFor::“Item Variant” THEN

ITEMV:=true

ELSE

ITEMV:=false;

and in table2 visibilty Property IIF(FieldS!ITEMB.Value,False,True)

When i Give Item cross Reference For Checkfor Third TABLE Will Display Thats why i am taking a variable ItemR is a boolean variable and i write a code in OnPreReport

IF CheckFOr=CheckFor::“Item Cross Reference” THEN

ITEMR:=true

ELSE

ITEMR:=false;

and in table3 visibilty Property IIF(FieldS!ITEMR.Value,False,True)

When i Run this report BOdy section not displayed When i use Debugger itemb,itemV,ItenR Getting VAlues

Pls Solve My problm…

Thanks And Regards,

Akil Reddy

2

You have not mention in which version you are creating report .

3

Hi Amol,

I Used Nav 2013 r2 with vs2012 RDLC

4

remove all the boolean variables ITEMB,ITEMV,ITEMR.

add the CheckFor variable as field CheckFor to the first dataitem.

change the visibility expressions like that: =IIF(Fields!CheckFor = “Item”.Value,False,True)

and try again.

5

little change to the expression:

=IIF(Fields!CheckFor.Value = “Item”,False,True)

6

Hi Jonathan,

I Give as u Said =IIF(Fields!CheckFor.Value = “Item”,False,True) But it Displays all the tables at a time

7

Hi Jonathan,

I Given as you Said but it display all Tables at a time

Thanks And Regards,

Akil Reddy

8

Hi,

You can try using CheckFor field as an Option field with values Item,Item Variant,Item Cross Reference

then use this expression =IIF(Fields!CheckFor.Value = “Item”,False,True) For first Table

=IIF(Fields!CheckFor.Value = “Item Variant”,False,True) For second table and same for third table.

9

Hi Jain,

I tried as you Said but all Tables displayed at same time when i Give Item,Item Variant,Item Cross Reference in request page

10

Hi Ramesh,

where you place this field in your report?

11

Hi Jain,

in My Report Data is Not Available So it not working

Now i Get Data it’s work Perfectly

Thank And Regards,

Akil Reddy

12

does it work now as you need?

what was your solution?

13

Hi Jonathan,

Actually my Report Didn’t Have a Data that’s why It displays all tables at a time

Now i Have a data It displays correctly

Thanks For your Suggestion…

Best Regards,

Akil