TppDBMemo can't find in PrintToFile Setup

rbuser

In detail band I have several TppDBMemo and TppDBBarCode component, but in
Print To File Setup, I can't found these component in Available Control list
or Selected Control List, why? Is it not allow to print DBMemo and DBBarCode
to file (csv format)?

Thx!!

nicocizik

Hi,

Memo objects are not supported for export to a comma delimited text file.
You can try using a DBText object instead that is hidden when printed to the
screen instead.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

If using DBText object, I found that the original enter key in the field
value has some display problem, for example, if using DBMemo, then there is
5 lines, but if using DBText and exported to csv file and then open in
Excel, only 4 lines is displayed with some word origin in different line now
join to display in one line in Excel.
I'm using version 7.03, any solution?

Thx!!

nicocizik

Hi Peter,

Are you exporting to a Text File? If so, this text file is not meant to be
.csv compatable. If you look at the text file (using Notepad), is there
data missing? My suggestion is that if you would like to see your reports
in Excel, try using one of the Excel export devices available from Gnostice,
Waler, or Pragnaan.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

In print to file Setup, in File type option, I choose "comma delimited", and
I save the file with extension .csv, so I think I am export to csv file
format, not text file, in fact there is not data missing using DBText, just
the enter (or return) key has some displayed problem like some origin two
lines text now displayed as one line text in the csv file.
I don't expect to see the reports in Excel, I just want to export the data
and label (in a particular band) from report to a csv file and see in Excel,
not expect to see the origin report layout in Excel.
any solutions?

Thx!!

rbuser

Sorry, is my reply clear enough? I just want to say if using DBTEXT, the
exported result is different from what I see using DBMemo in report, the no.
of line in a cell of Excel is smaller than the no. of lines in DBMemos
component in report.
Has these made the question clear?

thx!!

nicocizik

Hi Peter,

DBMemos are not supported in TextFile export. Simply setting the file
extension to .csv does not make the text file created a valid csv file. The
comma delimited files ReportBuilder exports are very similar to csv file but
there are apparently some minor differences (or else they would work
correctly in Excel ).

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com