Print Page | Close Window

Connecting to an Excel File during Runtime

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=11437
Printed Date: 01 May 2024 at 8:06pm


Topic: Connecting to an Excel File during Runtime
Posted By: epyfathom
Subject: Connecting to an Excel File during Runtime
Date Posted: 18 Oct 2010 at 2:53am
Hi,
 
I'm wondering how would I connect to an excel file in the same directory as the crystal report. I want to create a promt that would ask the user for the filename of the excel file in the same directory. Then it would connect to that file.
 
Thanks


Replies:
Posted By: hilfy
Date Posted: 22 Oct 2010 at 5:51am
You can't do this directly in Crystal.  You would have to write an application where the user would select the file and then the application will set the datasource for the report before displaying it.
 
-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