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

Export Group Headers

11 Answers 83 Views
GridView
This is a migrated thread and some comments may be shown as answers.
troy
Top achievements
Rank 1
troy asked on 06 May 2010, 09:38 PM
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

11 Answers, 1 is accepted

Sort by
0
Veselin Vasilev
Telerik team
answered on 07 May 2010, 02:00 PM
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.
0
troy
Top achievements
Rank 1
answered on 07 May 2010, 09:19 PM
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
0
Vlad
Telerik team
answered on 13 May 2010, 07:51 AM
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.
0
troy
Top achievements
Rank 1
answered on 13 May 2010, 12:21 PM
The demo you indicated does not include the Group Headers or Footers.  It does include a Page Footer, but that's it.

Troy
0
Vlad
Telerik team
answered on 13 May 2010, 12:33 PM
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.
0
troy
Top achievements
Rank 1
answered on 13 May 2010, 12:51 PM

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

 

0
Vlad
Telerik team
answered on 13 May 2010, 01:24 PM
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.
0
troy
Top achievements
Rank 1
answered on 20 May 2010, 03:34 PM
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?
0
Vlad
Telerik team
answered on 20 May 2010, 03:42 PM
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.
0
troy
Top achievements
Rank 1
answered on 20 May 2010, 04:39 PM
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
0
Vlad
Telerik team
answered on 21 May 2010, 06:46 AM
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.
Tags
GridView
Asked by
troy
Top achievements
Rank 1
Answers by
Veselin Vasilev
Telerik team
troy
Top achievements
Rank 1
Vlad
Telerik team
Share this question
or