Empty space in RDLC Report
IvonaK
Member Posts: 115
Hi to all,
I have made a Report and I put code on Visible tab on Details Group. (picture 1)

also I put code in Filters (picture 2)
but there is still empty space
Any advice,
Thanks
I have made a Report and I put code on Visible tab on Details Group. (picture 1)

also I put code in Filters (picture 2)

but there is still empty space
Any advice,
Thanks
0
Answers
-
Hey Ivonak,
There could be many possibilities for the blank rows, You need to identify first the structure you designed and the data you are getting from the Data-set. First you should execute the Report and check About this Page of the Report (Execute twice as it starts first time). Identify here what exactly are the Data's you are getting and match this with your Report Outcome. Check is there some blank lines coming from Data-set Itself.
Once you will analyze this, you will easily understand the cause and what exactly to implement either the Row Visibility Condition or the Filters.
Thanks
Blog - https://rockwithnav.wordpress.com/Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0 -
Hi ,
My empty space is coming from Row Visibility, because I have some rows that have value 0 , and I don't want to show them.
Thanks,
Best Regards,0 -
Hey IvonaK ,
In that case you can simply select that row - Select the Row Visibility Option and write -
=IIF(Fields!XYZ.Value>0,False,True)
Thanks
Blog - https://rockwithnav.wordpress.com/
Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0 -
can I see the Report Dataset Designer please?Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
Hi to all,
I resolve the problem. The empty space was from this code that I put in Visible propertis (picture 3)
When I remove the code and put code like picture 4
it works
Thanks a lot,0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 324 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions

