Joined: 28 May 2013
Online Status: Offline
Posts: 93
Topic: Using and Excel and Oracle at the same time Posted: 22 Sep 2016 at 4:16am
I get spreadsheets of data from one of my customers all the time with a bunch of part number serial number combinations that they would like more information on. The spreadsheet I get always has different data, but it is at least formatted the same every time. I have a report that will produce what we need to answer their questions, but I would like to be able to take their spreadsheet and use that data.
Is it possible to to have a Crystal Report use that excel sheet in say the select statement so I can only return records that match the part number in column a and the serial number in column b?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 22 Sep 2016 at 4:35am
Probably. Two things to remember. One the Excel workbook and sheet will always need to be named the same. And since you are also pulling data from another data source, you probably want to use a sub-report (one data source in the main report, another data source in the sub-report. Possibly filtered by data in the main report).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
