I am trying to create a report off an old propritary database and I'm running into an issue because of the data being not-quite normalized. The table in question contains activity codes that are usually generic and keyed by a fixed string + the code. However the codes can also be customized to specific users in which case the key used is the user + the code. The applications using this data simply check for a user-specific code first and if a not-found error is returned, they use the generic code instead.
Is there any way to replicate this behavior in Crystal Reports v9? I could create a complex SQL query to handle this, but I'd like to try and do everything within Crystal Reports proper. Can SQL Expression fields help me here? I've never used them before and the couple of attempts I've made have not worked. Any hints or assistance would be greatly appreciated. Thanks!