Sunday, August 20, 2017

Freehand SQL – Multiple Parameters/Filters


Freehand SQL with multiple parameters can be created by selecting Report option & 
select Advanced Authoring.

Write a desired SQL query & use {?} wherever parameter required in report. Select data type
for filters.
























After validating, report looks like this then use format to rename the filters.













Provide the filter values manually to get report
















Report sample output.
















Thank You !!

No comments:

Post a Comment