Skip to Content

While Setting A Graphic's Location--A String Is Required Here

Hi. I'm fairly new to Crystal Reports . I am attempting to create a report with an .xlsx as a data source. In this spreadsheet there are 2 fields: "item" and "description". I put a formula in the format graphic that in prior reports (using ODBC connection to MySql Database) that worked perfectly to pull the pictures from my server and display them dynamically in my reports. This time however I'm getting a message when I error check my formula that CR is expecting a string instead of the field name which does not make any sense to me. Your help is really appreciated as I am stuck.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 14 at 09:47 PM

    Depending on the data in that field, Crystal may be seeing it as a number. You could try using this instead of just the field name:

    ToText({Items_.Item}, 0, "")

    This will convert the number to a string with no decimal places and no thousands separator.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • May 15 at 02:39 PM

    Thank you Dell. It worked!

    Add comment
    10|10000 characters needed characters exceeded