COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ftgarcia0618 on 04 May 2015 05:08:22 PM

Title: Refresh & Update Textbox Prompt Values
Post by: ftgarcia0618 on 04 May 2015 05:08:22 PM
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,
Title: Re: Refresh & Update Textbox Prompt Values
Post by: CognosAnalytics on 04 May 2015 07:47:04 PM
Hello ftg0618,
Have you tried the search and select prompt UI ?

-Cognos810
Title: Re: Refresh & Update Textbox Prompt Values
Post by: ftgarcia0618 on 05 May 2015 12:25:53 PM
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).
Title: Re: Refresh & Update Textbox Prompt Values
Post by: BigChris on 06 May 2015 02:13:49 AM
Quotejust 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.