Hi Experts,
I have developed a RDP report in AX based on AOT Query. The issue is that whenever i go to select the filters, it shows one of filter and its value repeatedly.
My Query is as under
Hi Sergei ,
Upon Resetting,it still shows old values which is a problem for me.
Hi Faran,
You can reset the query if you go to "Select" and press the "Reset" button in the query filter form. By default, previous values are saved and show them when you open the form again.
But it's strange you have a lof of the same ranges. Try to reset them with "Reset" button.
Hi Sergei
Whenever i click menu item of report, this Dimension filter shows old values too in lookup along with new selected.Can i empty this on clicking menu item or just it should show the last values selected in previous run.It is caching all previous values.
Hi Sergei
I am not modifying query ranges in code as you see below.
[ SRSReportQueryAttribute (queryStr(myAOTQuery))] public class myDP extends SRSReportDataProviderBase { PRSalarySheetTemp pRSalarySheetTemp; } [SysEntryPointAttribute(false)] public void processReport() { this.insertPRSalarySheetTemp(); } private void insertPRSalarySheetTemp() { QueryRun queryRun = new QueryRun(this.parmQuery()); while (queryRun.next()) { pREmployeePayments = queryRun.get(tablenum(PREmployeePayments)); // // // } }
Hi Faran,
Do you have code which modifies query with ranges?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156