web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

precision design in visual studio

(1) ShareShare
ReportReport
Posted on by 497
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

  • Community Member Profile Picture
    on at

    Hi,

    Right click on cell-> properties->number-> select category as a date-> select format which you want to show

  • Martin Dráb Profile Picture
    241,656 Most Valuable Professional on at

    As always, I have to ask you to tell us more about your problem. What do you mean by "to get the date"?

    Describing your problem properly is in your own interest, assuming that you want to get an answer.

  • murtafiah Profile Picture
    497 on at

    Mr. Ashu

    Not like that, but i want a parameter be the date for example it contain 3/31/2016

    and then how to get AmountMST field by date 1/1/2015 until 3/31/2015 for Last Year YTD title?

    Can you help me..

  • Community Member Profile Picture
    on at

    Hello,

     

    Can you explain me your issue in detail with screen shots so that i can help you.

  • reachnaidu Profile Picture
    890 on at

    ok .. Based on your current date, you need to calculate the last year end date from the begining of last year.. So you will get basically two previous year start and end dates . Where do you want to calculate these dates ? In Stored procedure or in SSRS Report ?

  • murtafiah Profile Picture
    497 on at

    3223.excel.png

    i want display report as this image:

    3223.excel.png

    how?

  • murtafiah Profile Picture
    497 on at

    Mr. Sree Potturi

    i want to calculate these dates in SSRS Report..

    Can you help me???

  • Verified answer
    reachnaidu Profile Picture
    890 on at

    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.

  • murtafiah Profile Picture
    497 on at

    Mr. Sree

    that is good idea,, but how to create two hidden parameters begin date and previus end?

  • reachnaidu Profile Picture
    890 on at

    are you developing SSRS report outside of Ax or  do you want to deploy that report in ax ?

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
nmaenpaa Profile Picture

nmaenpaa 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans