Crystal Reports 9 set datasource location problem
Posted on 2006-04-14
I'm curious if anyone can tell me why I'm unable to set a new datasource location?
I have 4 identical databases in an SQL server where I'm wanting to use a single report to connect to each database to show data. Sounds simple enough, right? I'm not trying to do anything strange, just wanting to run the report 4 separate times to connect to each database individually to get 4 separate results.
When going through the usual steps (and I've done this many times before with other reports), I can see that the report is not working right because the 'show SQL query' results doesn't change. It looks like the datasource is getting changed, but no matter what I do, the <databasename>.dbo.TableName is 'stuck.'
The only way I've been able to get it to work, is to create 4 separate reports, which I'm wanting to avoid. I'm *thinking* the problem may be because this report was converted from 8.x, and it's left something embedded (the table alias, I suppose) which can't be changed.
Has anyone else had this problem and found a reasonable solution?
Also, just out of curiosity, does Crystal Report XI have this same annoying feature that you have to go through to set a datasource location, verify database, etc?