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
rtc report weird behaviour
matthewtaing
Member Posts: 52
Hi Guys,
Just wondering if any of you have a solution to this. Found out that there's a weird behaviour with RTC reports when there's a dataitem with date as the primary key. For example the accounting period table. Tested with NAV 2013 and NAV 2013 R2 and the following are the steps and the findings :-
1. Create an empty report with just accounting period as the dataitem.
2. Run the report
3. Add Starting date as a filter and click on the lookup button and select a date. Refer to Report1.jpg
4. Click preview and the results are the following :-
NAV 2013 - the date selected will be entered as datetime and when you run/preview the report it will prompt a confirmation box that says that one of the filters are invalid and will be ignored.
NAV 2013 R2 - date selected will be entered as datetime and then it crashes the system entirely.
Any help would be greatly appreciated on how to fix this.
Thanks
Just wondering if any of you have a solution to this. Found out that there's a weird behaviour with RTC reports when there's a dataitem with date as the primary key. For example the accounting period table. Tested with NAV 2013 and NAV 2013 R2 and the following are the steps and the findings :-
1. Create an empty report with just accounting period as the dataitem.
2. Run the report
3. Add Starting date as a filter and click on the lookup button and select a date. Refer to Report1.jpg
4. Click preview and the results are the following :-
NAV 2013 - the date selected will be entered as datetime and when you run/preview the report it will prompt a confirmation box that says that one of the filters are invalid and will be ignored.
NAV 2013 R2 - date selected will be entered as datetime and then it crashes the system entirely.
Any help would be greatly appreciated on how to fix this.
Thanks
0
Comments
http://dynamicsuser.net/forums/p/72299/385109.aspx