Hi All,

I was wondering if it is possible to to create a print report of a SQL query, and put the selection rang in that report.

example:
I have a SQL query and put tdsls001.qdat on the form, the ranges are tdsls001.qdat.f and tdsls001.qdat.t
Is it posseble to display the values of tdsls001.qdat.f and tdsls001.qdat.t on the report?

Kind regards,
Marc Dekker

Hi Mark.
No idea if it could be done. I would put the report in debug, jump to the header and than give an lp or Lp command. This would print all the variables known by the report to display. You could than search for the value you had put in the field tdsls001.qdat.f. You might be able to see the value and use it in the report.

Groetjes, Mario

Hi mark

I tried adding these variable in report input fields and then add them in header layout. this approach didn't work. I was not able to add them in report input field.

Later I tried add import the variable in the report script. this approach also doesnot seem to work

Let us see if somebody else comes up with solution

Regards

Well I know it has been discussed before and I do not recall a solution.