how to break down the parameter date?

[Former Member]

Post Author: maximus85

CA Forum: Formula

Hi,Here's my problem: I had a CR that had two parameter date1) Start Date - {?StartDate}2) End Date - {?EndDate}My report will shows a based on the two input parameters RANGE above. Eg: 1st Aug - 31st Oct The problem is i now need to build a subreport whenever i click the , will bring me to another subreport that will breakdown the two parameters date.Eg: 1st Aug - 31st Aug -       1st Sept - 30th Sept -       1st Oct - 31st Oct -       Final                    - What method is there that i can use to breakdown the dates with the score? i already got the fields of date and finalscore parameter from the main report inside the subreport. Just don't know how to breakthem down.Please help....thanks alot........

[Former Member]

Post Author: maximus85

CA Forum: Formula

The date is not restricted to the first day and the last day of the month. It can be any.....Eg: Parameter date : {?StartDate} = 14th Aug 07                          {?EndDate} = 25th Oct 07Then the breakdown should be:14th Aug - 31st Aug - 1st Sept - 30th Sept - 1st Oct - 25th Oct - Final                      - <--same from the main reportThanks for the reply and attention.....

[Former Member]

Post Author: yangster

CA Forum: Formula

are you always limited to the first day of one month to the end of the month 3 months after as your example illustrates or could you do it for 6 months then get a 6 month breakdown for each score to get the final score?