I am not sure I am understanding your request exactly. If you are hoping to actually alter the data at the time of pulling it into the report using crystal select expert, that won't work. You would have to do that in some form (e.g. a view or stored procedure in SQL)
before you get the data to crystal.
However, I think what you re trying to do you would just as easily get the results by a regular formula in crystal (not in the select expert) then you use the formula field instead of your original field to do grouping or counts or whatever.
I can give you examples of different fomula but I don't know exactly what you want to accomplish here so I am just guessing. Just rememebr that all of your results (the x oy y) have to be the same data types (both text, both date, both numeric, etc.).
Examples:
If isnull({table.field}) then "Hello, I am a null" else "Goodbye, I am not Null"
If isnull({table.text_fieldA}) then "Hello, I am a null field" else {table.text_field}
If isnull({table.text_fieldA}) then {table.Text_fieldB} else {table.text_fieldA}
Are these the kind of examples you wanted?
Edited by DBlank - 04 Jun 2009 at 8:17am
IP Logged
