Liveware Publishing Support Forum

i posted a while back about a rather long calculated field that caused arpeggio (v2 on win nt4) to crash... and now i find that i^m having the same problem in another report.____what i^d like to know, please, is WHAT is the limitation on calculated field size?____here is the field that i entered:__case(datepaid, {07/04/2002}, pay0704, {07/11/2002}, pay0711, {07/18/2002}, pay0718, {07/25/2002}, pay0725, {08/01/2002}, pay0801, {08/08/2002}, pay0808, {08/15/2002}, pay0815, {08/22/2002}, pay0822, {08/29/2002}, pay0829, {09/05/2002}, pay0905, {09/12/2002}, pay0912, {09/19/2002}, pay0919, {09/26/2002}, pay0926, {10/03/2002}, pay1003, {10/10/2002}, pay1010, {10/17/2002}, pay1017, {10/24/2002}, pay1024, {10/31/2002}, pay1031,0)____and it WORKS in the report (ie - i can print or export and the field displays correctly). it^s just if i attempt to edit the calculated field, then arpeggio completely and uneqivocally crashes (no errors, no nothing - it^s just GONE).____thanks,__ariel

The limit is based on length plus internal complexity.__If a calc exceeds the limit, you should get an error message when you create it. It should not crash on edit.__Do you have Version 9 or 10 in addition to Arpeggio?____Kathleen__R&R Support

kathleen,__i do not have any newer version of arpeggio/R&R available to me. and i^ve tried it over and over again and i^m able to create the field without any errors or other indication of a problem. i^m able to insert it into my report. i^m able to print or export the report... and then when i go back and try to edit the field (either by right clicking and choosing Expression or by choosing it from the calculated fields list), then arpeggio disappears.____the one thing that i haven^t tried is making a virgin report and putting this field into it from the begining again... i guess i could make the time to do that if it would be helpful in troubleshooting the problem??____thanks,__ariel

Are the fields in the expression fields from your table or themselves calculated fields?____Kathleen__R&R Support

sorry - i never noticed that you had asked another question!____in the example above, ^datepaid^ is from the table and all the pay###^s are pre-processed total fields.____in my previous posting about a very similar experience, the main field was a field from the table and the results fields were all fields from an attached text file.

I just did a quick V10 test where I created all of your preprocessed totals and then a calc with your expression.__In my case I can edit the calc just fine but the difference may be either my data or the version of R&R.____Kathleen__R&R Support