on 06-26-2009 10:00 AM
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
Most of those Shift characters are reserved names for Windows and Databases. Do not use them in table or field names.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Crystal Reports uses certain characters to identify different types of fields.
@ = formulas
? = parameters
= running totals etc
There is no way around it. You will have to rename/recreate the table without the @.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.