Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Vivian Mosher]

Hello!

I am having trouble figuring out how to auto populate the request page of a report with the No. when the report runs.  There are many other reports where this populates with the number of the record that I am running it from.  But I can’t find how those reports are pulling the number.  I compared this report with the ones that work and I cannot see any difference.  Is there a special setting or code that I need to add?  I am using NAV 2016.  Any help would be greatly appreciated!!!

——————————
Thank you!
Vivian
——————————

[Matt McDowell]

Is this a custom report?

If so I could only find out how to accomplish this with code. This applies if you’ve put the report as an action on a page:

1. Open the page in Dev Enviroment, and open page actions.
2. Open up C/AL editor on the OnAction() for your report action
3. Add and modify the below code. In this case my report is based off a warehouse shipment, and my report is # 50043.

WhseShipmentHeader.RESET;
WhseShipmentHeader.SETRANGE(“No.”,”No.”);
  IF WhseShipmentHeader.FINDFIRST THEN
REPORT.RUNMODAL(50043,TRUE,FALSE,WhseShipmentHeader);

This requires a dev. license of course

?

——————————
Matt McDowell
Supply Chain Analyst
Valley Blades Limited
Waterloo ON
——————————
——————————————-

[Kyle Hardin]

I agree with Matt – this can only be fixed in code. But I will clarify one of the points he is making.

This is not a problem with the report itself. The problem is happening from wherever the report is being called, meaning the Action on a Page, or someplace in the code during posting the Warehouse Receipt that prints this report. That code (wherever it is) needs to tell the report what filters to use, and that will make sure that No. is populated correctly.

——————————
Kyle Hardin
NAV Developer
ArcherPoint Inc.
Atlanta GA
——————————
——————————————-

[Vivian Mosher]

Thank you both!  That was where the issue was.

——————————
Thank you!
Vivian
——————————
——————————————-