I use a data connection that was built from an sql statement, that uses a "With'
f.e
simplified example
in the filtering options that can be set on a pivot grid, and i assume for other grids as well,
i can only select fields from the 'real files' .. fileyyyy, filezzzz ... not from the one used in the with...
f.e
simplified example
PHP Code:
With Wfile (w1, w2) as
(select fld1, fld2 from filexxx )
Select fld4, fld5, w1, w2
from filexxx left outer join fileyyyy on
fldXxx= xxx
left outer join filezzzz on
fld...=fld...
in the filtering options that can be set on a pivot grid, and i assume for other grids as well,
i can only select fields from the 'real files' .. fileyyyy, filezzzz ... not from the one used in the with...