Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Export Group Rows Summary to Excel
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Export Group Rows Summary to Excel

 Post Reply Post Reply
Author
Message
SHAN View Drop Down
Groupie
Groupie
Avatar

Joined: 17 July 2010
Location: Dubai
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote SHAN Quote  Post ReplyReply Direct Link To This Post Topic: Export Group Rows Summary to Excel
    Posted: 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
Back to Top
Hemesh View Drop Down
Senior Member
Senior Member


Joined: 10 August 2010
Status: Offline
Points: 135
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hemesh Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
SHAN View Drop Down
Groupie
Groupie
Avatar

Joined: 17 July 2010
Location: Dubai
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote SHAN Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Hemesh View Drop Down
Senior Member
Senior Member


Joined: 10 August 2010
Status: Offline
Points: 135
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hemesh Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.141 seconds.