Hi all
I've just encountered an issue when I use dbr.columnfilter along with dbr.sum in that the grand total row doesn't show the sum of the columns - just 0.
Removing dbr.columnfilter the grand totals are displayed as expected.
Any thoughts?
Cheers
Jake
select 'dbr.hdr','suppnum','supp','suppcur','doctype';
select 'dbr.hdr','ponum','docstat','podate','reqdate';
select 'dbr.colstyle','oqty','rqty','balqty','ltotal','balval','%0.0f;-;';
select 'dbr.colstyle','ocp','fxrate','gbpcp','%0.5f;-;';
select 'dbr.colstyle','suppnum','supp','suppcur','doctype','ponum','[font-weight:bold;]';
select 'dbr.css','td.summary_level1 {background-color:#e4e4e4;font-weight:bold;}';
select 'dbr.css','td.summary_level2 {font-weight:bold;}';
select 'dbr.css','tr.odd {background-color:white;}'
select 'dbr.sum','ltotal','balval';
select 'dbr.columnfilter','ltype';
select 'dbr.columnfilter.remember', 1;
select 'dbr.calc','ltotal','([oqty]*[gbpcp]*(100-[discper]))/100';
select 'dbr.calc','balval','(([oqty]-[rqty])*[gbpcp]*(100-[discper]))/100';
select c.[SupplierAccountNumber] as "Supp.Acc#[suppnum]" ,c.[SupplierAccountName] as "Supplier[supp]" ,e.[Code] as "Supp.Cur[suppcur]" ,iif(a.[DocumentTypeID]=0,'Order','Return') as "Doc.Type[doctype]" ,a.[DocumentNo] as "PO.Num[ponum]" ,f.[Name] as "Status[docstat]" ,cast(a.[DocumentDate] as date) as "PO.Date[podate]" ,cast(a.[RequestedDeliveryDate] as date) as "Req.Del[reqdate]" ,b.[PrintSequenceNumber] as "Line#[lnum]" ,g.[Name] as "Type[ltype]" ,b.[ItemCode] as "ItemCode[icode]" ,b.[ItemDescription] as "Item Description[idesc]" ,b.[UnitBuyingPrice] as "Cost Price[ocp]" ,a.[ExchangeRate] as "FX[fxrate]" ,b.[UnitBuyingPrice]/a.[ExchangeRate] as "CP, £[gbpcp]" ,b.[UnitDiscountPercent] as "Disc.%[discper]" ,b.[LineQuantity] as "Ord.Qty[oqty]" ,null as "Line Total[ltotal]" ,b.[ReceiptReturnQuantity] as "Rec.Qty[rqty]" ,b.[LineQuantity]-b.[ReceiptReturnQuantity] as "Balance[balqty]" ,null as "Bal, £[balval]" from [dbo].[POPOrderReturn] a join [dbo].[POPOrderReturnLine] b on a.[POPOrderReturnID]=b.[POPOrderReturnID] join [dbo].[PLSupplierAccount] c on a.[SupplierID]=c.[PLSupplierAccountID] join [dbo].[SYSCurrency] d on c.[SYSCurrencyID]=d.[SYSCurrencyID] join [dbo].[SYSCurrencyISOCode] e on d.[SYSCurrencyISOCodeID]=e.[SYSCurrencyISOCodeID] join [dbo].[DocumentStatus] f on a.[DocumentStatusID]=f.[DocumentStatusID] join [dbo].[OrderReturnLineType] g on b.[LineTypeID]=g.[OrderReturnLineTypeID] where a.[DocumentStatusID]=0 order by c.[SupplierAccountName],a.[DocumentDate],a.[DocumentNo],b.[PrintSequenceNumber]
