Report - Save Settings - Editiablity

jordanfey
jordanfey Member Posts: 1
in NAV Three Tier
Hi All,

I am looking at using the "Save Settings" option for reports to generate "repeatable" routines for the users.

To give you some context, I am dealing with the "Phys. Inventory Journal", and my requirement is specifically around report Object 790 (Calculate Inventory). We have a large number of different ways users need to run this, depending on the location and material type they are counting. I have saved each of the configurations, and they are available in the drop down on the request page.

The issue is that the "Posting Date" is saved within the settings, and as soon as you select the saved settings, all options change to read only / non editable. Running the calculation with the wrong date is obviously not of any use.

The work around for the users is to run the "Calculate inventory" with the saved settings, then rerun it with "Last Used Settings" and then edit the posting date. Obviously this is not ideal, especially with the queries returning large data sets.

Can anyone point me in the direction of how to set the fields on the request page to editable after the saved settings have been selected?

Thanks

Jordan

Answers

  • Juhl
    Juhl Member Posts: 724
    You could overwrite the date in code in the report to TODAY or whatever. I do that in your situation.
    Follow me on my blog juhl.blog
  • NaviBoogie
    NaviBoogie Member Posts: 6
    edited 2017-12-25
    Hi, I have the same issue as jordanfey- the functionality of save settings looks fine. But it is annoying that you cannot alter settings after having selected them. My users want to change periods, so the date filter should be possible to be set per run. Juhls proposed solution is also fixating/locking the user...
    I have looked at CU 1590 - request page parameters helper and at table 2000000196 - object options. but havent found a way so far to load the saved settings from the blob field of the object options table to the request page of the report and make them editable afterwards.
    Does anyone have an idea of how to come around?

Categories