Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
tablix visibility
Horse06
Member Posts: 496
Hi expert, I have a question on the tablix visibility of my report.
On Visibliity of the Tablix of the table, the content will show or hide based on an expression, I have the following code
=IIf(Fields!Status.value=2)
Status is an option and has two option values: complete and imcomplete. But the report cannot be saved and it has an error. Please advise! Thank you!
On Visibliity of the Tablix of the table, the content will show or hide based on an expression, I have the following code
=IIf(Fields!Status.value=2)
Status is an option and has two option values: complete and imcomplete. But the report cannot be saved and it has an error. Please advise! Thank you!
0
Comments
IIF needs to have the true and false values, so you need...
=IIF(Fields!Status.value=2,TRUE,FALSE)
Also note that if you option only has those 2 values and not a blank value (usually at the start) then those values would be 0 for complete and 1 for incomplete