Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using Excel as Data Source for Crystal Reports
I was told to create new ODBC connections using the Microsoft Excel Driver (xls, xlsx, xlsm.....) [not the Microsoft do Excel Driver] and was able to view data in formulas as planned.- moodyb
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Using Excel as Data Source for Crystal Reports
I’m using two excel (xls) spreadsheets as a data source but for some reason the data in some, not all, columns is not pulling into Crystal. I see the column/table name in Crystal, right click, browse data, and no data is shown. If I open the spreadsheet, look at that particular column, I see...- moodyb
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Show Blank Dates in Cross Tab Reports
Does anyone know how to ensure all columns are shown in a cross-tab report even when the columns are not populated with data? I'm working on a cross-tab scheduling report that lists an individual's name based on various shifts (row) for that day (date=columns). The problem I'm running into is...- moodyb
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
