how to set default value as blank in dashboard prompt
Hi All,
I want to have a blank value in my dash board drop down box and i want to set default value as blank in the dashboard prompt.
to achieve this i used specific value option in dashboard prompt. Problem here is i am able to show for first time when i'm coming to dashboard. If i select somthing in the promt which did not fetch any record then that blank option is no more available in the drop down list.
Another way i tried by puting sql query in the prompt result . like
select table.column from subject area
union
select case when 1=0 then table.column else ' ' from subject area
it's not working in this way also.
is there any way to solve this proble.
Please help me ....