Is there a way to take a field, xxx4402xxx, and in the parameter select only char's 4,4 to run the report on?
I thought I could do it with mask, but am having some difficulty.
Depending on your CR version, pre CR9 would not resolve formula and brought back all data to local PC, CR9 and above converts above formula to correct SQL and reduces data selected on database server.
This would get values like xy44yy8 and tjrkertj44 - is that what you want?
To make your own investigation of these tests, put them first as a 'boolian', a formula field that returns 'True' or 'False'. Do this without selecting data, to be sure you have it right. Then include the formula field name in the selection, and it will work on that.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
If you have CR 8 or above, consioder using a SQl Expression using a SUBSTR to parse the data, then you can reference the SQL Expression in the reocrd selection formula.
Ian: I believe that some ODBC drivers will not parse and pass the SUBSTR in CR 9 and above, but in general it's true that Crystal does a better job of passing sql to the database in CR 9 and above.
I may not have been specific enough. CR9, PSQL9, W2003 server.
The user is only going to know the 4 digit number, not the whole string. Is it possible to have them enter a parameter of 4402 and have the report select file xxx4402xxxx ?
Ian's formula would do exactly what you want. I wouldn't use {?parameter} in {fieldname}, since if there were other numbers in the field or if they entered only three numbers, e.g., it could pick up the wrong records.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.