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
Account Schedule Report - Filters not visible
Ravi_Prakash_Goyal
Member Posts: 72
I am running Account Schedule report (Report ID 25) in NAV7. Everthing is fine except I cannot see the filters applied on Account Schedule Line. Which I can cleary see older versions of Navision. I checked this and found that in RDLC layout the hidden property is set to "=IIF(code.GetData(6,2)="",TRUE,FALSE)" for AccScheduleLineTABLECAPTION_AccSchedLineFilter text control. There is also a Setdata function defined, which was supposed to be called from some hidden control but I could not find any such control. Is this a standard bug or am I missing something? When I set hidden property to FALSE, it shows Acc. Schedule Line filters. Please advice.
Thanks
Ravi Prakash Goyal
Thanks
Ravi Prakash Goyal
0
Comments
So all values in Code.SetData fields in the header have been moved to the Visibilty Expression. So you need dig a little to find the expressions.
Rendering of the Report has changed from Report Viewer 2008 to Report Viewer 2010. In Report Viewer 2008 hidden fields with expression are evaluated as the first thing when placed in top of the header. In Report Viewer 2010 hidden fields with expressions are not evaluated or evaluated completely of sync with the body. So we need to trick it to evaluate first so we move it to the Visibility expression, which is evaluated just like in Report Viewer 2008.
Look at report 2006 and the empty textboxes in top of the header. The are not really empty, the expression have just been moved to the visibility expression.
/Claus
I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
I was able to find empty textbox in report 206 with expression in hidden property, but still I could not find such textbox in report 25. I tried moving each and every control available on the report with no success. Is it possible that some of the reports are not completed or tested by microsoft? Can you please check specifically report 25 and let me know if you find the hidden control. Changing the standard object is always last thing in my list unless and until I have to. Please advice. Thanks.