Error when running a customised BOM Report  Topic is solved

Support for Crystal Reports within Jiwa.

Error when running a customised BOM Report

Postby JimmySu1402 » Tue Aug 29, 2017 2:11 pm

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.
Attachments
[ASAS_usp_JIWA_BOM_WhereUsed_INMain].sql
(2.63 KiB) Downloaded 294 times
ASAS Where Used Report - Inventory Maintenance.rpt
(60.5 KiB) Downloaded 292 times
Error in running.JPG
Error in running.JPG (34.38 KiB) Viewed 2921 times
JimmySu1402
Occasional Contributor
Occasional Contributor
 
Posts: 10
Joined: Wed Sep 03, 2014 12:16 pm

Re: Error when running a customised BOM Report  Topic is solved

Postby Scott.Pearce » Tue Aug 29, 2017 2:28 pm

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


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron