cancel
Showing results for 
Search instead for 
Did you mean: 

The field name is not know - Record Selection Formula Editor error

Former Member
0 Kudos

Hi All,

I got an error while saving formula in Record Selection Formula Editor. I wrote something like this: {@PD_ODOT.U_Data} = {?data}. When I want to save it an error shows: This field name is not know.

I tried to find anything about this problem on forums but without result. @PD_ODOT is my user table that is registered as Mater Data UDO. I think there is a problem with '@' in table name. I created table through SQL Management Studio and there wasn't any problem like this.

I have another question. When I click an "Select Expert" icon then I see "Choose Field" window where are fields to create a condition for them. Why there aren't all fields that are in my report?

Regards

Szymon Lipnicki

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Most of those Shift characters are reserved names for Windows and Databases. Do not use them in table or field names.

Former Member
0 Kudos

Crystal Reports uses certain characters to identify different types of fields.

@ = formulas

? = parameters

  1. = running totals etc

There is no way around it. You will have to rename/recreate the table without the @.

Former Member
0 Kudos

I'm not sure it will solve problem because while creating user table SAP always add '@' to table name.

I want to add that in crystal reports in VS 2003 table name is automatically change from @PD_ODOT into PDODOT. So '@' is changed into '_' and there isn't such problems as in CR for VS 2005.

Edited by: Szymon Lipnicki on Jun 26, 2009 4:18 PM