cancel
Showing results for 
Search instead for 
Did you mean: 

Export format type

Former Member
0 Kudos
346

Hi Team,

In our project we were using old crystal reports and which had the option to export the report into different format like

5, commaSeparatedValues
1,_crystalReport
2, dataInterchange
27, excel70
28, excel70Tabular
29, excel80
30, excel80Tabular
10, paginatedText
31, portableDocFormat
3, recordStyle
35, richText
6, tabSeparatedValues
9, tabSeparatedText
8, text
14, wordForWindows
36, Constants._XML

But in current version I could not see the above formats and also its the index changed also like below

NoFormat = 0,
CrystalReport = 1,
RichText = 2,
WordForWindows = 3,
Excel = 4,
PortableDocFormat = 5,
HTML32 = 6,
HTML40 = 7,
ExcelRecord = 8,
Text = 9,
CharacterSeparatedValues = 10,
TabSeperatedText = 11,
EditableRTF = 12,
Xml = 13,
RPTR = 14,
ExcelWorkbook = 15,

So kindly help me how can we map old report export type to new one.

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

It's not a completely 1-to-1 mapping, and some of the new formats don't work the way the old ones do:

NoFormat New Value: 0, Old Value: N/A
CrystalReport New Value: 1, Old Value: 1
RichText New Value: 2, Old Value: 35
Word New Value: 3, Old Value: 14
Excel (includes formatting) New Value: 4, Old Value: 27, 29
PortableDocFormat New Value: 5, Old Value: 31
HTML32 New Value: 6, Old Value: N/A
HTML40 New Value: 7, Old Value: N/A
Excel Data Only New Value: 8, Old Value: 28, 30
Text New Value: 9, Old Value: 8
CharacterSeparatedValues New Value: 10, Old Value: 5
TabSeperatedText New Value: 11, Old Value: 6, 9
EditableRTF New Value: 12, Old Value: 35
Xml New Value: 13, Old Value: 36
RPTR (Read-only Report New Value: 14, Old Value: N/A
ExcelWorkbook (new XLSX format) New Value: 15, Old Value: N/A
Doesn't exist: 2 - Data Interchange

-Dell