Jiwa

I originally created a report a Bill of Material Report to run in Bill Maintenance screen, so it can trace the Subassembly get used in which finished goods.
The entire logic is running off from a stored procedure (see attached)

I have modified the report to have it run against Inventory Maintenance, so It can trace all BOM used this PartNo

The logic works when running inside Crystal Report itself.
However, when I try to run it from Inventory Maintenance it keeps have the attached error poping up.

I need someone to give me an advice on how to resolve it.

When run from inventory maintenance, Jiwa will place this in the record selection formula:

{IN_Main.InventoryID} = 'xxxx'

where xxxx is the InventoryID of the inventory item you are currently viewing on the screen.

This implies that you must have the table IN_Main as part of your report for the selection formula to be valid.

Simply add the IN_Main table to the report and link it up appropriately to the existing tables. If the report is being driven by a stored procedure the same still applies - crystal sees both tables and stored procedures as the same thing: data sources that can be linked together.