When re-ordering columns or applying filters to edit a custom report these changes are not saved and do not appear in the next run of the report.
This behaviour is caused by an known issue and has been assigned the reference number "FNMS-27236".
The steps below will result in the issue and can be used to determine if the behaviour witnessed is caused by the issue.
1. Reports menu > Reports Index.
2. Select any custom (non Out Of the Box) report, Open the report.
3. Run report the report.
4. Add filter or move column within the report.
5. Click 'Save as' button and name the report.
6, Click Save.
7. Run report again.
Expected Result: same as listed in step 4.
Actual Result: same as listed in step 3, the changes made to grid were lost.
The issue assigned to this behaviour is currently scheduled for review, once resolved the issue number will be listed in the product release notes.
I have gotten another number attached to the same issue, FNMS-31780. So a question, when I will be looking into release notes to see if this is solved will both numbers show up?
this issue still exist in the latest FNMS 2019 R1 release.
@dbarrDo you have any updates on this case?
Same frustration here
We are using the cloud version and experience the same behavior.
Nevertheless, I have found a workaround that works perfectly (at least for me):
Use Microsoft EDGE!
That's it! The reports can be edited and the applied filters are saved.
PROBLEM SOLVED (at least for me)
Try it and please provide feedback.
@dbarr @Codebuster @MrPotato @KMaria @rene_lansink
seems to be fixed in 2019 R2 On-Prem
IOJ-18076622 ReportsReport "Save as" loses advanced filter setting
As I said: With Microsoft Edge as the browser of choice, the bug is gone with the FNMS Cloud version. Everything works fine when you re-open an existing report.
You can change and save everything like re-arranging columns applying or changing advanced filters or even change the whole report from the scratch.