Changing a datatype solely for the purpose of Excel Export in Crystal Reports

Posted by yeahumok on Stack Overflow See other posts from Stack Overflow or by yeahumok
Published on 2010-04-27T17:58:33Z Indexed on 2010/04/27 18:03 UTC
Read the original article Hit count: 296

Filed under:

crystal-reports

|

excel-export

I have a report that has several numerical fields. To fill a project requirement, i had to use the following formula:

if {DataTable1.No of Investments}>9999 then '*****' else toText({DataTable1.No of Investments},0)

Basically, if the number fed in is bigger than 9999 it turns into * on the report.

Now, when i try to export into excel, not only is the data type for all fields, strings...but the * show up versus numbers.

I was wondering if there was a way to re-cast this back into a numerical value SOLELY for the purpose of excel exportation so that i'd be able to use excel formulas as well as see numbers instead of asterisks. I'd only be doing data-only excel exports.

Any ideas?

© Stack Overflow or respective owner

Related posts about crystal-reports

Crystal Reports: Save Time with Formula Sharing

as seen on ASP alliance - Search for 'ASP alliance'
Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. >>> More
Automate delivery of Crystal Reports With a Windows Service

as seen on ASP alliance - Search for 'ASP alliance'
In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More
Crystal Reports: 5 Tests for Top Performance

as seen on ASP alliance - Search for 'ASP alliance'
Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database… >>> More
Crystal Reports for VS deployment to Web Application doesn't work (3 replies)

as seen on .NET 247 - Search for '.NET 247'
I've followed the "documentation" for getting crystal reports to work on a production web site. I've migrated a VS 2003 web project to a VS 2008 web application. Everything works fine on my dev box. publish the site out to the server (2003 X86) and no go on the reports, get the infamous:… >>> More

Related posts about excel-export

Excel - export sheet to fixed-width text file?

as seen on Super User - Search for 'Super User'
I know that Excel has functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns. Does it also have functionality where, given an existing spreadsheet, you can export to a fixed-width text file… >>> More
Simple C# CSV Excel export class

as seen on Stack Overflow - Search for 'Stack Overflow'
Thought this might be handy for someone, this is an extremely simple CSV export class that I needed. Features: Extremely simple to use Escapes commas and quotes so excel handles them fine Exports date and datetimes in timezone-proof format Without further ado: using System; using System.Data… >>> More
Excel export displaying '#####...'

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to export an Excel database into .txt (Tab Delimited), but some of my cells are quite large. When I export into a txt some of the cells are exported as '#######....' which is surprisingly useless. Has this happened to anyone else? Do you know an easy fix? Data from one cell of my column: … >>> More
Excel Export Issue displaying '#####...'

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I'm trying to just export and excel database into .txt (Tab Delimited) but some of my cells are quite large. When I export into a txt some of the cells are exported as '#######....' which is surprisingly useless. Has this happened to anyone else?/ know an easy fix? >>> More
ASP.NET Excel Export formatting question

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey Guys, I've been banging my head on the wall over this issue for a couple days now and I need some help. I'm creating an excel file using ASP.net and everything is going just fine except one column has to be formatted as a decimal to 2 places but when it pulls into excel, excel automatically… >>> More