help with report sql

[joebordes]

in this blog post:  http://blog.corebos.org/blog/reports02

it says that you must:

• each column must have an alias that is the module name followed by the field label with all spaces substituted by underscores.
• The last column must be the crmid of the record of the row with an alias of ACTION
• you must select the main module of the SQL command when creating the report in order to support ad-hoc conditions
• you cannot use conditions on groups (having)
  

You are missing the "ACTION" condition. I added

Code:

, 1 as 'ACTION'

and it worked