After export to flat file, all records are in one line, help!?

I created a package that exports contents from a table to a flat file but all my records are being displayed in a single record. where do i configure it to where each record has its own line. the columns in the flat file are fixed.Did you specify a row delimiter? If you did, and specified a LF as the delimiter, you may need to view the file in Wordpad or something. Otherwise, I'd guess there is no row delimiter chosen.|||You should pick fixed width with ragged right for the flat file type if you want a row delimiter, or in line with Phil's suggestions, you can set the column delimiter on your last column to {CR}{LF}.|||THANKS PHIL AND JWELCH, BOTH YOUR INPUT WAS VERY HELPFULL...THINGS ARE WORKING NOW.

After export to Excel, cells background color disappear

After I exported a report to Excel, some of the cells' background color disappear.

Only the columns without data were displayed without background color, although I'd specified color at design time.

Hi

Typically the color must be retained. can you please post some code sample here for us to help you out.

Thanks

VJ

|||

hi vj, i don't have sample code as there's no code involved. i just specified the cell background to dark green.

this discolorisation problem only occur on group cell. for example, the first column contain group header risk category. second column contain risk id. some risk id belong to the same risk category. so for every risk id, risk category is only displayed for the first occurrence. for the other risks, the risk category is empty. as a result the background color defaults back to white.

i hope i explained the situation. i can send you the spreadsheet so you can see what i mean.

|||

Hi,

From your description, the exporting to excel is a built-in function which enables you to export the current report to an excel formatted file.

When you are going to export a report to the excel formatted file, it converts the fields which filled with data to the cells in excel with the format, but for those fields without data, it wouldn't.

Based on my knowledge, since this is a built-in function, it's difficult for us to set the background through codes or any programmatically ways.

Thanks.

|||

that's what i thought nai-dong.

is there any workaround for this.