USERDATASOURCES AND SQL
i have a SQL that i want to run... onjoins and stuff like that,
linebyline i can fill the matrix, its working ok, but slowly...
i just want to know if i can bind the column to a userdatasource, fill the "UDS" with the data retrieved with the sql recordset and then just show it in the matrix...
if yes, please, can send me example on filling the datasource?
(this is the SQL:
select T1.ItemCode+' - '+T3.ItemName from OWOR T1 INNER JOIN OITT T2 ON T1.ItemCode = T2.Code INNER JOIN OITM T3 ON T2.Code = T3.ItemCode where T1.DocNum <= 100
Thank you guys