We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

GridDataControl: Group Summary Row Format

Thread ID:

Created:

Updated:

Platform:

Replies:

103670 May 23,2012 09:16 AM May 24,2012 07:54 AM Silverlight 1
loading
Tags: GridControl
David Huppertz
Asked On May 23, 2012 09:16 AM

With a schema of Menu, Report, User, Views to track hits on web pages I am using the GridDataControl in hopes to group by Menu and Report with aggregations rolling up ViewCounts.

The problem is that I can't seem to figure out the magical combination of steps to change the group summary to be in this format

{Name} - SUM(ViewCount) so to speak.

the default is...

{ColumnName} - {Name} - Count(ViewCount)

I tried to add an aggregation using the {Name} placeholder but I get an error.

Bottom line is the expected result should look like the following...

- DOCUMENTATION (124 Views) <-- the menu group with sum
    + Help Document (100 Views) <-- the report group with sum
    + Another Help Document (24 Views)

NOT

- Menu - DOCUMENTATION (2 items) <-- the menu group with sum
    + Report - Help Document - (5 items) <-- the report group with sum
    + Report - Another Help Document (5 items)


Rajasekar [Syncfusion]
Replied On May 24, 2012 07:54 AM

Hi David,

 

Thank you for your update.

 

You can achieve this requirement by using the below code snippet,

 

                <syncfusion:GridDataControl.CaptionSummaryRow>

                    <syncfusion:GridDataSummaryRow Title="'{Key}  ({FreightSummary} Total Freight)'" TitleColumnCount="2">

                        <syncfusion:GridDataSummaryRow.SummaryColumns>

                            <syncfusion:GridDataSummaryColumn SummaryColumnName="FreightSummary" MappingName="Freight" SummaryType="DoubleAggregate" Format="'{Sum:##.00}'" >

                            </syncfusion:GridDataSummaryColumn>

                        </syncfusion:GridDataSummaryRow.SummaryColumns>

                    </syncfusion:GridDataSummaryRow>

                </syncfusion:GridDataControl.CaptionSummaryRow>

 

Please find the sample in the below location,

 

Sample: http://www.syncfusion.com/downloads/Support/DirectTrac/94705/BasicSummariesDemo-1580234156.zip

 

Please let us know if you have any queries.

 

Thanks,

Rajasekar


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;