Drill down and skipping groups 1

[aks12]

Hi, I am using Crystal Reports 10 with Oracle.

I have a drill down report with groups set up like this:

group 1: quarterly stats for products
group 2: quarterly stats for subproducts
group 3: monthly stats for subproducts

There are two products, A and B. Product B has two subproducts; A has none. I don't want the user to see quarterly and monthly stats on the same page, so I let them drill down.

My report works great when drilling down on product B. Not so good with product A. Since A has no subproducts, I would like the first drill down on Product A to go straight to monthly stats for the product and bypass group 2 completely. Is there a way I can force the report to skip a drill down into group 2 for Product A and go to group 3 while Product B retains the ability to drill down into both?

 

[lbass]

You could try creating formulas like these:

//{@group2}:
if isnull({table.subproduct}) then
datepart("m",{table.date}) else
datepart ("q",{table.date})

//{@group3}:
if isnull({table.subproduct}) then 0 else
datepart("m",{table.date})

Insert groups on these instead of your current group #2 and group #3.

-LB