I would like to know how to add a variable to a datareport dataenvironment object to make a selection based on criteria... I have tried:
SELECT * FROM TOPCARD WHERE (RSC = RSCTOPRINT)
In the SQL statement box but it does not work.
I have a global variable RSCTOPRINT defined in a variable and I am passing data to the variable befor the datareport is opened. I just need help to figure out the syntax to put it in the SQL statement.