M
Mark
Hello all,
I prefer to run my queries in vb code. Is there a way to get the results to
show in a Sub Report?
vSql = "select area_id as POD, logon_id as UserId, count (trans_stt) as Puts
from wcs_to_via_t
where trans_stt ='00'
group by area_id, logon_id
Results:
POD USERID PUTS
---------- -------------------- ----------------
01 AFERNAN 1026
02 CDILWO 977
I know I can base a subreport on a query that would get these results, but
there is more to the sql "Where" statment and it is easier to work with these
varibles in vb.
I prefer to run my queries in vb code. Is there a way to get the results to
show in a Sub Report?
vSql = "select area_id as POD, logon_id as UserId, count (trans_stt) as Puts
from wcs_to_via_t
where trans_stt ='00'
group by area_id, logon_id
Results:
POD USERID PUTS
---------- -------------------- ----------------
01 AFERNAN 1026
02 CDILWO 977
I know I can base a subreport on a query that would get these results, but
there is more to the sql "Where" statment and it is easier to work with these
varibles in vb.