Author Topic: multiple entries of months on prompt  (Read 631 times)

Offline ajhuzky

  • Full Member
  • ***
  • Posts: 6
  • Forum Citizenship: +0/-0
multiple entries of months on prompt
« on: 19 Mar 2009 06:54:29 pm »
Hi!

Maybe someone can help me how I can remove multiple items in a single prompt.
Example: Months --> prompt shows like this
                       January
                       January
                       January
                       February
                       ....
up to                December

What I need is January up to December. Is it a Report Level issue or a Dimensional Model issue?

Hope someone can help..  :(

thanks!
thanks,

aj

Offline DanSev

  • Full Member
  • ***
  • Posts: 32
  • Forum Citizenship: +0/-0
Re: multiple entries of months on prompt
« Reply #1 on: 20 Mar 2009 12:42:36 am »
This depends on the query you are using to populate the prompt. If you are pulling this data from a detailed table (many records for each month), you'll end up with many instances of the month. Also if you are displaying 'Month', but passing/using a different value it will display month for each distinct instance of the other value.

You can

A) Make a prompt with static choices (one for each month)

B) Have the query that is running the month only contain the month and values rolled to the month, and pass only the month or a value on a monthly scope to the filter in the report.