BusinessObjects Board

Prompts.. WebI or FullClient

building reports desktopintelligence
#1

Hi There…
I want to use the prompts in an interactive way.
I want the user to select a country first and then select the state in it…
Well how can i do it??
The prompts should come in a same window
Prompt1 : Select a Country.
Prompt2 : Select a City.

Both the prompts must be in a same window. :frowning:

Note: I am using BO 6.1.3

matrixonthemove2 (BOB member since 2006-09-08)

#2

Name the Prompts as 1. Country, 2. City, 3. Area. BO should display in the order what u r expecting. If you dont give the numbers in front of each prompt it displays .“Area”. first as char “a” is the first char in asc order. follows City and Country.

sureshhh (BOB member since 2005-10-13)

#3

ow you didnt get it…

Well I want to the user to select a country first… well let say he selects “Netherlands” , then he should only see the states of netherlands in the other prompts

Like Select a Country… (Country List)

and then after he selects a country … other drop down for “state” should fill up showing the states of Netherlands.!!

I hope you get it…

matrixonthemove2 (BOB member since 2006-09-08)

#4

Consider you are having two objects country and state .Edit the property of stateobject in universe .In properties edit ,then you can see the query panel.Include country object in the condition with inlist and prompt.
check do not run the object sql .save and close.In reporter use the State object in the condition then you can see two prompts(country and state).Select country first then state prompt will show the state belonging to the country…

SATHISH1980 (BOB member since 2006-10-05)

#5

Please, look here (from the Desginer FAQ = Frequently Asked Questions):

How do I create cascading or nested prompts?

Keep in mind that one can do so called Cascading Prompts way better using Crystal Reporter.

Andreas :de: (BOB member since 2002-06-20)

#6

Well I understand that we can have cascading prompts but guys you are not getting what i meant to say (sorry again … may be my explaination is wrong :? )

But let me explain you again…
Consider just ONE WINDOW…
WHERE I CAN SELECT A COUNTRY AND A STATE AT THE SAME TIME…
LIKE

SELECT COUNTRY [LIST OF VALUES]

SELECT STATES [LIST OF VALUES (INITIALLY EMPTY)]

WHEN I SELECT A COUNTRY FROM ABOVE WINDOW

SELECT COUNTRY [LIST OF VALUES] = NETHERLANDS

SELECT STATES [LIST OF VALUES]= ÁMSTERDAM’,‘ROTTERDAM’, ETC…

AND I DONT NEED PROMPTS IN CASCADE :nonod:

i WANT ONLY ONE PROMPT THAT WOULD ASK ME FOR SELECT A COUNTRY AND A STATE AND SHOULD WORK LIKE CASCADING PROMPT…

WHEN THE USER SELECTS A COUNTRY…THE STATE LIST OF VALUES MUST CHANGE ACCORDING TO THE COUNTRY SELECTED…
I HOPE YOU GET IT THIS TIME??? … :?

matrixonthemove2 (BOB member since 2006-09-08)

#7

Either use SDK (to customize the front end of Webi/Webi prompts) or look at Crystal Reporter, which does cascading prompts the way you want (I believe).

Andreas :de: (BOB member since 2002-06-20)

#8

Can you please let me know any references… :?

matrixonthemove2 (BOB member since 2006-09-08)

#9

HI

In BO nested prompts is the only way to do it.

if you want to link both the prompts then you might have to use crystal reports. this is the only way.

or one more way to do it. but in this case you have to pass the static value to country through SDK. means if when you run the report, you have to pass the country value pre-defined or say default , only then it will work.

thanks

rajx72 (BOB member since 2006-08-02)

#10

HI

I got one more thing. I am attaching one zip file which shows example of custom prompts. this is really a very good example to custom promps.

Just change the sdk according to your need.

the file size is big so attaching as seperate
hope this helps.
Product Line Revenue.zip (134.0 KB)

rajx72 (BOB member since 2006-08-02)

#11

this is the pdf file

thanks
createCustomPrompt60EN.pdf (179.0 KB)

rajx72 (BOB member since 2006-08-02)

#12

HI

I tried and came up the the following report.
It is what you are looking for. just change and tweak it accroding to your need

hope it helps

thanks
NestPrompt.rep (81.0 KB)

rajx72 (BOB member since 2006-08-02)

#13

Hi there

Thanks a lot.!

matrixonthemove2 (BOB member since 2006-09-08)

#14

Friends
I am using BO 6.1.3 , is it ZABO?? :shock:

Well In the VB tool bar i am only able to see the “edit macro” option!!
and no other options :?

Please let me know how can i insert a macro in my report :nonod:

matrixonthemove2 (BOB member since 2006-09-08)

#15

Thans

matrixonthemove2 (BOB member since 2006-09-08)

#16

HI

you must be having beach universe. it comes by default( island marketing.)

open my report and go to edit macros. then click on tools and references.

you will see Microsoft Forms 2.0 Object library added and Microsoft Active X Data objects 2.5 or 2.6 or 2.7 library added. Just add this to your report and this will work.

If you have any doubts feel free to contact. Attaching the final version of report. I have commented out the Outlook code. If you need you can use it send the mail and report as attachment.

thanks
NestPrompt.rep (88.0 KB)

rajx72 (BOB member since 2006-08-02)

#17

DEAR Raj

Thanks for your help

I would like to know that how can i alter a list box depending on the value of other listbox
Example if i select a year ‘X’ then i want to select months for Year ‘X’
Attaching report for your references.
MacroReport2.rep (57.0 KB)

matrixonthemove2 (BOB member since 2006-09-08)

#18

Hi Can any one tell me how can i have dynamically changing values
Like if i change the value of one listbox , the other list box must change automatically
Eg
Listbox1 = lstYear
Listbox2 = lstMonth

Now throuhg a common prompt I select year 1995
so lstYear = 1995

Then after i select the year the month list box should refresh and show only the months in 1995!

How can i do it using VBA macros??

See the attachment above for the example

In short
How can I create a prompt’s List of Values dynamically based upon a value entered in a same prompt by using VBA? For instance, if a user enters ‘Northeast United States’ as a Region in a listbox of Region, then a State listbox in the same prompt should have a List of Values with States in the Northeast United States.
Well I know I can use a DSN and then populate the values in the other listbox
but the problem is i dont want to use the DSN,
I want some solution in which i can manipulate the existing objects and populate the other list box…

matrixonthemove2 (BOB member since 2006-09-08)