I am trying to write a report in Crystal. I want to select by Bill Number and it give me what makes up the bill of materials. Below is a sample of the report and the files I am using.
I cannot figure out how to get all the levels on the report.
I am selecting based on a Bill Number, which is how I need to be able to select.
I basically need the levels that are on an indented report.
If you mean levels as in sub-assemblies, you can't do this with crystal reports easily because you can't have a sub report within a sub report and the sage 100 ODBC driver does not support sub queries.
Why can't you use one of these reports as your foundation as they both have the option to explode sub assemblies and you can use the selection grid to select by bill number?
