Actually when you need to populate the prompt values based on another prompt then you need to click on the APPLY button first to set the presentation variable value and then use them in the prompt.
Or you can create separate prompt sections with two APPLY buttons.
However without using the first prompt with presentation variable in the second prompt will show 'NO DATA' only and its logically correct :)
If Hospital and Province are columns in the same prompt, you can use the 'Limit values by' functionality in the Hospital column criteria(along with All column values instead of SQL results) and choose Province (or All prompts if indeed need to restrict by all other columns in that prompt). This way the Hospital column will be restricted based on Province as soon as Province is selected (ie without hitting Apply)
If Hospital and Province are in different prompts then you can use the presentation variable and SQL results method you have been trying.
Increase the logging level for the user and check what physical query is being fired for populating the Hospital column.
Thank you for explanation.
My complete parameters are:
Which I want the Hospital Name depend on 3 other parameters above it.
@Muram, I have followed your suggest to apply Province Parameter first then click on Hospital Name Parameter.
Still not show any data.
If you want to restrict hospital name by all the other 3 parameters in the prompt, have you tried using the Limit values by - 'All prompts' feature available? Not sure why you would want to use a SQL to achieve it. If the logical model is built correctly, you would certainly get right results with this feature, even without hitting apply