I need to make a session where i check the sessions then take the main table in that session and count the no of records in that table has anyone made a report like this can you send me the script for this. Thanks

Here is the logic for you to build it:

1. Input - Session Code (cpc, cmod, cses).
2. Get Session's main table (mpac, mmod, mfln) using this function get.session.vrc() from the tools library ttdllextint

long get.session.vrc(domain ttadv.cpac cpac, domain ttadv.cmod cmod,
domain ttadv.cses cses, long including.tt, ref domain ttadv.vers vers,
ref domain ttadv.rele rele, ref domain ttadv.cust cust,
ref domain ttadv.cpac mpac, ref domain ttadv.cmod mmod,
ref domain ttadv.flno mfln, ref domain ttadv.kses kses,
ref domain ttadv.cmod cmop, ref domain ttadv.cprs cprs )

3. Use tools function, db.nr.rows() to get the number of records for that table in a particular company.