Report Control - Export Group Rows Summary to Excel

Print Page | Close Window

Export Group Rows Summary to Excel

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=17182
Printed Date: 19 April 2024 at 4:17am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Export Group Rows Summary to Excel

Posted By: SHAN
Subject: Export Group Rows Summary to Excel
Date 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

Replies:

Posted By: Hemesh
Date 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

Posted By: SHAN
Date 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

Posted By: Hemesh
Date 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