Jiwa

Hi!

Which tables and formulas do you require when attaching new reports to the Inventory Maintenance screen so that it can run like MNT10001 - Inventory Maintenance.rpt?

I have tried taking the MNT10001 - Inventory Maintenance.rpt and clearing the report formating, and adding just the fields I like, however I am getting the "report" run screen instead of directly opening the report.

Thanks for your time

Clare

Which Jiwa version?

In 7.2, the inventory maintenance form will place the below into the record selection formula of any report launched from it:

{IN_Main.InventoryID} = <InventoryID of current record>

This implies that your report must at least contain the IN_Main table.

Thank you. The table IN MAIN is in the report

When you run the report from 7.2 you see the parameter selection screen first, before running the report as is.

You can click the report tab to see it. It would be nice for it to run just like the inventory maintenance report.

Oh, in the Reports form (System Settings->Report Configuration->Reports), you need to set the report type to "Form".

Yes

Thanks that worked.

Hi Scott,
I have a similar problem with a report that I need to run from the Inventory Maintenance. This report uses a stored proc to gather info. I have now added IN_Main and linked it tot the sp. The report now runs, but delivers no data, only field names. On checking the Formula tab on the report, the InventoryID seems to be getting passed.