Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Group hierarchy level Post Reply Post New Topic
Author Message
vadim
Newbie
Newbie


Joined: 07 Mar 2011
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote vadim Replybullet Topic: Group hierarchy level
    Posted: 07 Mar 2011 at 4:24am
I have some problem with "group name fields"
 
At the moment I can do only this structure grouping:
 
Year
     Object Type 
          Object Name
 
i.e. each group included into another, therefore I can do only grouping
Year -> Object Type -> Object Name
 
but I need last 2 groups independent one from other, i.e. same level:
 
Main group
     Object Type
     Object Name
 
for making 2 types grouping:
 
Year -> Object Type
Year -> Object Name
 
at the moment I need to include sub-report with necessary group. But it's not normal.
 
please, any offers?Cry


Edited by vadim - 07 Mar 2011 at 5:15am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 08 Mar 2011 at 3:33am
Since all reporting tools display groups as a/b/c, not a/b a/c the subreport is one way to go, and rather logical. 
 
I was going to say to create a formula that would display both b/c, but it won't work, as what CR really needs is 2x the data for what you want to happen...it only reads a data row once, but you are looking to have it read twice (the subreport accomplishes this for you)
 
If you are using a stored proc, you could create a column in the return set for the grouping value and then fill it in using selects (you would have 2x the amount of data as the original dataset, which may or may not work the aggregate functions in the report)
 
Depending on how the report is formatted, it might be easier to stay with the subreport.  While I try not to use them, as they result in slower reports and more hits the database (unless you pushing the data to the report), they do have their place.
 
HTH
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.