• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

Crystal Reports Grouping

Hi,

I have a grouping that lists departments, for example, engineering, project  management, etc...

Is there a way that when I drill down on engineering, it goes to a certain group?  

eg. if group name = engineering, then drill down to group #3.  
if group name = project management, then drill down to group #4.

Thanks,
Joel
0
Genius123
Asked:
Genius123
  • 6
  • 3
  • 3
2 Solutions
 
mlmccCommented:
What do you mean group#3

DO you have several grouping levels or are you trying to open the third engineering group?

mlmcc
0
 
Genius123Author Commented:
I have several grouping levels.

So when I drill down on Engineering, I would want to see engineers and data that pertains to them.
Then if I drill down on project management, I would want to see PM's and data that is specific to them.

I could be going about this the wrong way with groups, but hopefully you understand what I'm trying to do.

0
 
GJParkerCommented:
Crystal drill down works by showing the records that are in teh grouop that you drilldown into so thsi will all depend on how your report grouping is setup

If your departments group is in group 1 then you can drill down into this group and see all of the data for each department i.e

G1 : Engineers
   G2 : 03/10/2011
      Data
      Data
   G2 : 04/10/2011
      Data
      Data

BUT if your departments group is not in group 1 then you if you drill down into the departments group you will only see the data relative to that department in group 1 i.e.


G1 : 03/10/2011
  G2 : Engineers  (drill down here will only show engineers data for 03/10/2011)
       Data
       Data

G1 : 04/10/2011
  G2 Engineers  (drill down here will only show engineers data for 04/10/2011)
      Data
      Data

Hope thsi makes sense and clarifies how CR works
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Genius123Author Commented:
Based on your example, this is how I want to drill down.  Not sure if it's possible, but thought I'd ask.

G1 : 03/10/2011 & 4/10/2011 all summed up
  G2 : Engineers  (drill down here will show data for both months)
       Data
       Data

0
 
mlmccCommented:
So Group 1 is a date field and  Group2 is the department?

Your report will show

G1:  03/10/2011
   G2:  Departments - You can drill into ENgineering to see just Engineering through the group tree
       Details - Data for 03/10/2011

G1: 04/10/11
   G2:  Departments - You can drill into ENgineering to see just Engineering through the group tree
       Details - Data for 04/10/2011

mlmcc

0
 
GJParkerCommented:
If you want to be able drill into and see all records for the departments then you will need to swap the groups around and have department as group 1
0
 
Genius123Author Commented:
I don't think either will work.  Let me explain another way.  

Look at my report I uploaded.  On page 2, you will see it grouped by month.  Then on page 3, I have all the departments for those two months.  I did this via supreport.  Basically, I'm just seeing if it can be done with grouping vs. a subreport.  Looking for a cleaner way to do it.  Perhaps I am going about it the right way?

Thanks. experts-10-6-11.rpt
0
 
mlmccCommented:
When you set up a group the only records are the records that match the group.  In your case when you group by a month you only have the data for that month.

If you need 2 months of data then you need a group that provides all the data

mlmcc
0
 
Genius123Author Commented:
Thanks.  I'll accept that it can't be done as the solution.  Subreports are the way to go for my example.  I appreciate your help.
0
 
Genius123Author Commented:
Thanks.  I'll accept that it can't be done as the solution.  Subreports are the way to go for my example.  I appreciate your help.
0
 
GJParkerCommented:
????? - Hadn't I already said it wouldn't work if you grouped it that way ???
0
 
Genius123Author Commented:
Thanks.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 6
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now