I'm creating a 4qr quick report file, and I am wondering how I can use a variable in a query inside the quick report editor.
Using 4d variable inside a query in quick report editor
137 Views Asked by Dylan At
2
I'm creating a 4qr quick report file, and I am wondering how I can use a variable in a query inside the quick report editor.
First, you should disable "Filtering command" option in Security settings page of Database Settings, because the Query is not available in the usually reduced set of commands for every user (a query inside a report could change the current selection of reported table, for example)
After, in Formula Editor you can write an expression as
QUERY([Table_1];[Table_1]field1=Variable)