Formatting question drill downs 2

[marckssg]

Hi, its late and I am having a total mental block!

I am using Crystal XI reporting off a SQL 2000 database.

My question is around formatting drill downs.

My top level has the following columns;

"Region" "Number of Sales" "Number of Potential Sales"

2nd Group;

"Region" "City" "Number of Sales" "Number of Potential Sales"

3rd Group;

"Region" "City" "Salesman" "Number of Sales" "Number of Potential Sales"

Each set of summary figures at each group is formatted with a box around it and grey colouring along the page headers to fit in with the company standard.

What I'd like to see is the columns to almost nudge along if that makes sense as I drill down each level so each of the common columns lines up, but I don't line them up intially as I would have a large blank space on the top level between columns when the user first views the report.

I guess I could do it with ondemand subreports, but I thought I could do it with drill downs and not being able to has bugged me instead of being a life and death sort of problem!

Any advice/pointers most welcome!

Thanks


Cheers

Marc

 

[lbass]

You could handle this by having multiple page headers and multiple detail sections that use the drilldowngrouplevel function to conditionally suppress them, where drilldowngrouplevel = 0 refers to preview (no drilldown),
drilldowngrouplevel = 1 refers to first drilldown, etc. You would format each section to "suppress blank section."

-LB

 

[marckssg]

Hi lbass,

I've gone with the drilldowngrouplevel option and abandoned the formatting of the box, just kept it at one standard size throughout.

Thanks for the response.

Cheers

Marc

 

[CRCRCR]

Hi LB

drilldowngrouplevel

How on earth do you find these things?

Kai.

 

[lbass]

In the formula editor, explore the functions list and look up functions you are not familiar with in the Help section. Drilldowngrouplevel is under "Print State", and became available in v.9.0 I think (not sure).

-LB