Skip navigation

Smart Reporting: Allow the use of parameters with Freehand SQL in Advanced Authoring mode.

score 65
You have not voted. Below Review Threshold

I'd like to add the ability to use parameters when creating a Smart Report in Advanced Authoring mode using Freehand SQL as the Author Method to allow filters to be passed when running the report.

 

The following query is prompted for a data field type when you click the Validate button, it returns a 'SQL is invalid' message after selecting 'Text' for the data type.  It looks like it recognizes the parameter field but doesn't process it correctly.  

 

SELECT  `HPD:Help Desk`.`Assigned Group`

FROM `AR System Schema`.`HPD:Help Desk`

WHERE  `HPD:Help Desk`.`Assigned Group` = {?}

Comments

Vote history