If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Data Access, Manipulation & Batch Languages > Crystal Reports > Crystal Reports - Field Name restrictions

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: Feb 2013
Posts: 1
Crystal Reports - Field Name restrictions


I am facing peculiar issue with Crystal Reports XI.

I tried to create simple report and selected a table by following the automatic steps in "Standard Report Creation Wizard". When I selected the table and clicked "Next", one of the field was missing the last character. Meaning, "STAB_STUDY_FORMULA_COMPANY_CODE" is missing the last character "E". As a result, if I try to retrieve the results, I am getting an error as attached.

Error Message:

Failed to retrieve data from the database.
Details: HY000:[Oracle][ODBC][Rdb]%SQL-F-FLDNOTCRS, Column STABILITY_STUDIES.STAB_STUDY_FORMULA_COMPANY_COD was not found in the tables in current scope [Database Vendor Code: -1 ]

I referred many forums and am not able to find the solution. Any help in this regard is much appreciated.

Attached Thumbnails
Crystal Reports - Field Name restrictions-cr.jpg  
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On