Is drill-down for a parent-child structure possible in CR 8.5?

[tekniks]

Hi,

I have the following database structure:
Table:B_LINK
Batch_ID
2
3
Table:G_LOG
Batch_ID Mat_ID Lot_ID
2 FM321 H05
2 KX123 H03
2 23456 H04
3 FM123 H01
3 34567 H02
**************************************
Now within the same G_LOG table the Lot_id becomes batch_id like this[/color red]

H03 FM345 L01
H04 22446 M01
H01 12345 N01
H02 44678 G01
H05 54216 G03
The link between the two tables as you can see is the batch_id.

I want to display the following info in CR(8.5):
All the Mat_id's starting with 'FM...' at whatever level in the tree they exist in the table G_LOG.
That is:

1) If for a given batch_id from B_LINK the mat_id in G_LOG is a 'KX' material then ---> go one level down in G_LOG and see if it contains an 'FM...' -- then display.
2) If for a given batch_id from B_LINK the mat_id in G_LOG is a 'FM...' material --> then display.

In the above example the batch_id - 2 has both 'FM...' and 'KX...', therefore firstly I have to display mat_id - FM321 and then drill down for 'KX123' in G_LOG to see if it contains an 'FM...' i.e. 'FM345' and display that.

I think this could be achieved if I could create a sub-report within a sub-report, which is not possible.

Is there something that I might be missing and is possible to achieve using CR - 8.5 with Oracle 7.3.4?

Any help would be greatly appreciated.

Thanks

Tek

 

[IdoMillet]

See Hierarchical Grouping under the Report menu in Crystal...

Cheers,
- Ido

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

http://www.MilletSoftware.com