Displaying the months data depending on the given date range using SSRS 2005.

Question

Displaying the months data depending on the given date range using SSRS 2005.

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

dva2007 SSCertifiable Points: 7707 More actions · Answer 1

does it mean you want to show it from 1st march 2008 to 30th june 2009?

When you get the parameter into the stored procedure then get the month and year from the parameter start date and end date and try to find out first day of the parameter month (start date) and last day of the parameter month (end date).

i hope it helps.

Vijay

tenga SSC-Addicted Points: 432 More actions · Answer 2

First of all , thank you so much for the prompt response.

here in this case i dont want to consider the day part of the date(eg. here in this case 28 and the 30 day is not considered at all) only the data should be displayed on the basis of the month and the year. Here i can't use the stored procedure as i have my data coming from a cube which i have built from the analysis services 2005.

Thanks again..

htilburgs Ten Centuries Points: 1117 More actions · Answer 3

Tenga,

Maybe there is a better way, but what I would do is the next:

* Create parameter P_Startdate for Startdate

* Create parameter P_Enddate for Enddate

In the dataset you use to get the information do something like this:

select ......
from ......
where STARTYEAR=year(@P_Startdate) AND STARTMONTH=month(@P_Startdate) AND ENDYEAR=year(@P_Enddate) AND ENDMONTH=month(@P_Enddate)

Succes!

tenga SSC-Addicted Points: 432 More actions · Answer 4

I have created 2 parameters,but i want to use the MDX query for fetching the data from the cube which i have already generated through the analysis services but i don't want to use the data set, so this wont work for my case. anyways thanks for the response and any help in this is greatly appreciated.

thank you