Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

precision design in visual studio

Posted on by 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

  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: precision design in visual studio

    Mr. Sree

    Thanks sir, your solution work well..

  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: precision design in visual studio

    can you explain to me with more details?

  • reachnaidu Profile Picture
    reachnaidu 890 on at
    RE: precision design in visual studio

    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.

  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: precision design in visual studio

    i want to deploy that report in ax..

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: precision design in visual studio

    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.

  • reachnaidu Profile Picture
    reachnaidu 890 on at
    RE: precision design in visual studio

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

  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: precision design in visual studio

    Mr. Sree

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

  • Verified answer
    reachnaidu Profile Picture
    reachnaidu 890 on at
    RE: precision design in visual studio

    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
    murtafiah 495 on at
    RE: precision design in visual studio

    Mr. Sree Potturi

    i want to calculate these dates in SSRS Report..

    Can you help me???

  • murtafiah Profile Picture
    murtafiah 495 on at
    RE: precision design in visual studio

    3223.excel.png

    i want display report as this image:

    3223.excel.png

    how?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans