Skip to Content
avatar image
Former Member

Using Excel data

I want to be able to use individual excel cells (ex. A1, D6, B3) as individual fields in Crystal Reports. I want to be able to place each cell / field anywhere on the report just like I can with database fields, not displaying them in a column format. Can you please tell me how I can bring in / import the excel data into Crystal Reports in that way?

Any help on this topic would be appreciated.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 09, 2009 at 07:05 PM

    Stew,

    You could enter the Excel worksheet as multiple Linked OLE Objects in CR. When the data in the cells (worksheets) changes and the report is opened it will update the OLE object from the changed xls file.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2009 at 06:39 PM

    Crystal reads the column from Excel as the field and as far as I know you can not get an individual cell as a field.

    Add comment
    10|10000 characters needed characters exceeded