This is a migrated thread and some comments may be shown as answers.

[Solved] Grid Grouping - Group Header

2 Answers 124 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Saurabh asked on 24 Jul 2009, 09:03 AM

Hi,

I am facing two issues with the Grouping feature in the grid. My dataset looks like this:

Vehicle Type	Vehicle No.	US Journeys	UK Journeys	% US Journey	US Cargo	UK Cargo	% US Cargo
A	111	5	5	50	4	6	40
A	222	2	6	25	5	5	50
B	333	3	6	33.33	6	6	50
B	444	9	2	81.82	5	9	35.71

Now, I need to group by Vehicle Type (which has been done) and find out -
a. Total US Journeys - Done
b. Total UK Jouneys - Done
c. % Total US Journeys - ??
d. Total US Cargo - Done
b. Total UK Cargo - Done
c. % Total US Cargo - ??

Issue 1: How do I get the Percentage Columns? Do I predefine them (as in specify a separate column in "SelectField" collection as assign the values in the ItemDataBound event)? If yes, what should I mention in the fieldname, fieldalias sections of this particular column?

Issue 2: In the Group header, before the "Calculated Values" I also get the FieldName/FieldAlias (Total US Journeys:25). Is there a way to turn off the column name text? I know I can manipulate the DataCell.Text which I dont want to as this would be not a good standard.

Thanks,
Saurabh

2 Answers, 1 is accepted

answered on 29 Jul 2009, 12:09 PM

groupingpercentages.zip

Hi Saurabh,

Please, take a look at the attached sample and the following help articles: Customizing the group header item & Performing calculations in group header item.

As for the support response time - your account status shows no purchases or subscriptions and our response time in this case is within 72 hours from the moment the ticket has been submitted.

I hope this information helps.

Kind regards,
Tsvetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.