Try running the report with a restricted data set. We have had problems with "smily
faces" in data rows that caused no problems until the specific row of data was read,
when it caused strange problems.
Will the report print WHERE LIMIT = 10?
"Ben Petersen" <[EMAIL PROTECTED]> wrote:
>Javier,
>
>Thanks. But there are no punctuation or syntax problems. �To add
>to the mystery, using another customer's database (same
>structure) and the same cmd files on the same computer (mine)
>the report printed fine. Ah Ha! Bad report... nope �:( � � �Loaded the
>report from the DB where the report printed OK to the problem DB
>w/o success.
>
>Autochk reports no errors, but I'll dig deeper for a possible data
>problem???
>
>Thanks again,
>
>Ben Petersen
>
>
>On 4 Jun 2002, at 20:32, Javier Valencia wrote:
>
>> I run into the same problem. Check you expression and make sure that:
>> 1. Parenthesis are balanced. It seems that sometime you do not get an error
>> message and Rbase thinks you have a huge expression.
>> 2. Quotes (' or ") used in the expressions match the database settings
>> It solved the problem for me; good luck
>>
>> Javier Valencia, PE
>> President
>> Valencia Technology Group, L.L.C.
>> 14315 S. Twilight Ln., Suite #14
>> Olathe, KS �66062-4571
>> (913)829-0888
>> (913)649-2904 FAX
>>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
>> Behalf Of Ben Petersen
>> Sent: Tuesday, June 04, 2002 12:14 PM
>> To: [EMAIL PROTECTED]
>> Subject: Insufficient expression space or too many expressions
>>
>> Hi All,
>>
>> I have two similar reports based on the same view. One works fine,
>> the other returns the error "Insufficient expression space or too
>> many expressions". Both were working recently. I did make some
>> changes to the view recently, but you can select from it just fine,
>> and as I said, the other report works OK.
>>
>> There are 11 expressions in the report, 2 of which are look-ups.
>> The report that works has 7 simple expressions.
>>
>> Any ideas?
>>
>> Thanks,
>>
>> Ben Petersen
>> ================================================
>> TO SEE MESSAGE POSTING GUIDELINES:
>> Send a plain text email to [EMAIL PROTECTED]
>> In the message body, put just two words: INTRO rbase-l
>> ================================================
>> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>> In the message body, put just two words: UNSUBSCRIBE rbase-l
>> ================================================
>> TO SEARCH ARCHIVES:
>> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>>
>> ================================================
>> TO SEE MESSAGE POSTING GUIDELINES:
>> Send a plain text email to [EMAIL PROTECTED]
>> In the message body, put just two words: INTRO rbase-l
>> ================================================
>> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>> In the message body, put just two words: UNSUBSCRIBE rbase-l
>> ================================================
>> TO SEARCH ARCHIVES:
>> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>>
>
>
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/