Comments in Queries

[adminboy]

Hi there,

How do I put comments in the SQL queries in the Report Source?

Thanks,
Adminboy

[SupportKeymaster]

The SQL syntax for a comment is to start a line with ‘–‘ (without the quotes). However, due to our extended SQL parsing, this only works if you put the ‘–comment’ at the end of the SQL query…

select x, y, z

from atable

order by x;

-- some comments here

As an alternative, you could use the REPORT NOTES field to make notes about the SQL.

[adminboy]

Thanks.

[Author]

Posts