Hi,
I'm a newcomer to crystal, which I'm running on a win2k on top of a Unify Dataserver database - I'm also a newbie with the database, but I've already hit some walls.
I've found out that the Unify dB will not allow outer joins - these have been an essential part of my tools so I've been looking to workaround this somehow.
workarounds:
1.I can easily run the Unify dB via ODBC in Access - but this doesn't really work with respect to distribution to the eventual users. Outer joins work though!
2.I thought could build a union query showing the results I need and link that to the main query (that doesn't need outer joins). However I cannot get Crystal to link a query to another query/table. I get errors, "Field not Found. Datadictionary Field .... not found" etc etc etc
argh!
Can anyone shed any light on this? I'm stuck with this Crystal+Unify=Grief equation...Thanks!
I'm a newcomer to crystal, which I'm running on a win2k on top of a Unify Dataserver database - I'm also a newbie with the database, but I've already hit some walls.
I've found out that the Unify dB will not allow outer joins - these have been an essential part of my tools so I've been looking to workaround this somehow.
workarounds:
1.I can easily run the Unify dB via ODBC in Access - but this doesn't really work with respect to distribution to the eventual users. Outer joins work though!
2.I thought could build a union query showing the results I need and link that to the main query (that doesn't need outer joins). However I cannot get Crystal to link a query to another query/table. I get errors, "Field not Found. Datadictionary Field .... not found" etc etc etc
argh!
Can anyone shed any light on this? I'm stuck with this Crystal+Unify=Grief equation...Thanks!