on 07-09-2009 5:05 PM
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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.