I have a working report working off of a SQL Database. When I insert a field from a certian table, it causes all other fields to appear blank, when I remove it, all the data comes back. Is this common? Is there a solution for this?
I have checked the links and resolved the dissappearance issue, but when trying to link to another SQL Database, even though the links checked out okay through Access, they won't work through Crystal Reports! Is there some different way that Crystal Reports views SQL Databases that is preventing the two from linking to eachother?
Crystal uses ODBC to connect to SQL databases, which is probably the same way that MS Access is doing it. But if they are different database platforms, the link is provided by Crystal, which has some limitations.
What are the databases and what behavior are you experiencing. Ken Hamady
Thanks for all your help. The problem has been solved, the reason that I was getting a blank field and Crystal Reports and a working field in Access, was because Access links SQL bi-directionally whereas in Crystal Reports, the direction of the link is in whatever direction you make it. Thus causing a blank field in Crystal Reports, and a working field in Access... now I have another problem, completely unrelated and probably very simple.
How do I get the date to be formatted MM-DD-YYYY instead of YYYY-MM-DD. The program we are reporting from wants to format the date in YYYY-MM-DD, which is really annoying. Is there a UFL out there to format the date differently??
What exactly is the data type of the field as recognized by Crystal?
If you aren't sure, "browse" the field data with a right click on the field and it will tell you. Ken Hamady
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.