Question on EXPRESSIONSPACE/sqr.ini

[Birinder Aulakh <bsa@CREDITACCEPTANCE.COM>]

We are running Brio Portal 7.0., jobfactory is on HP_UX 11.0, Database
verion is 7.3.4. We are using sqr43/sqr42 on UNIX. The Brio Portal reports
are being run from Windows NT/2000 environment.

We have an SQR report that when run gives us a ' (SQR 4038) Out of space
while processing expression; Use -Mfile to increase EXPRESSIONSPACE' error.
Our expressionspace is commented out and if we change it 65535 the sqr job
runs fine -but we have a lot of jobs running and by increasing this to 64k-
1 we could max out the unix server (we think).

We can set up the job in Brio Publisher and add the -mflag with the our
custom ini (expressionspace increased to 64k-1) file, it works fine also.
But we have a job that sends an email back to the user with the contents of
the output (XLS spreadsheet) - defined as email sqr job. We have tried to
add -m flag (same as the job without the email) but that sends a blank xls
file in the email. We have tried to add -ZIF flag but when we save the job
in brio publisher (from one administrator) it does not save the flag.

ANY HELP WILL BE GREATLY APPRECIATED.

I would really appreciate if someone can send me an email to
bsa@creditacceptance.com with any suggestions.

Birinder S. Aulakh (bsa@creditacceptance.com)