Multiple Prompts in Report

[system]

Hi All

Im working on one report , here i need to have three prompts 

prompt1 : Program A
Prompt2 : Program B
Prompt3 : Custom Date

When i run that report it has to display the prompt with the above three
values in it.
When i click on the Program A , it has to display the Program A period (i.e 4/1/2005 to 4/20/2005)

When i click on the program B , it has to display the Program B period(i.e 5/1/2005 to 5/20/2005)

When i click on the Custom Date… it has to prompt me to enter start date and end date.

I was able to get the first two by adding an object in Universe… but i don’t know how to get the third one (custom date)

Any idea?? Thanks in Advance.

---

Prasad123 (BOB member since 2005-04-14)

[system]

Hi Prasad,

You can use the following formula to get the custom date if that’s what you are looking for…

Tablename.Objectname BETWEEN @variable(‘3. Enter Start Date as ‘‘mm/dd/yyyy’’’) AND @variable(‘4. Enter End Date as ‘‘mm/dd/yyyy’’’)

NOTE: When you Type in prompts with BETWEEN operator it will show up as @variable in SQL.

Hope that helps. Let us know.

YASH

---

way2boguru (BOB member since 2005-01-17)

[system]

Hi Yash

 Looks like you are not clear... let me put it this way

The first two prompts should be predefined… i don’t need to enter any values… if i select “Program A” then it should display the specified range
and same with “Program B” too.

If iam not intrested in the above two … then i have to select “Custom Date”… there it should ask me to enter ‘Start Date’ and ‘End date’

I hope it will give more understanding

thanks
Prasad

---

Prasad123 (BOB member since 2005-04-14)

[system]

try to create the prompts in Designer with case statement
NEO

---

KhoushikTTT (BOB member since 2005-02-24)

[system]

@Prasad123

…If iam not intrested in the above two … then i have to select “Custom Date”… there it should ask me to enter ‘Start Date’ and ‘End date’

I hope it will give more understanding

I don’t think this is possible as you’ll always have to enter a value in a prompt if I’m not mistaken.

---

jobjoris (BOB member since 2004-06-30)

[system]

You can do that in VBA.

---

JTAMBLYN (BOB member since 2003-05-28)

[system]

Hi

I already created first two prompts wtih CASE in Designer but i was not able to create the third one…since when i click on the third…again it should promt to enter “start date” and “end date”

Any idea?

---

Prasad123 (BOB member since 2005-04-14)

[system]

@Prasad123

Hi

I already created first two prompts wtih CASE in Designer but i was not able to create the third one…since when i click on the third…again it should promt to enter “start date” and “end date”

Any idea?

FAQ: Designer

How do I create cascading or nested prompts? Author: Robert Metzker Let’s create a Series of Cascading Prompts for the Island Resort Marketing Universe. We’ll simply work our way through the Resort class for a quick example. All of the prompts will be fairly similar, and I am going under the assumption that everyone has some Designer Experience. Let’s start at the Highest Level that we’d need a prompt for. That would be the Resort itself, since we need to know what Resorts we’re int…

this should help you a lot. Material on cascading prompts.

Hope this will work

NEO

---

KhoushikTTT (BOB member since 2005-02-24)