Prompt Problem still persists

[Jsadas]

Hi

Still now I had problems with the Show Values not showing up when published, but I got that fixed. I need to do settings in WebI using Suprevisor. Now I am into a new problem, the prompt is not leaving me :-(.

In BO my report has user prompts(using @prompt command)
- One that displays LOV's from DB and other
- User need to enter a value

This prompt is working fine in Client, but when I publish it in WebI, Its displaying the Show Values button besides both the boxes. Since, I am not having any values to be listed for the second one, its displaying blank LOV's and is no more allowing the user to edit that box and ofcourse the show values button is changing to Refresh list.

Any solution? Thanks

 

[skrandel]

Does the 2nd one need to have an LOV associated with it at all. Why not just ignore that parameter?

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[Jsadas]

No, the second one does not have an LOV but yet the show values button is popping up. I had coded the prompt as below.

I was assuming a blank in the values place under the prompt command means no LOV, do I need to specifically code something to not display blank LOV.

sum(CASE WHEN(@Select(Budget Information\Version Name) IN @Prompt('Select the Version Name','A','Budget Information\Version Name',mono,constrained) to_char(@Select(Budget Information\Period Start),'YYYY') = to_char(to_date(@Prompt('Enter Date as MM/YYYY','A',,mono,free),'mm/YYYY'),'YYYY')then DM_BUDGET_DATA_FACT.VALUE END)/1000

In Properties I had checked, Associate list of values, Automatic Refresh before use and Export with universe. I did not check Allow users to edit this list of values.

Any help would be appreciated.

Thanks & Rgds
Jags

 

[Sridharan]

Need to clear up certain things.

How does Show Values button pop up?? unless you select it.

Does it work the way it should in FC??

Also you have given an IN clause and the prompt is of type MONO which really doesn't make sense.

Sri

 

[Jsadas]

Thanks for the update!

It works fine in full client, regarding IN clause, I was intially giving the option of selecting multiple version names, I missed to change the IN, but it does work fine in FC even with this.

Please point me on what things I need to clear.

Thanks & Rgds
Jags