Hello all, my problem is quite similar to one- yet unanswered- post from another fellow titled "Business View Problem."
However, I'm sporting Crystal 9.2.0.448 and running it against a Microsoft Access 2003 DB. (The Access DB is in turn linked to another SQL DB).
I have the report looking at a view (Access Qry). It can see all of the fields, but is pulling null values on some of them that clearly have data. When I run the query in Access, it all shows up correctly. Basically, Crystal is not seeing the data in certain fields. Any suggestions?
Thanks!
However, I'm sporting Crystal 9.2.0.448 and running it against a Microsoft Access 2003 DB. (The Access DB is in turn linked to another SQL DB).
I have the report looking at a view (Access Qry). It can see all of the fields, but is pulling null values on some of them that clearly have data. When I run the query in Access, it all shows up correctly. Basically, Crystal is not seeing the data in certain fields. Any suggestions?
Thanks!