Print Page | Close Window

Manipulating the structure of a group tree

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3341
Printed Date: 18 Apr 2024 at 4:09am


Topic: Manipulating the structure of a group tree
Posted By: mozersky
Subject: Manipulating the structure of a group tree
Date Posted: 04 Jun 2008 at 2:21pm
Hi,

I am using Crystal Reports XI (Release 2) in C#.Net for a Web page, which upon request, gets dynamic data from MSSQL Server 2000, applies the .rpt template and then exports the report to a PDF file.

Let's say that the following is the data i'm using:

Col1    Col2
value1   abc
value1   abc
value1   def
value1   def
value2   abc
value2   abc
value2   def
value2   def

It would be desireable for me to produce the following bookmark tree structure:

value1
 def
value2
 def

So, my goal is to exclude the first node of the sub-group ("abc"). I know that if I group the report by Column1 then Column2, and then use the new "Create Bookmarks From Group Tree" feature, the following bookmark tree structure would be generated:

value1
 abc
 def
value2
 abc
 def

I'm thinking if it is possible to maybe manipulate some "GroupTree" object(does it exist?) during run time or to create a formula in the .rpt template to remove the first sub-group node.

Thanks in advance for your input.




Replies:
Posted By: BrianBischof
Date Posted: 04 Jun 2008 at 8:06pm
Unfortunately, you can't access the group tree object (it's a nice idea though). It always mimics the exact grouping structure found in the report.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>



Print Page | Close Window