Keeping leading zeros in a CSV extract from Crystal

Posted on 2005-04-11
Last Modified: 2011-09-20
Hi there
We are hoping to use Crystal Reports as an extract tool from a SQL database, and so far so good.  The problem I am having is, I have a varchar field that contains significant leading zeros and when I export that field to a CSV file, the zeros are dropped.  Is there a way in Crystal to preserve the zeros?  The preview crystal reports shows it but it gets dropped when the CSV file gets created....any help would be greatly appreciated.
Question by:wendelina
    1 Comment
    LVL 100

    Accepted Solution

    Have you tried formatting the field as a TEXT field

    ToText({DatabaseField}, "0000000000")


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now