Hi aLL,
I have two DB's. A and B. I connect to A and construct a link diagram and run the report. But i get no data. When i see the SQL Its got the database B prefixed to the tables i am using. Even when i am conncting to A its running against B and that why getting no data.
What do i do...i am new to crystal...
matuI assume you're talking about views. If a view references B then it will quite rightly return data from B, even if you've stored that view in A. This isn't a crystal problem.
If the structure of A and B are the same, remove the B prefix from the view in A. Also, create this same view in B.
Now in Crystal, change your datasource location to whichever view you want the data from.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment