Hi

I create a SQL query that include in Text Manager a clause
--- where tdssc017.ddat>=tdssc017.ddat.f and
tdssc017.ddat<=tdssc017.ddat.t

How can i use this variables (screen choice) in a Report Data ????

Thanks
Paiva

To the best of my knowledge this is not possible.

if the variables are tdssc017.ddat.f and tdssc017.ddat.t you can modify the report to include this variables but if you regenerates the sql query you'll lost the modifications.

the report generated by sql query is a normal report and you can modify it.

But in the report , only those values are sent which are selected in the select list of SQL queries . So even if u use it as input variable it's not useful.

ok, sorry, I was thinking that reports in SQL querys are igual than normal report trought tools

then, you can make the report trought generate sessions and copy the select in the new session, then modify the report with the necesary variables