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
Genius123Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
What do you mean group#3

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

mlmcc
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.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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

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

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
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
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
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.
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.
GJParkerCommented:
????? - Hadn't I already said it wouldn't work if you grouped it that way ???
Genius123Author Commented:
Thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.