Counting lines in a table

MasterOfDragons
Member Posts: 18
Hi,
I'm writing a report and have to determine the number of lines in a table before doing anything else. How could I do this?
Thanks inadvance
Master of Dragons
I'm writing a report and have to determine the number of lines in a table before doing anything else. How could I do this?
Thanks inadvance
Master of Dragons
0
Answers
-
-
Thanks for the fast answer; but could you please be a bit more specific, as I'm quite new to Navision and C/AL? :?
Master of Dragons
EDIT: Never mind, I think I've found what I need. Thanks.0 -
CountOfLines := Rec.Count;
CountOfLines is the Integer variable which will be used to store the no. of lines in the table.
Rec is variable of type Record for your table with applied all filters you need.
Rec.Count is function, which will count the records which are accessible with given filters.
Never mind: I read that you found the answer after I answered... :-)0
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