|
Export Group Rows Summary to Excel |
Post Reply 
|
| Author | |
SHAN 
Groupie 
Joined: 17 July 2010 Location: Dubai Status: Offline Points: 73 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Export Group Rows Summary to ExcelPosted: 01 September 2010 at 6:53am |
|
Hi,
Please help me How to export group summary rows to Excel?
I need only group row summary only not all Data...!
Thanks in Advance...!
|
|
|
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows 7 Professional Language: Visual Basic 6.0 |
|
 |
|
|
Hemesh
Senior Member 
Joined: 10 August 2010 Status: Offline Points: 135 |
Post Options
Thanks(0)
Quote Reply
Posted: 10 September 2010 at 4:36am |
|
Similar to my other answer for Expanding the first level nodes. The .Records will contain all "summary" rows only. The .Childs collection will have the rest of the rows under each Record.
|
|
|
Product: Xtreme SuitePro (ActiveX) version 18.5.0
Platform: Windows 7 Enterprise (64-bit) Language: Visual Basic 6.0 |
|
|
|
|
SHAN
Groupie
Joined: 17 July 2010 Location: Dubai Status: Offline Points: 73 |
Post Options
Thanks(0)
Quote Reply
Posted: 12 September 2010 at 5:35am |
|
Hi Hemesh ,
I am able to loop through summary rows...!
It simply loops through All Group Rows including Sub Groups...!
But how to find out wheter it is a group row or sub group row and tree Level ?
Any Idea?
|
|
|
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows 7 Professional Language: Visual Basic 6.0 |
|
|
|
|
Hemesh
Senior Member
Joined: 10 August 2010 Status: Offline Points: 135 |
Post Options
Thanks(0)
Quote Reply
Posted: 13 September 2010 at 3:24am |
|
The only way I can think of is to check the .Parent in a recursive function. If the .Parent is nothing, it's the Top Level, so for whatever level you are checking at have a counter that will check the .Parent level until it reaches 'Nothing'. When it reaches this, check the counter is >1 for a sub group, =1 for a group and =0 for the parent.
|
|
|
Product: Xtreme SuitePro (ActiveX) version 18.5.0
Platform: Windows 7 Enterprise (64-bit) Language: Visual Basic 6.0 |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options