Ingres again shows us it's true colors

Report writer.

A nice, powerful reporting tool for ingres.

Except

• Documentation is vitually non-existent(hard to find)


• Local variables are hard to use


• You cannot retrieve a variable in a select statement

Not a long list, but the third point makes it next to useless, if they introduced the idea that you can do this:

.SETUP
       select date_from = date_trunc('day', date('now') - date('1 day') );
       select date_to = date_trunc('day', date('now') );

It would be a very nice tool indeed, as it stands it lacks this very important functionality. If you try to do this it tells you you cannot retrieve anything in the setup area, which you are not.

It would be nice if CA cleaned up the report writer so that the query syntax was the same as it is everywhere else.

Also, if a session table needs to have the "on commit preserve rows;" flag then automatically apply it, don't error out and tell me to do it, I don't care!