prompt values

[Former Member]

I want to display prompt values in my report and show only the prompts the user entered and hide optional prompts.

the user reponse value can be used if i know out of which 8 prompts the user is going to enter the values for

can i use prompt summary and is there any way to display only prompts for which the user entered values hiding prompts for which he left blank

[Former Member]

You can use an if then else statement to display the propmt answered by users with the help of =UserResponse() function.

1.Create local variables to cpature the prompts

Prompt 1= IF (Length(UserResponse("Prompt String 1"))>0; UserResponse("Prompt String 1")

Prompt 2= IF (Length(UserResponse("Prompt String 2"))>0; UserResponse("Prompt String 2")

-

---

-

---

-

---

Prompt 8= IF (Length(UserResponse("Prompt String 8"))>0; UserResponse("Prompt String 8")

2. Prompt Summary display (in the free standing cell). Modify this variable to suit your requirement.

 Display= [Prompt 1]+[Prompt 2]+[Prompt 3]+[Prompt 4]+[Prompt 5]+[Prompt 6]+[Prompt 7]+[Prompt 8]