Codejock Developer Community : Subtotal in Xtreme Report?

Subtotal in Xtreme Report? : Hi Warren,Of course it depends...

Mon, 20 Feb 2006 11:55:51 +0000

Author: sserge
Subject: 3568
Posted: 20 February 2006 at 11:55am

Hi Warren,

Of course it depends on your needs, but if you need subtotals to be always properly calculated, it would be a best solution... For example, after drag-n-drop to/from group area it would be the only way to have group row captions automatically updated.

--
WBR,
Serge

Subtotal in Xtreme Report? : Serge, I understand the posted...

Mon, 20 Feb 2006 09:48:41 +0000

Author: Warren
Subject: 3568
Posted: 20 February 2006 at 9:48am

Serge,

I understand the posted code, but where do you suggest is the most appropriate place to add this an application?

Should I derive from the report control, and add it to the end of an overrriden virtual void Populate()

Subtotal in Xtreme Report? : Hi, With the standard sample...

Sat, 28 Jan 2006 11:35:42 +0000

Author: sserge
Subject: 3568
Posted: 28 January 2006 at 11:35am

Hi,

With the standard sample application, you can calculate and show subtotals for (for example) Price column with the following piece of code. Please note that you should add Price column onto "Group By" field to enable grouping.


int nCount = GetReportCtrl().GetRows()->GetCount();

for (int i = nCount - 1; i >= 0; i--)

{

     CXTPReportRow* pRow = GetReportCtrl().GetRows()->GetAt(i);

     if (pRow->IsGroupRow())

     {

            // calculate subtotals

            double dSubtotal = 0;

            CXTPReportRows* pChildren = pRow->GetChilds();

            for (int j = pChildren->GetCount() - 1; j >= 0; j--)

            {

                 CXTPReportRow*  pChild = pChildren->GetAt(j);

                 CMessageRecordItemPrice*  pItem = DYNAMIC_DOWNCAST(CMessageRecordItemPrice, pChild->GetRecord()->GetItem(COLUMN_PRICE));

                 dSubtotal  += pItem->GetValue();

            }

            

            // set caption

            CXTPReportGroupRow* pGroupRow = (CXTPReportGroupRow*)pRow;

            CString strSubtotal;

            strSubtotal.Format(_T("(Subtotal:  %f)"), dSubtotal);

            pGroupRow->SetCaption(pGroupRow->GetCaption()  + strSubtotal);

     }

}

--
WBR,
Serge

Subtotal in Xtreme Report? : Hi How can make subtotals with...

Fri, 27 Jan 2006 09:08:36 +0000

Author: exycomm
Subject: 3568
Posted: 27 January 2006 at 9:08am

How can make subtotals with this control?

thanks!