Hi,
How to give the input parameters in SSRS report dynamically while it runs in batch in AX 2012. For example, I've to send a mail with report attachment in batch .In that report, there is Date parameters.If I run a batch today means it retrieves the records till today(02-12-2019). After one or two days,if report runs automatically through batch means it retrieves the record only till 02nd. For me it should show till the current date. Please help me to solve this.
Thanks
If the parameter is a field in the report dialog, you can't have it work dynamically. In such case you have to develop a parameter that is not a date, but rather "number of days". If the parameter is zero, run the report for "today". If the parameter is one, run the report for "today -1" and so on.
You can use dynamic date for the query criteria for the report. You can input "T" for today's date.
docs.microsoft.com/.../advanced-filtering-query-options
You can use SysQueryRangeUtil::currentDate() or (Day(0) as shown here axinventory.blogspot.com/.../moving-date-ranges-for-queriescuesbatch.html
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,964
André Arnaud de Cal... 823 Super User 2025 Season 2
Sohaib Cheema 564 User Group Leader
