Hi All,

I have encountered an issue that is at least new for me.  We are going through the process of updating reports to a new DB that also has several additional schema that were not in the previous DB.  Unfortunately, we have 5 different schema that actually have tables with the same names in them.  The schema are as follows:

lm_fin
lm_gen
lm_hcm
lm_ipa
lm_scm

Our issue is that when we work through Crystal Reports XI and selecting a new data source to update to, it is automatically selecting the incorrect schema.  It would appear it is selecting the first schema in alphabetical order that has these tables: lm_fin.  We need the reports to be updated to look at the lm_ipa schema.  Is there a way to manually set this?

Thank you, everyone!

Thank you!  Didn't think I would have to do it for each field but thankfully, that isn't too painful. : ) I appreciate the help!  Thank you again.