on 05-27-2010 3:39 PM
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
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.