I AM DEVELOPING A COLUMNAR REPORT ON DAILY BASIS WHICH CONTAINS LEDGER NAME, AGENT CODE, ROUTE CODE,COMMENCEMENT DATE, OPENING COLLECTION AMOUNT,COLLECTION OF THE DAY. # ROUTE CODE ,AGENT CODE AND COMMENCEMENT DATE ARE THE NEW FIELDS ADDED IN MASTER LEDGER ### MY ISSUE IS WITH "OPENING COLLECTION AMOUNT" FIELD WHICH IS THE CREDIT TOTALS OF EACH LEDGER THAT WILL BE DISPLAYED IN THE RPORT. THIS IS CALCULATED FROM THE DATE OF COMMENCEMENT ON-WARDS TO END PERIOD DATE. THIS DATE WILL BE DIFFERENT FOR EACH LEDGER OR CUSTOMER. IN REPORT I HAVE USED "DSP TEMPLATE" AND "F2 PERIOD CHANGE" BUTTON IS ACTIVATED SO THAT THE REPORT STARTS AS PER THE PERIOD PROVIDE BUT THE "OPENING COLLECTION AMOUNT" FIELD SHOULD CALCULATE THE CREDIT TOTAL ONLY FROM THE COMMENCEMENT DATE WHAT EVER IS REPORT DATE. IS THIS POSSIBLE CAN ANY ONE HELP ME.......PLEASE
