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

Summary not working on morethan one hierarchy in Crystal reports for enterprise 4.0

Hi,


I'm developing Crystal report on morethan one hierarchy, but summary is not working as expected.

Here is the scenario where summary is not working.

Step 1: BEx Created with two hierarchies one measure variable ( EX: GL account, Profit Center(Hier. dimension) with Balance as measure variable)

Step 2: In Crystal report, I have dragged the GL Account root Hierarchy, Key and Text (from GL ACcount), Profit Center root Hierarchy, Key and Text (from Profit

Center) and Balance is as measure.

Step 3: Here, I have created one group on GL account Hierarchy and displayed GL Key along with Measure in same group( User wants to see at GL Account

level only).


But, measure value is aggreating wrongly(It is aggregating from low level nodes to hiher level root nodes) as shown below.
When I remove Profit center objects from Result Object panel then it is working fine. But, I don't want remove because profit center objects are used for different

perpose in same report.

Please suggest me your valuable inputs. Let me know if you need more clarification/inputs.

Same attached as Excel sheet:

Resut Set Objects GL Account Profit Center Amnt

Expected value Wrongly aggregating in Crystal reports GL Account Amount - Node level(3) Amount - Node level(2) Amount - Top Level(1) Issue In crysr Levels Gl1 110 220 1 P1 80 2 P11 30 3 P12 50 3 P2 30 2 P21 20 3 P22 10

Here, I want to display only Gl1 along with measure data as 110 only but it showing 220.

Regards,

Ravi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 04, 2012 at 06:26 PM

    Hi,

    How are you displaying the objects on report layout and also post the formula your are using for aggregation.

    Thanks,

    Jothi

    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.