ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Where Used & Crystal Reports
http://www.istechforum.com/YaBB.pl?num=1060266000

Message started by kruskay on 08/07/03 at 08:20:00

Title: Where Used & Crystal Reports
Post by kruskay on 08/07/03 at 08:20:00

What would be the best way to create a "where used" report in Crystal?

Thanks

Keith

Title: Re: Where Used & Crystal Reports
Post by Tim Keating on 08/07/03 at 10:03:07

Did you know there's one in DBA ? (BM-C)

If you need to do it in Crystal, use BKBMMSTR.Bxx file. Choose fields BKBM_PARENT, BKBM_COMPONENT and BKBM_QTY_REQD. Group on COMPONENT and you'll get a simple, one level report. Further grouping will go into deeper levels.

You can link to BKICMSTR.Bxx for Description fields.

Title: Re: Where Used & Crystal Reports
Post by kruskay on 08/07/03 at 11:17:56

Thanks Tim