Can I export formulas in a Crystal Report to Excel
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=3048
Printed Date: 07 May 2024 at 5:05am
Topic: Can I export formulas in a Crystal Report to Excel
Posted By: Bcolmer
Subject: Can I export formulas in a Crystal Report to Excel
Date Posted: 28 Apr 2008 at 10:17am
|
I'm pretty sure the answer is no, but i have been asked by my boss if she can export the formulas along with the data when she exports a report to Excel. If anyone can confirm that this is not possible, that would really help. Or if it is, please point me in the direction of how to do it.
thanks! ------------- -Brandy |
Replies:
Posted By: BrianBischof
Date Posted: 28 Apr 2008 at 10:29am
|
You are correct that you can't export the formulas to Excel. One small option is that in a Data Only export, you have the option of 'trying' to convert summary functions to excel. If the summary function is strictly based on a database field then it will do it. Look in the options dialog box for this. I cover the exporting options and how they work in Chapter 15 of my Encyclopedia book. You can find out more about my books at http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - Crystal Reports eBooks online. ------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: Bcolmer
Date Posted: 28 Apr 2008 at 10:32am
Thanks a lot! ------------- -Brandy |