Solved

Report with Hierarchical Tree - filter by code

Posted on 2004-03-31
3
279 Views
Last Modified: 2012-05-04
Hello,

I have a good problem to solve.
My db (oracle) has a table of equipments(eq) in it. In that table i have two specific fields called 'eq_id' and 'subcomponent_of'. The 'eq_id' field is the primary key of the table, where lays the equipments codes, and in the 'subcomponent_of' field is where i put the code for that subcomponent (meaning that this is still a equipment code). So, i can see the equipments and there subcomponents, it's a relation father to son. There for i have a hierarchical tree of equipments and their subcomponents.
My problem is that, how can i pass that relation to Crystal Reports. Internally, the sql of Crystal needs to make a loop to run all the records, giving me all the levels the tree has.

Also, I want to restrict it to only one code. What I want, is to be able to introduce an equipment code and then Crystal Report will show me the family tree, it's subcomponents for that equipment, only that equipment, not all the equipments relations.

My version of Crystal Report is 8.5
So if anyone can help me with this issue i'll be very grateful.

Jaime Teixeira
0
Comment
Question by:vxxv
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 50 total points
ID: 10722810
Hello vxxv,

There is a Hierarchical Grouping feature built-in to CR.

Create a report grouped on the subcomponentof.
Then use Report(menu)>Hierarchical Grouping options to complete the hierarchy.

Pete
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now