Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 606 Super User 2026 Season 1
CP04-islander 356
