precision design in visual studio

(1) Share

Report

Posted on by murtafiah

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

I have the same question (0)

All responses (15)

Answers (1)

Community Member on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
Martin Dráb 237,904 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
murtafiah 497 on at

Like (0)

Report

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..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

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

Was this reply helpful? Yes No
reachnaidu 890 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
murtafiah 497 on at

Like (0)

Report

i want display report as this image:

how?

Was this reply helpful? Yes No
murtafiah 497 on at

Like (0)

Report

Mr. Sree Potturi

i want to calculate these dates in SSRS Report..

Can you help me???

Was this reply helpful? Yes No
Verified answer

reachnaidu 890 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
murtafiah 497 on at

Like (0)

Report

Mr. Sree

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

Was this reply helpful? Yes No
reachnaidu 890 on at

Like (0)

Report

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

Was this reply helpful? Yes No