Parameters fields and hierarchical record sets 1

[edavebrown]

How do I go about allowing end users to filter data in a hierarchical recordset with parameter fields?

 

[MalcolmW]

Could you provide some details of the specific problem? <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[edavebrown]

I have a recursive table called Organization. Organizations can have an unlimited number of parent Organizations. I need to filter on Org but I don't want to display just a flat list of Orgs. I would like the user to visually see the hierarchy so they understand that if they pick a parent Org all children Orgs are included in the selection criteria.

 

[MalcolmW]

Sorry Dave, that's on my wish list as well. As the parameter field values are populated only at design time, there is no way to do this that I have found. I would welcome information about a solution if anyone knows one...<br>
Maybe in v8 this feb?<br>
<p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[jernst]

I likewise am looking fo an answer to this type question. Here is my scenario. I am trying to create a report that will display a hierarchal report of the following type information. Assuming I have database items that have
Parent/Child relationships (self referencing or recursive data), and stored in single table, how can I display, the drill down data? For example, I have a part that has a child part. That child part has a child part of its own, and so on down.

Parent Part
Child Part 1
Child Part 2
Child Part 3
etc....

The subsequent levels show reference to the one previous level ONLY. For example, if I look at Child Part 3 (as illustrated above), the previous reference to Child Part 2 is the ONLY reference. I would have to then go to Child Part 2 to see it's link to Child Part 1 etc.... In the table, you have Part, and Parent Part. I am trying to find out if Crystal Reports can accommodate this kind of drill down, hierarchal, recursive type of data. The problem (as I see it), is that the table will show a Part and it's previous Parent part, but not it's child associations beyond a single level.

I notice it's been some time since you asked this question, and I'm wondering if you found an answer or solution.

Thank you for any help you can provide.

 

[Soph]

I've just read this topic and found it very interesting. Have you found yet a solution with parametres in a hierarchical grouping report?

I'll be very happy to find an answer.

Bye!

Sophie

 

[IdoMillet]

Have a look at my DataLink Viewer:

http://www.milletsoftware.com/DataLink_Viewer.htm

It allows you to present the user with a dynamic report acting as a live parameter dialog showing the Hierarchy and letting the user click on the &quot;nodes&quot; to be selected.

It can also allow you to progressively restrict the choices by prompting the user for high-level &quot;nodes&quot; and then displaying lower-level &quot;nodes&quot; within the selected higher-level ones.

You can download the full user manual from the link above.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com