Error running report: “Filter could not be applied. Could not apply filter…”

Hey,

I was creating a new report and applying some filters while testing it.

After a while, after changing the dataitems structure, i got the following error:

Microsoft Dynamics NAV
———
Filter could not be applied. Could not apply filter “01/01/10..03/06/14” to column no. “20” because the field is missing or unavailable.
———
OK
———

To resolve it, here’s what I did.

1. Close Dynamics NAV

2. Find the following file: C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\PersonalizationStore.xml

Dynamics NAV saves some personalization info in these file.

3. You could simply delete this file but you may lose some another filters and personalizations. I didn’t wanted that! So i’ve searched for “70035”, my report ID.

4. Delete the lines found. In my case were:

5. Save the file and open Dynamics NAV again. You can now run your report

Note: This solution may be applied in similar errors in pages.