Concat user response

building reports desktopintelligence
1

I’m trying to concat the user prompts in a report cell. If a prompt is null, I don’t want it to show up in the cell. I may have 5 prompts in a report, if the user selects only one to populate, I’d like only that response to show up in the cell

Any ideas?

Kendy

Kendy (BOB member since 2003-08-27)

2

Hello,
If you can get around entering nothing in the prompt field let me know.
Here is a check for null and space that will give you an idea of what to do:
=If(UserResponse (“Query 1 with EFASHION” , “yr”) = " " Or IsNull(UserResponse (“Query 1 with EFASHION” , “yr”))) Then “” Else UserResponse (“Query 1 with EFASHION” , “yr”)
output response or “”

Randy Jones :us: (BOB member since 2002-08-19)

3

I used this but the field is blank. See any problems?

=If(UserResponse (“Query 1 with NRMSEVNT” , “Enter Month”)) ="" Then “” Else UserResponse (“Query 1 with NRMSEVNT” , “Enter Month”)

I haven’t tried to add any more since this isn’t working…

Thanks,
Kendy

Kendy (BOB member since 2003-08-27)

4

What about just stringing a bunch of Concatenation functions together?

Randy Jones :us: (BOB member since 2002-08-19)

5

Can you give me an example (from Reporter)? Good idea.

Also, using the example I have above, my cells aren’t working. Does the formula look correct to you??

Kendy

Kendy (BOB member since 2003-08-27)

6

Concats four user prompts:

=Concatenation(Concatenation(Concatenation(UserResponse (“Query 1 with EFASHION” , “Year”) ,UserResponse (“Query 1 with EFASHION” , “Day”)) ,UserResponse (“Query 1 with EFASHION” , “City”)) , UserResponse (“Query 1 with EFASHION” , “State”))

Randy Jones :us: (BOB member since 2002-08-19)

7

Yes, that worked! But I also have prompts where a user may want all the information and use a %. The % shows up and looks horrible. Do you think that they could be hidden somehow??

Kendy

Kendy (BOB member since 2003-08-27)

8

A) Since when can one leave prompts “empty” (not filling in any value at all) and run the report? :crazy_face:

B) To show something else but % for your user prompts look at the following Reporter functions:
UserResponse, Replace, Pos, Substr

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