Jiwa

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 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

Good morning Mike,
sample report and sp is attached

Mike,
Have you had a look at the report?

Hi John,

All I had to do was change the subreport links to use the ?@sp_InventoryID parameter:


Modified report attached.

Mike

Problem solved. Thanks.