Hi
I have implemented an TcxCustomDataSource and bound it to an PivotGrid.
At runtime I create columns and link summaryprocedure to the actual summaryfields.
Calculation work fine when the summary is based on actual data. (Retrived through MyCustomDataSource.GetValue override).
But I have an problem when I Try to calculate a summaryfield based on another summaryfield.
ASummary.Owner.GetSummaryByField(tmpField, stSum);
If tmpField is an summaryfield, this will return Null
I have also tried to loop through record in ASummary
function TRBPivotForm.CalcSumField(Sender: TcxPivotGridField;
ASummary: TcxPivotGridCrossCellSummary; Line: TLine): variant;
var
tmpField: TcxPivotGridField;
i:integer;
begin
Result:= 0;
for i := 0 to line.SumLinesIds.Count - 1 do
begin
tmpField:= FindField(line.SumLinesIds.Strings[i]);
if tmpField <> nil then
Result:= Result + ASummary.Owner.GetSummaryByField(tmpField, stSum);
end;
Thanks!
Bug Report
Q137659
Visible to All Users
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Hi Magne,
Thank you for the report. We are sorry for the delay in responding. We are working on this issue and will answer you shortly. Please bear with us.
Thanks,
Plato
Hi Magne,
Thank you for the question. Sorry, but it's difficult to determine the cause of your problem due to the lack of information. Could you please provide us with a sample project illustrating this problem?
Thanks,
Dimitros
I have attached an sample project.
I'm sorry for the kind of messy code.
The first field CompanyId, is an value stored in a memset.
The two other field are summaryfields.
Seems like the problem may be that when calculating the Sum2 field. It uses GetValue to get the value for the sum1 field.
But this field is not stored in the memset. But is calculated ( Sum1 field. CompanyId * 2)
Please contact me if I am unclear.
Thanks!
Hi Magne,
If I understand your task correctly, you want to see the following values:
CompanyId= 302
Sum1 = 604
Sum1 + CompanyId= 906
If so, you need to change the OnCustomCalculation procedure implementation as shown below:
procedure TRBPivotForm.OnCustomCalculation(Sender: TcxPivotGridField; ASummary: TcxPivotGridCrossCellSummary); .... tmpField:= FindField('Sum1'); ASummary.Custom:= ASummary.Owner.GetSummaryByField(tmpField, stCustom); ... end;I.e. you need to pass the stCustom parameter to the GetSummaryByField procedure, because you want to obtain the summary value which has been calculated manually.
Please let us know whether this solution makes sense.
Thanks,
Dimitros
This solution makes perfect sense.
And I was able to fix mye problem based on this information.
Thanks :)
You're welcome, Magne. Please feel free to contact us in case of any difficulty. We are happy to help you at any time.
Thanks,
Dimitros
Hi.
Now with the never releases of PivotGrid this does not work anymore
ASummary.Custom:= ASummary.Owner.GetSummaryByField(tmpField, stCustom);
I get the error "field must be in data area", but only when tmpField is a hidden field
Any workarounds?
thanks.
I'll explain a little better.
In the OnGetContentStyle event i check the values of other fields to determine which color schema I shuld use on that cell.
I have ACell: TcxPivotGridDataCellViewInfo and
Field: TcxPivotGridField;
I then call ACell.CrossCell.GetSummaryByField(Field, stCustom) to get the custom calculation value.
This work fine when field is a visible field. But when Field is hidden I get the "field must be in the data area" error
Any workarounds?
thanks
Hello Magne,
Thank you for your message.
I am afraid I cannot give you a precise answer about why this happens without examining a sample project. If it is possible, please try to create it and attach it to your next message. We will examine it and do our best to find a solution.
Best Regards,
Paulo
Hi.
I have reproduced the issue in the OnCustomCalculation event
Run the sample project. Right click on pivotSumField1(data area) and select hide.
Best regards
Hello Magne,
Thank you for your sample project. It seems to be a bug in PivotGrid. I have converted this issue to a bug report and forwarded it to our developers for further processing. You will receive an automatic message once the status of this issue is changed.
Best Regards,
Paulo