RI_FILTER - errors if more than 232
Posted: Wed Dec 21, 2005 1:34 pm
This issue can be reproduced for any RR9 / RR10 report if too many Report Filters have been set via the Report Program we have created for our software.____We are passing from our own report database the filter to rrunin.dbf as the runtime control file. In both databases the field RI_FILTER is C 999.____We had no issue with the same setup in RR6 - the same report in RR6 with the same filters set by the users causes no errors, if the filters are selected in the RR9/RR10 version of the report the report breaks off with various messages:____Messages that are displayed vary:__Unterminated string at offset 1 of RI_Filter__Unbalanced parenthesis at offset 232 of RI_FILTER__Unrecognized operator at offset 1 of RI_Filter____Testing with reports it seems that any filter greater than 232 characters causes an issue. __The variety of messages is explained by the fact that, of course, each filter will break of at different positions of a syntax and therefore creating different errors.____According to the documentation of RR9/RR10 the field RI_FILTER can have max C 1024, I found no issues found reported on your website yet.____This is an issue we need to investigate further as of course our reports have been created to allow multiple filter selections.____Is this a known issue? Can this in any way be fixed? Do we need to change anything?__