# SaveValues in Request Options Page in NAV 2009 R2

**URL:** <https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167>\
**Category:** Developers Forum\
**Created:** [October 29, 2012, 3:38pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167 "2012-10-29T15:38:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [October 29, 2012, 3:38pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167/1 "2012-10-29T15:38:58Z")

</div>

On of my users are suddenly reporting errors in connection to saving the values on the Request Options Page in NAV 2009 R2. The SaveValues option is selected.

The strange thing is that the field has an initial value, which is not set in the code. It looks like the values somehow are “stuck” and are no longer being updated.

So the question is, have anyone heard of problems with SaveValues and RTC?

Is there a way to “reset” the stored values for an object, like deleting the ZUP file in classic?

---

<div class="post-metadata">

**Author:** ![PalleA](https://avatars.discourse-cdn.com/v4/letter/p/3e96dc/32.png) [@PalleA](https://www.dynamicsuser.net/u/PalleA)\
**Post date:** [November 6, 2012, 8:22pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167/2 "2012-11-06T20:22:32Z")

</div>

Hi Erik

I have tested several times the build 32012 - and I do not have any problems with save values on a page. The property is ofcourse found on a blank line on the Request Page and then View, Properties - Just set it to YES.

When you run the Report then the values are saved if you do a preview or a print - In order to save the typed/choosen values you have to let the report print or preview all pages.

So what do you have to do if you want to reset everything - Just delete the zup-file ?? Oohh yes there are no more zup files so where are the data saved ? Data are being saved in several places so the deletion might not be that easy.

Some of the RTC-values are saved in a file called: PersonalizationStore.xml (Column sizes and more)

There is also the ClientUserSettings.config (Paramenter setup stuff)

Inside the database stuff are stored in the following tables:

2000000072 Profile  
2000000073 User Personalization  
2000000074 Profile Metadata  
2000000075 User Metadata

You should be able to delete your Save Values by deliting your profile - You can find it here:

/Departments/Administration/Application Setup/RoleTailored Client/User Personalization

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [November 6, 2012, 9:09pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167/3 "2012-11-06T21:09:24Z")

</div>

Thanks Palle,

Ok, good to hear. Because I know it used to work. It just doesn’t work after we updated the build to 33793. I’ve tried to install the latest build (33910) but it’s still the same problem.

I have also reset the settings for the report, but that didn’t change anything.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![dcintron](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@dcintron](https://www.dynamicsuser.net/u/dcintron)\
**Post date:** [November 7, 2012, 5:12pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167/4 "2012-11-07T17:12:44Z")

</div>

Delete the User Metadata for the Page - even if it is a report, there will be Page metadata.

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [November 7, 2012, 5:57pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167/5 "2012-11-07T17:57:43Z")

</div>

That’s what I already tried (per Palles advise above). But thanks anyway.

Other suggestions?

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [November 22, 2012, 9:03pm UTC](https://www.dynamicsuser.net/t/savevalues-in-request-options-page-in-nav-2009-r2/41167/6 "2012-11-22T21:03:37Z")

</div>

Ok, I finally have some update on this one after I have been i contact with Microsoft (thank you Kim Carrock Kobberø). The answer from them were (written here with his permission):

_Two things are in play here:_

_1. Save values_  
_The property “Save Values” is in relation to the fields not filter fields. The save values property will save the value of a normal field in the DB._

_2. Filter fields_  
_Filter fields will be saved in the personalization file on the user pc. On my Windows Server 2012 the folder is this one: “C:\Users\<username\>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV”. One thing to note is this: if the request page has prefilled filters, then what the user enters in the filter fields will not be saved._

_So to better understand the scenario try this repro:_

_1. Go to the sales order and click the report Order Confirmation_  
_2. You will now see the request page for report 205 and the filter is set to be “no = ”_  
_3. Try adding a filter or changing one_  
_4. Run the preview._  
_5. No click the order Confirmation once again_  
_6. Now you see the filter not changed._  
_7. Now navigate to CRONUS International Ltd./Departments/Sales & Marketing/Order Processing/Documents and run the same report._  
_8. Now the filter is not prefilled with the order no._  
_9. Modify the filter and run the preview._  
_10. Open the report again_  
_11. Now you should see the modified filter._

_Note any change to the fields (not filter field) on the request page through the entire repro will be saved, since the “Save Values” property is set to yes._

So my issue is really not the SaveValues. That works fine. It’s “only” related to the filters (req. filters).

And what we actually also found out was that they **"fixed an error**" which is why it suddenly wasn’t working the way it used to for my customer. The “error” was that there was an inconsistency between the help text and the way it worked. Instead of fixing the help text, then they fixed the application. At least that’s how I understood the explanation:  
_Bug 212352 - SETTABLEVIEW doesn’t work in the RTC as it does in the Classic client_  
_According to the help, if you use the function SETTABLEVIEW in conjunction with a report, the filters applied by the user should not be saved for later use. This is true on the Classic client, but the RTC doesn’t seem to adhere to this. The Report Page that is create in order to run with the RTC doesn’t have the SaveTableView property and I assume is why the SETTABLEVIEW doesn’t work the same._

**In plain “English” what the change did is that if you have called your report using SETTABLEVIEW then it will not save any filters your users are setting manually. Not even if the filters are set to a secondary table in the report, where SETTABLEVIEW was not used.**

I think they could see that this change wasn’t very good, but since my access to [connect.microsoft.com](http://connect.microsoft.com) - then I have not been able to get online to register this “change request”.
