Skip to Content
avatar image
Former Member

Export format type

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 12, 2017 at 11:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded