August 28, 2010 at 7:54 pm
Hi,
I am in urgent need for this answer.
I need to develop a report in ssrs which has a parametrs "period ending"
here the values of this parameter are like july-dec 10, aug to jan 10 and ect(QUARTERS)-it is dropdown list.
when a user selects the perticular period ending from the dropdown list
Then i want to find the count of total number of Orders of last 5 quarters since the current quarter.
I am really in urgent need.
can any one tell how to implement this.
Thank you
Preethi
August 30, 2010 at 4:35 am
Hi,
the value you have given is for half yearly.
create a table with quarter1 to quarter 5 and current quarter
populate this using a SP by finding data for each quarter and show this in report
Hope this helps.
if i misunderstood do explain more.
Regards
Durai Nagarajan
November 9, 2010 at 3:35 am
Hi,
I got a problem converting below logic into a SQL. Please assist.
Objective: To provide an indicator to display a completed quarter breakdown by months in current date
e.g, today's date is 9-Nov-2010, since today is in a middle of Q4Y10, then it should display last Quarter Value which is Q3Y10 - [Jun10],[July10],[Aug10])
I got this logic:
CASE WHEN (
(CASE WHEN getdate() not in ('31-Mar-2010','30-Jun-2010','30-Sep-2010','31-Dec-2010')
THEN
CASE WHEN CALENDAR_QUARTER - 1 <> 0
THEN
CAST((CALENDAR_QUARTER-1) AS VARCHAR(10))+'_'+CAST(CALENDAR_YEAR AS VARCHAR(10))
ELSE
CAST((4) AS VARCHAR(10))+'_'+CAST(CALENDAR_YEAR -1 AS VARCHAR(10))
END
ELSE CAST((CALENDAR_QUARTER) AS VARCHAR(10))+'_'+CAST(CALENDAR_YEAR AS VARCHAR(10))
END)
<> CAST((CALENDAR_QUARTER) AS VARCHAR(10))+'_'+CAST(CALENDAR_YEAR AS VARCHAR(10))
THEN 'Y'
ELSE 'N'
END AS COMPLETE_QTR_FLAG
I am stuck at this because if i added a filter based on the indicator COMPLETE_QTR_FLAG = 'Y', it'll always displays the current quarter.
Please help me...i am drowning... :crying:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply