Running a stored proc report from Inventory Maintenance  Topic is solved

Support for Crystal Reports within Jiwa.

Running a stored proc report from Inventory Maintenance

Postby Atronics » Sun Feb 24, 2019 1:48 pm

Hi Scott,
I have a similar problem to that of Clare's 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 to 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... no good try again..

Then I created a new report using only IN_Main and inserting my stored proc report as a subreport on the details section, using Inventory as the link. The report runs but the InventoryID is not passed to the subreport.
Regards
John I

p.s I added some of the above to the existing topic but since it is showing as solved, I guess you did not receive any notification from the forum.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10

Re: Running a stored proc report from Inventory Maintenance

Postby Mike.Sheen » Mon Feb 25, 2019 9:56 am

Atronics wrote:Hi Scott,
I have a similar problem to that of Clare's 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 to 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... no good try again..

Then I created a new report using only IN_Main and inserting my stored proc report as a subreport on the details section, using Inventory as the link. The report runs but the InventoryID is not passed to the subreport.
Regards
John I

p.s I added some of the above to the existing topic but since it is showing as solved, I guess you did not receive any notification from the forum.


Hi John,

Can you provide a sample report which demonstrates the issue?

Thanks,

Mike
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: Running a stored proc report from Inventory Maintenance

Postby Atronics » Mon Feb 25, 2019 11:27 am

Good morning Mike,
sample report and sp is attached
Attachments
Sample_Report.zip
(18.44 KiB) Downloaded 404 times
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10

Re: Running a stored proc report from Inventory Maintenance

Postby Atronics » Fri Mar 08, 2019 3:28 pm

Mike,
Have you had a look at the report?
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 119
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 10

Re: Running a stored proc report from Inventory Maintenance

Postby Mike.Sheen » Tue Mar 26, 2019 9:57 am

Hi John,

All I had to do was change the subreport links to use the ?@sp_InventoryID parameter:
SubreportLinks.PNG
SubreportLinks.PNG (15.52 KiB) Viewed 5190 times


Modified report attached.

Mike
Attachments
Cupping Profile_b.rpt
(64 KiB) Downloaded 419 times
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: Running a stored proc report from Inventory Maintenance  Topic is solved

Postby Atronics » Tue Mar 26, 2019 10:18 am

Problem solved. Thanks.
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

cron