I have created a geopraphical report and circle radius, to meet the requirement i have used Union query.I was able to plot the circle based on Latitude, Longitude and Radius
We have quick filter on Region, Name & Level, which have Null as one of the filter. If we exclude "Null" the circle plotting is not done.
I want to exlcude the "Null" value only from filter and also plot the radius circle
Select S1.Longitude as Longitude S1.Latitude as Latitude S1.Region as Region S1.Name as Name S1.Level as Level Null as Degree From S1 union Select S2.Longitude as Longitude S2.Latitude as Latitude S2.Region as Region S1.Name as Name S2.Level as Level Null as Degree From S2 union Select null as Longitude null as Latitude null as Region Null as Name 3 as Level Null as Degree From degree
Note : The degree table have 1 to 360 number to plot the circle in 360 degree