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

Data between months range

Hi,

i have a report were end users selects "months starting" from and "months Ending" as prompts and year as another prompts.I need to show the report containing data between the user selected month prompts.I have the revenue values seperate for january ,feb,march, till..dec

Ex: if the user gives the months prompts as Months Starting =3 , Months Ending =8 and year=2012.I need to get the data for year 2012 between march and august.

i.e. march+April+May+June+July + August.

2.if the user selects the prompts as Months Starting =9 and Months Ending =12 .I need to get the data between sep and dec.

ie. sep+oct+nov+dec.

please let me know how to achieve this in deski report

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Apr 03, 2013 at 07:00 PM

    this is being asked very frequently if you do a search you will find many different approaches.

    tip: search userresponse

    thanks

    Simone

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 01, 2013 at 09:56 PM

    Isn't Month Number (Column you are using in the prompts) and the Month Column already assosoictaed with each other? You should already be getting the data filtered based on the prompt that you enter.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2013 at 06:59 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 05, 2013 at 08:36 AM

    Hi Babu,

    Can you provide more information such as whether you have Month number and Year as objects in the universe or just the date.

    If it is just the date, you need to convert that to year and month using database functions before comparing it with what is entered by the end users in prompts..

    Cheers

    Mohan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 09, 2013 at 08:04 AM

    Dear babu k,

    I do have solution for the same, but let me know whether you have searched for the same as Simone sir has told or you got the answer??....

    Thanks & Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2013 at 07:18 PM
    1. select the Month object from the universe and drag it to the condition panel
    2. select "between" as operator
    3. for the first operand, select "Type a new prompt"
    4. enter a prompt such as "Month Begin"
    5. select the second operand (the one after the "and"), select "Type a new Prompt"
    6. Enter a second prompt such as "Month End"
    7. Select the year object and drag and drop it to the Conditions
    8. select the Equal operator
    9. select "type a new prompt"
    10. enter a prompt such as "year"

    

    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.