Export Group Headers

[troy]

Is there any way to export the group headers on a RadGridView when doing a Export?  I know you can display the group footer in the export, although this seems limited to a single group footer for the entire grid.  The grouping on the grid is wonderful and the ability to define your custom Aggregate functions is brilliant, but having that wonderful display and not being able to get it into a electronic format is very limiting.

Thanks for any info.

Troy

[Veselin Vasilev]

Hi troy,

Please check this blog post:
New Feature: Export styling and formatting in RadGridView for Silverlight/WFP

Greetings,
Veskoni
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[troy]

thanks for the quick reply... that is exactly what I'm looking for but I can't seem to get it to work.  Do you have a sample project?  Also, I noticed in the link that you indicated it would be extended for use in Excel in the Q1 2010 build and was wondering if it has been completed as Excel is my preferred target.

Troy

[Vlad]

Hi Troy,

The most recent version of this demo can be found here: http://demos.telerik.com/silverlight/#GridView/Exporting

All the best,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[troy]

The demo you indicated does not include the Group Headers or Footers.  It does include a Page Footer, but that's it.

Troy

[Vlad]

Hi Troy,

Actually the demo includes all of these - you can try to group and export. Furthermore you can check the code in Exporting event.

Regards,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[troy]

Maybe I'm doing something wrong... if I drag the Name column to the group bar, it looks exactly like what I would want but when I export to any format ( below is from Word) this is what I get.

	ID	Name	Unit Price	Date
	10	Boston Crab Meat	$32.00	01/02/2009
	17	Boston Crab Meat	$18.40	01/19/2008
	19	Boston Crab Meat	$3.00	02/22/2008
	23	Boston Crab Meat	$19.00	02/22/2008
	28	Boston Crab Meat	$32.00	08/26/2008
	30	Boston Crab Meat	$9.00	04/13/2007
	33	Boston Crab Meat	$32.00	07/31/2008
	71	Boston Crab Meat	$19.00	05/10/2007
	78	Boston Crab Meat	$3.00	01/19/2008
	81	Boston Crab Meat	$9.00	01/02/2009
	4	Chocolade	$14.00	09/13/2008
	8	Chocolade	$19.00	08/26/2008
	11	Chocolade	$45.60	02/22/2008
	12	Chocolade	$45.60	02/22/2008
	24	Chocolade	$3.00	08/26/2008
	29	Chocolade	$14.00	04/13/2007
	37	Chocolade	$18.40	05/10/2007
	40	Chocolade	$45.60	05/10/2007
	52	Chocolade	$45.60	08/26/2008
	54	Chocolade	$18.40	05/10/2007
	56	Chocolade	$9.00	01/19/2008
	61	Chocolade	$18.40	05/10/2007
	65	Chocolade	$19.00	01/02/2009
	96	Chocolade	$23.25	05/12/2008
	5	Côte de Blaye	$19.00	04/13/2007
	20	Côte de Blaye	$23.25	04/13/2007
	32	Côte de Blaye	$14.00	07/31/2008
	35	Côte de Blaye	$18.40	01/19/2008
	43	Côte de Blaye	$3.00	07/31/2008
	70	Côte de Blaye	$9.00	05/10/2007
	95	Côte de Blaye	$19.00	04/13/2007
	7	Gula Malacca	$45.60	09/13/2008
	45	Gula Malacca	$18.40	04/13/2007
	46	Gula Malacca	$19.00	01/19/2008
	64	Gula Malacca	$32.00	07/31/2008
	76	Gula Malacca	$18.40	01/02/2009
	80	Gula Malacca	$3.00	08/26/2008
	82	Gula Malacca	$3.00	05/10/2007
	88	Gula Malacca	$18.40	08/26/2008
	90	Gula Malacca	$45.60	05/12/2008
	14	Maxilaku	$14.00	08/26/2008
	18	Maxilaku	$45.60	01/02/2009
	21	Maxilaku	$263.50	08/26/2008
	27	Maxilaku	$32.00	08/26/2008
	36	Maxilaku	$14.00	05/10/2007
	51	Maxilaku	$19.00	02/22/2008
	55	Maxilaku	$14.00	07/31/2008
	58	Maxilaku	$23.25	09/13/2008
	67	Maxilaku	$18.40	01/02/2009
	69	Maxilaku	$14.00	09/13/2008
	77	Maxilaku	$19.00	02/22/2008
	97	Maxilaku	$18.40	01/19/2008
	22	Rogede sild	$18.40	04/13/2007
	25	Rogede sild	$45.60	01/02/2009
	38	Rogede sild	$263.50	01/19/2008
	41	Rogede sild	$19.00	08/26/2008
	42	Rogede sild	$3.00	08/26/2008
	44	Rogede sild	$14.00	01/02/2009
	62	Rogede sild	$263.50	07/31/2008
	75	Rogede sild	$19.00	01/19/2008
	79	Rogede sild	$18.40	04/13/2007
	84	Rogede sild	$32.00	09/13/2008
	92	Rogede sild	$45.60	09/13/2008
	94	Rogede sild	$263.50	09/13/2008
	99	Rogede sild	$32.00	04/13/2007
	100	Rogede sild	$19.00	02/22/2008
	1	Singaporean Hokkien Fried Mee	$9.00	05/12/2008
	13	Singaporean Hokkien Fried Mee	$45.60	09/13/2008
	31	Singaporean Hokkien Fried Mee	$14.00	05/12/2008
	57	Singaporean Hokkien Fried Mee	$9.00	05/12/2008
	60	Singaporean Hokkien Fried Mee	$23.25	05/12/2008
	63	Singaporean Hokkien Fried Mee	$19.00	01/02/2009
	85	Singaporean Hokkien Fried Mee	$23.25	01/02/2009
	3	Spegesild	$23.25	02/22/2008
	15	Spegesild	$45.60	05/12/2008
	26	Spegesild	$14.00	05/12/2008
	48	Spegesild	$32.00	01/19/2008
	50	Spegesild	$32.00	02/22/2008
	53	Spegesild	$23.25	08/26/2008
	59	Spegesild	$263.50	02/22/2008
	66	Spegesild	$14.00	02/22/2008
	68	Spegesild	$45.60	05/12/2008
	83	Spegesild	$18.40	01/02/2009
	91	Spegesild	$45.60	02/22/2008
	93	Spegesild	$45.60	01/19/2008
	2	Zaanse koeken	$18.40	05/10/2007
	6	Zaanse koeken	$45.60	05/12/2008
	9	Zaanse koeken	$23.25	05/12/2008
	16	Zaanse koeken	$3.00	01/19/2008
	34	Zaanse koeken	$32.00	04/13/2007
	39	Zaanse koeken	$23.25	08/26/2008
	47	Zaanse koeken	$19.00	09/13/2008
	49	Zaanse koeken	$45.60	04/13/2007
	72	Zaanse koeken	$3.00	05/12/2008
	73	Zaanse koeken	$32.00	08/26/2008
	74	Zaanse koeken	$3.00	08/26/2008
	86	Zaanse koeken	$263.50	05/10/2007
	87	Zaanse koeken	$9.00	09/13/2008
	89	Zaanse koeken	$263.50	05/12/2008
	98	Zaanse koeken	$3.00	08/26/2008
	Count: 100	Min: $3.00	Sum: $3,908.95,Average: $39.09	Min: 04/13/2007,Max: 01/02/2009

 

[Vlad]

Hi Troy,

Unfortunately you are right! The bug was fixed immediately and the fix will be part of our upcoming latest build this Friday. I've added 2000 Telerik points to your account. You can find an example project attached using our latest binaries.

All the best,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[troy]

I have tested your attached test project as well as the update binaries and the group header rows are now showing as expected.  I am curious as to why the aggregate functions that also appear in the group header row do now show up in the exported group header row.  Is this a bug or just missing functionality?

[Vlad]

Hi,

The grid will not export group headers and footers by default however you can use Exporting event to achieve desired result similar to our exporting demo.

Regards,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[troy]

It seems as if the group headers are exported automatically, but the group footers are an option in the export format. 
If you run your demo and group by date, the group header shows the data from the grouped column (ie 04/13/2007), but your demo also includes aggregate functions that are also displayed in the header row.  This is what I'm wanting to export.

Thanks!

Troy

[Vlad]

Hi Troy,

Actually there is a missing word in my last reply - sorry for this! Here is the correct answer:

The grid will not export group headers and footers aggregates by default however you can use Exporting event to achieve desired result similar to our exporting demo.

Sincerely yours,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.