date range filters at report level

building reports webintelligence
1

Hi,

I have a requirement in a webi report where I should have two filters: start date and end date and it should enable the users to filter the data based on those start and end dates. I tried to do a between prompt but the user did not like it.

Is it possible to create any custom filter in the report to give the user that ability (without using prompts)? I currently only have one date field

Thanks,
Anu

anubotu :albania: (BOB member since 2010-04-29)

2

You have to do it in the Universe as a conditional object and thats the best way of doing this.

If user don’t want any prompt to be supplied, then you can hardcode the values on the start date and the End date.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

3

Anu, are they going to be the fixed dates? or something like today and previous month, etc,…?

Jansi :india: (BOB member since 2008-05-12)

4

Hi Jhansi/John

The dates are not going to be fixed, they will be selected by the user. Basically there is a field called PRS Month in our report, what the user wants is two dropdowns one for start date(read as month) and one for end date(month) and once he selects the values, the report should then run for that date range. Please guide me. Sorry for responding late.

Thanks,
Anu

anubotu :albania: (BOB member since 2010-04-29)

5

Hi,

Please see the attached. Bring the PRS Month to the Query Filter and use the between operator and Prompts. I hope the PRS month is an universe object. Hope this helps!
Thanks…
Prompt.JPG

JohnJustus :us: (BOB member since 2007-06-25)

6

Hi John,

thanks for the response. This is what I originally did but the user is not happy. He wants it more like a drop down filter. A DD filter for Start Date and another for end date in the report.

does that make sense?

anubotu :albania: (BOB member since 2010-04-29)

7

I am not sure if you will be able to change the look and feel of the prompt screen with out breaking the underlying code.
May be using some sort of SDK it is possible. Give a search in the SDK forum as well or please wait and see if some one chip in with some more information that you are looking for.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

8

thanks for your input John. yes like you said, i will wait for some body to get back to me on this one.

anubotu :albania: (BOB member since 2010-04-29)

9

I found some thread discussing similar to your requirement in SDK Forum here. Give it a try over there as well.

Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

10

Hi John, can you please send me the link to the thread if you still have it?

thanks,
Anu

anubotu :albania: (BOB member since 2010-04-29)

11

Please search here.

http://www.forumtopics.com/busobj/viewforum.php?f=40

JohnJustus :us: (BOB member since 2007-06-25)