Need Help!!! Sorting In Report!

Becka
Member Posts: 178
Hi every1... I have a problem , I need to show info in report.. and i want to sort this as follows, at first i need all information with VAT and after this another information with zero VAT... if any ideas please help!
Thanks! From Sales Invoice Posted Table
Thanks! From Sales Invoice Posted Table
MCSD
Attain Navision
Attain Navision
0
Comments
-
Hi Becka,
Try like this...
take an Item with table 113 as Indented.Create a key in table 113 with No. and Line No... And link 113 with Item as 'No. = filed(No.).. then take a boolean variable represents Show Zero VAT in Options TAB. If is Not checkmark then filter the Item with Zero VAT..
IF NOT (Show Zero VAT) THEN
SETRANGE(Item."VAT Prod. Posting Group",'VAT 0');
I think you can reach like this...O:)
Regards
Teja0 -
But I wanna take this information from Sales Invoice Line table.. So if any different ideas just go ahead..
ThanksMCSD
Attain Navision0 -
But the same filed VAT Prod. Posting Group is there in table 113 now.. I think you can filter your Sale Invoice Line table according to that Global varable in options TAB..0
-
but i need both informstion in report at the same time.. but i dont know how to solve this problem..MCSD
Attain Navision0 -
Hi Becka,
If I understand your problem correctly then the solution is to create two dataitem for the posted sales line table. Set the DataItemTableView on the first to show only VAT and the second dataitem to show no VAT. This is assuming that you do not have a key for this and can't use GroupTotalFields
Hope this helps0
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
- 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
- 320 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