Declare Variables in Reports

[karteaga]

Can we declare variables in reports. Report writer does not seem to accept standard SQL Declare statements.

[Nick_VDB · Accepted solution]

The SQL builder in Lansweeper does not allow for the declaration of variables. The table name and field must be called every time instead of a custom variable.