Skip to Content
author's profile photo Former Member
Former Member

how to break down the parameter date?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 06:07 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 07:38 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.