Hierarchy issue - some parent/child records not showing on report 1

[MegOBytes]

I am new to Crystal (V 10) and had to jump into the Hierarchical Report feature immediately. The feature works fine except for when it comes to a record where the child field value is shared by more than one parent. It would appear that the first instance of the parent/child relationship is output to the report but when the second instance of the child occurs, the report does not show the record.

Example (from JDE database for tasks relationships table F9001 and task definitions table F9000:

parent task AP001 calls child task AP020
later on parent task PUR001 calls the same child task AP020

since the ap tasks sorts before the pur tasks the report correctly shows the AP001 / AP020 task relationship
but when the pur tasks are are reported, the PUR001 / AP020 relationship is not reported.

Does Crystal only use a child value once? I would think not because in a bill-of-material application, a child part number can be used many different times.

I appreciate any insight into this problem.

RP

 

[Madawc]

A record can only be in one group. If you want it grouped two different ways, you may need a subreport (placed in the report header or footer).

Also take a look at Insert > Crosstab.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[MegOBytes]

Thanks for the info, although I'm still confused by the limitation. As I posted earlier, bills-of-material applications, which this feature seems to address, would have the same problem?

Cheers!
RP

 

[kenhamady]

Unfortunately, Hierarchical Grouping will NOT solve the BOM issue, and this is exactly why.

Fortunately, it doesn't seem that you need this feature anyway. Just add the table twice and create a normal link between the two instances. Then add a group. The one-to-many relationship of the tables should allow the task to show up twice.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[MegOBytes]

Thank you Ken

I am new to the Crystal Report community and i must say that this forum seems to have some very good members with lots of ideas. I appreciate your insight.

RP

Rick Piekos
Massachusetts