How to disable drill-down

[Former Member]

Hi everybody,

I have already looked around for this issue but didn't found any acceptable (read: clean) solution.

I have a report with only 1 group(and, obviously, the details section).

I would like to disable the drill-down as I would like the user to see only the group header, and not the details section.

What I tried so far:

1.go to section expert and suppress the details. Didn't work. I can still drill down and see the details. This is strange, why I can still access details if they are suppressed?

2.go to section expert and insert a formula in "suppress detail". The formula is "drilldowngrouplevel > 0". Same as before. No effects.

The only solution I found is to "wrap" my fields in text labels, and then insert the text labels in my group header. This way no mangnifier will appear and the drill is disabled. But this solution doesn't work for me as I need some special formatting rules in my fields and I lost this rules if I wrap my fields in text label. In detail I need my numerical fields formatted in some particular way, and when I wrap my fields in text labels I lost the possibility to format numbers.

Any clean/elegant idea?

Thank you.

[Former Member · Accepted solution]

Try to format the objects first on the report and then insert the text object and select the object that you want to place inside the text object and click on ctrl+v to cut and paste inside the text box.

regards,

Raghavendra.G

[Former Member · Accepted solution]

This worked. Thank you.

[Former Member · Accepted solution]

I up this topic because I realized that when I export my report on InfoView the "text-label-above-group-header" solution doesn't work as I still have my groups drillable.

It looks like the drill wins against the text-label. Probably there's some problem when the HTML is created from the report.

So, unfortunately, problem's still here: any idea to disable drill-down?

[JWiseman · Accepted solution]

disabling drill-down can be an annoyance.

if putting group headers and summaries in text objects does not work there is one more thing you may wish to try.

1) Insert a new Text Object and place this new text object on top of the existing one containing the group header

2) in the new text object, put a bunch of spaces in so that it will have some length when exported to html

3) repeat the above for any group summaries or formulae in the group headers or footers

cheers,

jamie

[Former Member · Accepted solution]

>

> disabling drill-down can be an annoyance.
> 

I see, but I really cannot understand why It is so difficult...It should be a regular behaviour of the application.

What about the "suppress details(drill-down disabled)" option in the section expert? Why doesn't it work?

Do you have any idea?

> if putting group headers and summaries in text objects does not work there is one more thing you may wish to try.
> 
> 1) Insert a new Text Object and place this new text object on top of the existing one containing the group header
> 2) in the new text object, put a bunch of spaces in so that it will have some length when exported to html
> 3) repeat the above for any group summaries or formulae in the group headers or footers
> 
> cheers,
> jamie

This seems to work fine, the only problem is that I have several fields on the header and it's such a work!

[JWiseman · Accepted solution]

we are in complete agreement...it's a lot of work and it would be great that this behaviour could be eliminated with a Section Expert property plus an object Format property to disable drill-down. same with disabling drill on subreports.

last week i actually put this same thing in the Feature Request forum which is [here|;.

i would encourage anyone out there to do the same for any feature / behaviour that they would like to see added.