Capturing the UserresPonse and then decoding it

[system]

Hi ,
I am Using a Stored Procedure as a data providor and the region code is used in the Prompt and region name is there in the Data providor output . The probable values for prompt region code could be be multi like ‘1,2,3’ or single like ‘1’ .

Now I want to show the respective region names for the region code selected by the user in the Prompt in the report header,
For that purpose I can use user response function and capture the region code and in case of single value i can decode to respective region name but how to decode in case of multiple input values like ‘1,2,3’ as the values are contained in single quotes and seperated by comma .

Can anybody help please …
Charu

---

charugarg (BOB member since 2007-08-21)

[system]

Read the below post and look for the suggestion given by Dave Rathbun
Though its for WebI but should give you a lead in what you want

120×120 10.4 KB

Hi, im building reports in WebIntelligence and I need to display the Parameters (UserResponse - Query Filters) in the header of each report. when the report is run, the user is prompted and selects all the items in the list - I want to display “ALL” rather than all the items in the list (causing it to run off the page). How do I do this? I just started using Business Objects, so I’m sorry to post what is probably a no-brainer. I do appreciate your help. D J (BOB member since 2007-06-20)

.

---

haider (BOB member since 2005-07-18)