The control renders but in only 4 pixels as a block. If i manually enter items into the control then they show up, however when i'm trying to use my datasource the items don't. Heres my query...i have done something similar to this in the past with the same control and it worked, however this is not. I'm almost certain it might be my query so i figure a 2nd pair of eyes looking at it might notice something i haven't?
select 0 [id],'Select a Location'[Name],0 [ParentID],0 [Realid] |
-- |
union |
-- |
select 2 [id],'Dispatch'[Name],0 [ParentID],-2 [Realid] |
-- |
union |
-- |
select 3 [id],'Myself'[Name],0 [ParentID],-3 [Realid] |
-- |
union |
-- |
select 4 [id],'Another Rep'[Name],0 [ParentID],-4 [Realid] |
-- |
union |
-- |
select 5 [id],'Queue'[Name],0 [ParentID],-5 [Realid] |
-- |
union |
-- |
select 6 [id],'Close'[Name],0 [ParentID],-6 [Realid] |
-- |
union |
-- |
--Reps |
select (id+4)id ,Name,4 [ParentID],id [Realid] |
from tbluser |
where id > 1 and isrep=-1 |
-- |
union |
-- |
--Queues |
select (id+4)id,Name,5 [ParentID],id [Realid] |
from tblqueue |
where (inactivedate is null) and isrepspecific=0 and id<>-2147483645 and Name<>'Application - Practice Manager' and Name<>'Application - FlowCast' |
--order by id asc |
-- |