How to write A report that gives list of Number of records in each table for each company ??

Aditya546

I'm using nav 2016

TallyHo

Create a report based on the object table

DataItemTableView SORTING(Type,Company Name,ID) WHERE(Type=CONST(TableData))

Object - OnAfterGetRecord()
TheRecRef.OPEN(Object.ID);
NumberOfRecords:= TheRecRef.COUNT;
TheRecRef.CLOSE;

in layout define
Object.id
Object.name
NumberOfRecords

That should do it.

Per company is changecompany for Object table the way you're probably used to

ShaiHulud

An alternative solution to the one TallyHo presents is to use the system table 2000000028 - "Table Information". It has the following fields:

• Company Name (no need to flip through the companies manually)
• Table No.
• Table Name
• No. of Records
• Record Size
• Size (KB)

You can easily create a List Page to see what you'd get by using this table.

TallyHo

Create a report based on the object table

DataItemTableView SORTING(Type,Company Name,ID) WHERE(Type=CONST(TableData))

Object - OnAfterGetRecord()
TheRecRef.OPEN(Object.ID);
NumberOfRecords:= TheRecRef.COUNT;
TheRecRef.CLOSE;

in layout define
Object.id
Object.name
NumberOfRecords

That should do it.

Per company is changecompany for Object table the way you're probably used to

ShaiHulud

An alternative solution to the one TallyHo presents is to use the system table 2000000028 - "Table Information". It has the following fields:

• Company Name (no need to flip through the companies manually)
• Table No.
• Table Name
• No. of Records
• Record Size
• Size (KB)

You can easily create a List Page to see what you'd get by using this table.

TallyHo

@myself
Why do it the easy way when you can do it the hard way 😉.

Aditya546

Thank you #TallyHo for your answer .

I tried what you said, but i'm getting the error: 'You Do not have the following permissions on tabledata service password:Read'