April 12, 2011 at 2:37 am
Hi all,
i have values of different quarters
but i need to display the quarter values depending on the month the user selects and the category of the quarter that month fall in to.
way i need to display is shown below
Display in report
Selected monthjan,feb,marQ1Q2Q3Q4
apr,may,junq2q3q4q1
july,aug,sepq3q4q1q2
oct,nov,decq4q1q2q3
April 20, 2011 at 7:28 am
Hi,
Though i am not clear on your requirement, i assume that you want the following solution.
Considering that you have your source table with 'Month' and 'Quarter' as two of the columns. You can query distinct month names from the table and display as them in the parameter. Then use a different dataset to get the quarter details based on the selected months(Parameter) and bind the data to your data region.
April 20, 2011 at 8:33 am
Build a calendar/date table with all the date variations you can think of
DateID
Date
Day of Week
Calendar Month
Calendar Quarter
Calendar Year
Fiscal Month
Fiscal Quarter
Fiscal Year
and so on.
Once you have it built and populated all of these sorts of queries become very easy. You just join to your date table on the appropriate column and return the column you are looking for. You can probably find some good blogs and articles on the subject. Google "Date dimension" or "Time dimension" and that should get you close.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply