on 10-05-2009 8:37 PM
I've not ran into this before. I'm pointing a report to a new location , but I'm not seeing the report data. The other odd thing is that after pointing to the new location, if I show the SQL, it is still looking at the old location. Yet another odd thing is when I'm setting locations, I don't see one of the sub reports. It's still in design view, but not in the connections screen.
Hi,
Try to run the seperate queries for the for both db locations and see whether u are getting data for it or not.
May be there is no data in other location that is why it is not visible.
Regards,
Misra P.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, I got the report working but I don't know why Crystal didn't complain about it. The new location had a field changed in the table (a linking field between tables at that). It had an underscore added by another programmer (recordid was changed to record_id). Crystal didn't complain and I even did the option to make sure the database was up to date and it claimed everything was fine. Evidently it refused to set to the new location without giving an error and was reporting no problems with the fields because it was looking at the old location.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.