A report that gives list of Number of records in each table for each company

Aditya546

I'm using nav 2016. But i'm getting the run time error: ' you do not have the following permissions on the TableData service password:Read'


i wrote this code in the report. contributed by #TallyHo.

Object - OnAfterGetRecord()

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

TallyHo

Try this
TheRecRef.OPEN(Object.ID);
if TheRecRef.READPERMISSION then
NumberOfRecords:= TheRecRef.COUNT
else
clear(NumberOfRecords);
TheRecRef.CLOSE;

Aditya546

Table connection for table type CRM must be registered using RegisterTableConnection or cmdlet New-NavTableConnection before it can be used

kriki

[Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]