This content is now out of date.

Visit Our Community

Declare Variable inside of freehand report

I have a freehand report that requires the user to input 3 date parameters which are @param1 @param2 and @param3. and inside the report it may read tabe1.start_date >= @param1 and table1.start_date <=@param2. Once I validate the SQL I go to the report section. My question is can I bring those parameters over like I do the data fields
I figured it out. I was forgetting the step SET @param1 = {?}