Posted on: 9/23/2015 7:33:30 AM | Views : 782

I have a report which will pull the data from below stored procedure
    -- Insert statements for procedure here
                SELECT Empname
                FROM  EmpComp
                UNION
                SELECT ('NULL') AS Empname
 
The values are coming correctly. But dropdownlist is showing NULL in the middle of other datas.I want NULL as first value in the drop downlist(so that easy for selecting). This stored prcedure is connected to a dataset(in report) which have one parameter (Empname).
 
How can amend above code for that .Thanks

Go to the complete details ...