Creating a report to run from the Inventory Maintenance Menu  Topic is solved

Support for Crystal Reports within Jiwa.

Creating a report to run from the Inventory Maintenance Menu

Postby Clare » Thu Jan 24, 2019 12:50 pm

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
Clare
I'm new here
I'm new here
 
Posts: 9
Joined: Tue Jan 12, 2016 4:54 pm
Topics Solved: 1

Re: Creating a report to run from the Inventory Maintenance

Postby Scott.Pearce » Thu Jan 24, 2019 12:51 pm

Which Jiwa version?
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 748
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 225

Re: Creating a report to run from the Inventory Maintenance

Postby Scott.Pearce » Thu Jan 24, 2019 12:55 pm

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 748
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 225

Re: Creating a report to run from the Inventory Maintenance

Postby Clare » Thu Jan 24, 2019 3:18 pm

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.
Attachments
2019-01-24_15-15-28.png
Image of report selection when running from Inventory Maintenance.
Clare
I'm new here
I'm new here
 
Posts: 9
Joined: Tue Jan 12, 2016 4:54 pm
Topics Solved: 1

Re: Creating a report to run from the Inventory Maintenance   Topic is solved

Postby Scott.Pearce » Thu Jan 24, 2019 3:24 pm

Oh, in the Reports form (System Settings->Report Configuration->Reports), you need to set the report type to "Form".
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 748
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 225

Re: Creating a report to run from the Inventory Maintenance

Postby Clare » Thu Jan 24, 2019 4:56 pm

Yes

Thanks that worked.
Clare
I'm new here
I'm new here
 
Posts: 9
Joined: Tue Jan 12, 2016 4:54 pm
Topics Solved: 1

Re: Creating a report to run from the Inventory Maintenance

Postby Atronics » Fri Feb 22, 2019 3:06 pm

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.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest