select * from FAVOURITEREPORT
ROW:DISTRIBUTOR,DEALERCODE,SalesDivision,PARTY,AREA,LicenceNo,CUSTOMERID,SALESMAN,DPARTY,CUSTOMERCLASS,CUSTOMERCODE,ZONE,Telephone,
ITEM,ITEMALIAS,ITEMCLASS,BRAND,DATE,VOUCHER,MNTHYR,PTS 
COL:SALESVALUE WHERE:WHERE VoucherDate>={fryr} and VoucherDate<={toyr} ORDER:0 HAVING:<>0 DATA:SALE INVTP:0 TOPCLAUSE: SUBTOTAL: ORDERBY:DISTRIBUTOR VALUEQTY:0 SALESMAN: TRANSFER:3 ACTIVE:3 ADDDETAILS:False INCLUDEVALIDATION:False INCLUDEPROMOTION:False SALEDATAFOR:1 DATABASE:0

DISTRIBUTOR,DEALERCODE,SalesDivision,PARTY,AREA,LicenceNo,CUSTOMERID,SALESMAN,DPARTY,CUSTOMERCLASS,CUSTOMERCODE,ZONE,Telephone,
ITEM,ITEMALIAS,ITEMCLASS,BRAND,DATE,VOUCHER,MNTHYR,PTS


select * from reportcontrolmaster where controlname ='DISTSALESMAN'
select * from reportcontrolmaster where controlname ='dparty'


select * from reportcontrolmaster where controlname like '%retail%'
select * from reportcontrolmaster where parameter = 'salesman'