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

Group By issue

Hello All,

I am kinda new to this, I believe the doubt which i have is simple to answer. My question is, I have a specific report in which I have used group by "Product" and "Channel", when i execute the report the group header shows the value for the products for first group but if I add a text within that group header then the text is repeated just above the product name. Example : the text name appears and then below it the 1st product name, then the text appears again and then below it 2nd product name, the text appears again and then below the 3rd product name. This happens for the number of products appearing in that group.

What I am looking for is to display text only once at the top and then the product name. Actually my main motive is to insert a graph at the top and then the product names, but instead it creates a graph for each product. Please help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2009 at 03:41 PM

    try suppressing or removing the field that is not in the group header. then the info will only appear once

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2009 at 03:57 PM

    If you insert a graph in group header then that graph will show only that group data so you will get each group data with graph in group header. If you want all the group data to be shown in one graph then place the graph in report header.

    Regards,

    Raghavendra.G

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      thank you for the response but the issue is different here. I have 3 groups created for dynamic selection of the dimension thru prompts. for instance if user selects "Product" at the first level then the report shoud display "Product" graph wrt some measure, it works well when i place the graph on page header of the report. Now when user drills down to the second level then how the graph will be placed on the page header for group 2, i have to place the graph on the group header which eventually splits graph for each entity on the second level. I cannot have multiple graphs in page header for each group.

      Do i need to insert multiple section for page header. If so then how can i conditionally suppress each graph wrt drill down on that specific level. If three page sections created PHa, PHb and PHc, i will place the graph for 3 groups in the section, now if a user is looking at the first level then he should see only PHa, if he drills down to level 2 then the report should suppress PHa and PHc and display only PHb, if further drill down to level3 then report should suppress PHa, PHb and show only PHc, can this be achieved?

      Can i use "Drilldowngrouplevel" function to achieve this? Thank you.

  • Posted on Oct 03, 2009 at 11:25 PM

    Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with your directly

    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.