I have a field called "Coding" on my Invoice form. Back when the world was young any of the following list of codes could be entered there:
RT;RTS;RTSH;RTSHC;RTSC;RTH;RTHC;RTC;RS;RSH;RSHC;RSC;RH;RHC;RC;TS;TSH;TSHC;TH;THC;TC;SH;SHC;SC;HC
(Individual letters R, T, S, H and C could also be entered there, but the reports I need look for multi-coded invoices)
Time marches on, and the codes needed have changed. "H" is gone, and "O" has entered the mix. The order in which these codes appear in the field follows strict rules which my users know. Because this is so, my reports which refer to this field all have saved specs which include the codes as in the string above. But these specs are now outdated, and for the reports which look for codes with more than one letter, I would rather exchange the speed of a report which has such a saved spec with one with the accuracy of this spec:
{ @Len(Coding) > 1 }
This is much slower, but picks up the invoices last month which now include the letter O, which are overlooked by the original spec.
Long story short: I've changed the retrieve spec and "Saved" it using the spec manager, but the reports which use this saved spec still look for the invoices with the codes spelled out. What must I do in Designer to get the reports to use the revised spec? Will I need to recreate the whole report?
I may have a followup question based on this one later. Thanks for your help.