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

Aditya546 · 2019-04-11

I'm using nav 2016

TallyHo · 2019-04-11

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 · 2019-04-11

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 · 2019-04-11

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 · 2019-04-11

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 · 2019-04-11

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

Aditya546 · 2019-04-12

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'

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

Best Answers

Answers

Categories