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
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
Mr. Sree
Thanks sir, your solution work well..
can you explain to me with more details?
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.
i want to deploy that report in ax..
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 ?
Mr. Sree
that is good idea,, but how to create two hidden parameters begin date and previus end?
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.
Mr. Sree Potturi
i want to calculate these dates in SSRS Report..
Can you help me???
i want display report as this image:
how?
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... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156