Using 4d variable inside a query in quick report editor

Question

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.

score 0 · Answer 1 · answered Jun 04 '18 at 18:36

0

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

Peter

answered Jun 04 '18 at 18:36

PeterInWiesbaden

167
3

Thank you for your input, the problem was to include a variable in the said editor. – Dylan Jun 08 '18 at 11:16

score 0 · Answer 2 · answered Sep 15 '18 at 07:02

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)

Using 4d variable inside a query in quick report editor

2 Answers2