Force DrillDownGroupLevel = x based on condition

Hi everyone,

I have 3 grouping levels in a report, including 'No Grouping' as an option.  If they select "No Grouping" it groups on the same parameter as above which means they have to select the same data again to get down to the detail level - I'd prefer to just automate this step straight down to the detail.

Is it possible that on a condition like:
IF {?Group3Parameter} = "No Grouping" and DrillDownGroupLevel = 2 then
   DrillDownGroupLevel  = 3

and where would I put it?

Thanks
Chris
loopyadcAsked:
Who is Participating?
 
GJParkerCommented:
You can't automate drill downs at all in CR.

The only option I can see is to create 2 identical subreports 1 with drill down and one without. place these in seperate report headers and suppress  the relevant report using a conditional suppression formula  based on a parameter.

HTH

Gary
0
 
GJParkerCommented:
I must admit I'm not fully clear on your report layout here but unfortunately you don't have any control of the drill down functionalty.

CR doesn't allow you to use conditional formulas for drill down the same as suppression.

Gary
0
 
mlmccCommented:
Agree with Gary.  As far as I know a drill down report is first presented with the all drill downs closed up and only when a drill down is selected is it opened.

Are you trying to do this from Crystal or an application?

mlmcc
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
loopyadcAuthor Commented:
From Crystal.

Would it be possible to 'automate' the selection of a record in the groupdown with a condition?

Thanks for the help though!
Chris
0
 
mlmccCommented:
Don't know how.

mlmcc
0
 
loopyadcAuthor Commented:
Thanks for the help - that would be quite a cool feature though!
0
 
GJParkerCommented:
Can't disagree with you there loopyadc

Glad I could help

Gary
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.