Using 4d variable inside a query in quick report editor

136 Views Asked by At

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.

2

There are 2 best solutions below

0
On

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)

1
On

Double-click the column header with the field name. Then you get an editor.

Peter