Refresh & Update Textbox Prompt Values

[ftgarcia0618]

Hi,

I have a report with a new requirement to change the text box to include a refresh button underneath. This button should change user account numbers to include the account number + account name (concatenated), then the user can choose which to include the in Choices field.

I've been researching various textbox options however I can't seem to find a solution that fits the requirement.

Thoughts? Thank you,

[cognos810]

Hello ftg0618,
Have you tried the search and select prompt UI ?

-Cognos810

[ftgarcia0618]

Hi Cognos810,

Yes, that was my initial thought when I was told of this new requirement however the end users don't want to search for the account, just enter the number, refresh, then pick. This is because there are two versions of this report (internal vs external). External users don't get to enter the account number, they're simply shown whatever accounts are relevant to their security level (and currently they can only see account numbers).

[BigChris]

just enter the number, refresh, then pick

that's basically how a search and select prompt works.

The only other solution I can think of would be to have two prompts, the first a textbox prompt where the user can enter an account number, and a value prompt based on a query that selects the accounts and names, filtered by prompt1...but that's fairly similar to a search and select.