Skip to Content
author's profile photo Former Member
Former Member

Disable Drill Down For Groups only except SubReport

 

Hi All,

I have 10 subreports and also 5 Groups sections in one report (version CR 10 - VS.Net 2005)

I need to disable drill down on Groups except SubReport .

 

Thanks in advance for any solution

 

-Harini

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2006 at 12:23 AM

    Drill-down functionality is linked to running totals, summaries and group title fields. If you use formulas and database fields directly, the drilldown functionality will probably not activate. (Use variables as well - This forces CR to push the formulas to a different evaluation time that).Â

    I hope that helps. This is just an idea.

    Â Â Â Â - Kathryn Webster (Report Design Consultant)
    Â Â Â Â Â Â Â Â Â Â Kat's News: http://diamond.businessobjects.com/blog/279


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Do you have more information on what will disable drilldown.

      Â I have two reports with bar charts.

      Â When I click on a bar on one of the reports, the magnifying glass appears and I can get to the underlying data.

      When I go over a bar on the other report, no magnifying glass appears and I am unable to drill down to the data.

      Any help would be appreciated. Thank you in advance for your kind and courteous attention.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2006 at 09:05 AM

    Where are the subreports located? You mention you have 10 subreports and also 5 group sections. Are the subreports located in the page or report header/footer sections? Are there detail records in the groups? If not, then you don't need to supress drill-down, there is nothing to drill to. If there is, suppress the detail section. If a user drills on the groups, there will be no detailed information visible.

    Typically, if you have multiple groups and want to supress drill-down but still display the first group, you can use the 'drilldowngrouplevel >1' statement in the section expert to conditionally suppress the group. Right click the group, select 'Section expert', and click the formula button (the button with the 'X-2' and a little pencil) next to 'Suppress (No Drill-Down) Then, enter drilldowngrouplevel >1. This should do the trick if you have your report structured this way. If not, please provide a little more detail.

    Thanks and good luck.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.