Creating tab delimited values for blank fields

[TryingToLearn101]

Hi all,

I am using Crystal 2008 and trying to create a report that I eventually will export to Excel and save it as a tab delimited file.

I have 40 columns on my report. From those 40 columns, I only have information for the first 10 columns. However, when I export it to Excel and save it as tab delimited file, I need to still end up with 40 tabs. Even though the remaining 30 tabs don't have any information in them.

This doesn't happen. Basically after field 10 (the last field I have information for), it goes to the next row of data instead going through the remaining 30.

What can/should I do in this situation?

I hope I am explaining clearly.

Thank you in advance.

TTL101

 

[kenhamady]

Try this. Saving a formula with just "" in it. Place that on the report after your other fields. If that adds more tabs then add it as many times as needed.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/