Recent content by mk7393

Thanks steve for the clarification..I will try that..

Hi, I have 2 Web I servers. I have created personal documents in one server. I was not able to view it on the other sever. what needs to be done for this? Thanks Murali

I did not make my question clear. The prompt works if both data providers use freehand SQl.. Will it work if one uses universe?

Hi Steve, I saw that it works if you have 2 data providers. How to set the same prompt in universe? Thanks , Murali

Hi, I have a report which uses both Universe and free hand sql in different data providers. I have a prompt input which will be used in both data providers. How can I use same prompt in both dataproviders one being universe? Thanks Murali

Thanks Steve..

Hi Ties, thanks for the reply. But how can I populate the prompt with the values from database? -Murali

Thanks Steve. I will design something else then:-((

HI Steve, Thanks again for the reply. This is how my prompt looks currently where the values are hard coded. How can I pick the values from Database in a @ prompt. @Prompt ('Select an employee','A',{'Aams','Paul', 'Smith','Barb','Richard')'},MONO,CONSTRAINED) Do you have the syntax? Thanks...

Hi Steve, Thanks for the reply..I need some moer clarity. So explaining my issue in more detail.. Say I have some employee names in a database table In the BO report there is dropdown which gives the names of all employees. I need to select a particular employee and run the report for him...

I have free hand SQl which receives some input through @prompt. I have hard coded values in the prompt now. IS there any way by which I can get it dynamically from the database.? Remember I do not use a report from Universe but from Free hand SQL. Thanks