Share
ReportI have a date parameter that is 03/31/2016 .
I want to ask how to get the date of 01.01.2015
and 31.03.2015 using these parameters ..
*This post is locked for comments
You’re offline. This is a read only version of the page.
495
I have a date parameter that is 03/31/2016 .
I want to ask how to get the date of 01.01.2015
and 31.03.2015 using these parameters ..
*This post is locked for comments
ok for example look at this class InventDimPhysDP and the method ProcessReport . In the code you need to create two dates for previous and add your additional fields(display) to the table that gets back to report . You can query the table and have the data in the fields for the dates that you calculated.
Be aware that every time a developer will deploy report from AOT or a developer refresh data Sources, your own added parameter can go away. This is due to fact that AX-SSRS reports read parameters from AX Meta Data. its not Normal SSRS. so, be aware of doing anything extra outside AX.
you may think to manage it inside AX. such as in your RDP class you can filter query.
are you developing SSRS report outside of Ax or do you want to deploy that report in ax ?
I would recommend having two hidden Parameters Previous Begin date and Previous end date .They are calculated based on the selected date.
For Previous Begin date : you can hard code '01/01' + DateAdd(Year,-1,CurrentDate)
For Previous end Date : DateAdd(Year,-1,CurrentDate) . These values you can pass where ever you want.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (