Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Report with Hierarchical Tree - filter by code

Posted on 2004-03-31
3
Medium Priority
?
295 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 200 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Integration Management Part 2
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

886 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