|
I am trying to connect to a view to write a simple crystal report. There are no other tables or views needed. When I look at the view in SQL management studio I can see the information I want to include on the report.
If I browse data by right clicking however in crystal I can only see the information being populated for certain fields but not others. If I drag a file with data on the report it will run but if I include a field for which data does not show I get the following errors:
Failed to retrieve data from the database
Followed by
Failed to retrieve data from the database
Details: 42S22 [Microsoft] [SQL Native client] [SQL server]
Column Name ‘Customer’. [Database Vendor code 207]
The Column name of Customer is a little confusing as Customer is the name of the view. The field I tried to drag on the report that caused the error was Customer number but Customer name or address 1 will return the same error.
The ODBC connection I used I have used for many other reports (some written off views) with no problems. The only difference is that I wrote those views myself while this one was created during the installation of the accounting software.
Thank you in advance for any help you may be able to provide.
|