Print Page | Close Window

Excel

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21594
Printed Date: 25 Apr 2024 at 4:25pm


Topic: Excel
Posted By: julieg7777
Subject: Excel
Date Posted: 10 Jul 2015 at 5:35am
I had to create a new Excel spreadsheet from a report that was designed to pull from a spreadsheet. It's been recreated exactly, but the report is not seeing any of the fields. If I try setting the location, all I see is the name and location of the spreadsheet, with not option to expand it to look at the fields. Any ideas what's going on?



Replies:
Posted By: hilfy
Date Posted: 15 Jul 2015 at 4:04am
Does the first row of the spreadsheet contain the field names (no rows above it)?

What version of Crystal are you using and is the Excel file an xls or an xlsx?

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics



Print Page | Close Window