Sir, I am trying to get report for Total Sales Order Amount and Total Sale Bill Amount of Party's with Grand Total of Ledger Group in single Window. But Sale order amount not showing in my report and also Grand total is showing wrong. Kindly guide me. [#Menu: Display Menu] Item: SaleOrders and SaleBills of LedgerGroup : Display Collection: SaleOrders and SaleBills of LedgerGroup [Collection : SaleOrders and SaleBills of LedgerGroup] Use : ExtractAlias Collection Source Collection : List of Groups Title : $$LocaleString:"List of Groups" Set as : $FirstName Fetch : Name Collection : Primary Variable : Group Name Report : SaleOrders and SaleBills of LedgerGroup Trigger : Group Name Report [Report : SaleOrders and SaleBills of LedgerGroup] Use : DSP Template Variable: SVFromDate, SVToDate Set : SVFromDate: $$MachineDate Set : SVToDate : $$MachineDate Form : SaleOrders and SaleBills of LedgerGroup Variables : SVFromDate, SVToDate, SVPrintOrientation Set : SVFromDate: @@DateofLastRegEntry Set : SVToDate : @@DateofLastRegEntry Title : "SaleOrders and SaleBills of LedgerGroup" [Form : SaleOrders and SaleBills of LedgerGroup] Use : DSP Template Space Bottom : 0.4 Space Top : 0.5 Space Left : 0.5 Space Right : 0.5 Full Height : Yes Full Width : Yes Full Object : Yes Part : Orders and Bills of LedGroup Set Always : SVPrintOrientation: $$SysName:Landscape [Part : Orders and Bills of LedGroup] Line : Orders and Bills of LedGroup Title, Orders and Bills of LedGroup, Orders and Bills of LedGroup Total Line Repeat : Orders and Bills of LedGroup: Ledger Names Under LedGroup Scroll : Vertical Total : Sale Order Value, Sale Value [Line : Orders and Bills of LedGroup Title] Use : Orders and Bills of LedGroup Border : Column Titles Local : Field : Default : Lines : 3 Local : Field : Default : Style : Tiny Bold Local : Field : OrdBil LedGroup : Info : "LedgerGroup" Local : Field : OrdBil Party : Info : "Party Name" Local : Field : Sale Order Value : Info : "Total Sale Order Amount" Local : Field : Sale Value : Info : "Total Sale Amount" Remove if: no [Line : Orders and Bills of LedGroup] Remove if : $$IsEmpty:#SaleOrderValue and $$IsEmpty:#SaleValue Space Bottom : 0.2 Space Top : 0.2 Border : Full Thin Bottom Field : OrdBil LedGroup, OrdBil Party, Sale Order Value, Sale Value [Field : OrdBil LedGroup] Set as : $Parent Width : 22 Style : tiny Lines : 0 [Field : OrdBil Party] Set as : $Name Width : 25 Style : tiny Border : thin right Lines : 0 [Field : Sale Order Value] Use : Vch Total Value Set as : $$FilterAmtTotal:LedgerTable:SaleOrderVch:$Amount [Field : Sale Value] Use : Vch Total Value Set as : $$FilterAmtTotal:LedgerTable:SaleVch:$Amount [Line : Orders and Bills of LedGroup Total Line] Border : column titles Field : OrdBil LedGroup, OrdBil Party, Sale Order Value, Sale Value Local : Field : dEFAULT : Style : Tiny Bold Local : Field : OrdBil LedGroup : Info : "" Local : Field : OrdBil Party : Info : "G R A N D T O T A L" Local : Field : Sale Order Value : Set as : $$Total:SaleOrderValue Local : Field : Sale Value : Set as : $$Total:SaleValue [Field : Vch Total Value] Type : Amount Width : 17 Format : "No Zero, DrCr" Align : Right Style : tiny Border : thin right [Collection : Ledger Names Under LedGroup] Type : Ledger Child Of: ##GroupName Belongs To: Yes Sort : @@Default : $Parent [Collection : LedgerTable] Type : Vouchers : Ledger Child Of: $Name Belongs To: Yes Compute : Name : $Name Compute : Amount: $Amount [System : Formula] SaleOrderVch: $$IsSalesOrder:$VoucherTypeName SaleVch : $$IsSales:$VoucherTypeName
