rare characters in report

Printable View

Mar 8th, 2004, 07:41 PM
vampira

rare characters in report
hi..

im having troubles with a report...

i have a table named "alumnos" with a text fields named "id_alumno" it's a code of 13 characters..

when i save the register in my aplication it goes well, i can see the right code for each record, but when i preview the report it gives me the code less the last character (ex. FRNA780428FCFERNANDO), instead of the last character, it shows me the next text field, this is concatenating 2 fields... and if i see for "Browse Fields" it shows me the code less the last character plus a rare character like | .. something like this
FRNA780428FC|

so i dont knwo why it is doing this... this is the code when i compose the code

[Highlight=VB] Me.txtId_alumno.Text = Mid(Me.txtAp_pat.Text, 1, 2) & Mid(Me.txtAp_mat.Text, 1, 1) & Mid(Me.txtNombre.Text, 1, 1) & _
Mid(DTPfecha_nac.Value, 9, 2) & Mid(DTPfecha_nac.Value, 4, 2) & Mid(DTPfecha_nac.Value, 1, 2) & _
CStr(UCase(Mid(strRama, 1, 1))) & CStr(rsTipos.Fields("clave"))
vbcode]

and when i save the record
VB Code:
```
strSQL = "INSERT INTO alumnos "
  strSQL = strSQL & "(id_alumno,nombre,ap_paterno,ap_materno) VALUES ("
  strSQL = strSQL & "'" & Trim(Me.txtId_alumno.Text) & "','" & Me.txtNombre.Text & "','" & Me.txtAp_pat.Text & "','"
  strSQL = strSQL & Me.txtAp_mat.Text & ")"
```
what can be wrong or what can i do...

if i put a trim on the report it shows me just the first 10 characters

so i dont knwo what can i do...

any suggest??

thx
Mar 9th, 2004, 09:54 PM
ARPRINCE

The only time I encountered this character is when I was reading data from an AS400. The values were coming out as "||||||" instead of "12345".

This is not on a report however but on a datagrd. So to fix this, on my ODBC setup for my IBM client access and under the translation tab, I placed a check on Convert Binary Data (CCSID 65535) to text and that did it!
Mar 10th, 2004, 04:40 PM
vampira

i converted all to string..

today i realized that crystal only accepts me 12 characters, so i reduced the code length to 11, but for the report i convert that code into a barcode, so i should add an * at the beggining and end of the code, so it gives me a result of 13 characters, but as it just accepts me 12, i lost the last *, so i can't read the code with a scanner... :(

and it's not about the length of the field in design, it is big enough to support 20 characters... so i dont know if the formula field has a lenght limit or not...( i use a formula field to add the *)