Using 4d variable inside a query in quick report editor

160 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

1
PeterInWiesbaden On

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

Peter

0
Umberto Migliore 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)