Data alignment for a row in CSV Format cognos 11 is not cmg in order horizontal

[krishdw85]

Hi Team,

PFA. Alignment is not coming in proper order and this is direct sql and DB2.
Though i tried with cast (dataitem, varchar(4)) .
Character data coming in right side in row and whereas number data coming in left side in row.

Please check and send your suggestions.

Regards,
Sai

[adam_mc]

I believe this is Excel formatting the .csv file to look like this - Text values left aligned, numbers right aligned.
Open the file in a text editor (notepad...), not Excel, and view how these entries look.

Hope this helps.
Adam.

[krishdw85]

NO, attachment was from csv .. in excel it is coming in one row\alignment whereas in csv format only it is taking left right.
in notepad it is not aligned perfectly and users expecting this to be aligned in a proper order in csv format whereas pdf,excel is it coming fine.

[dougp]

adam is correct.  Excel doesn't know how to handle a CSV file.

Are you saying it's too difficult for the user to select the column and click the left-align button?

[krishdw85]

May be he want that to be done from cognos end rather than manually

[adam_mc]

Cognos has NO control about how Excel formats the data.

To confirm this is an Excel issue, just go and manually create a text .csv file with the following columns:
123
AB
456
X
12

The columns are nicely aligned in a text editor.
However, when you open the file with Excel and you will see the Text values left aligned, numbers right aligned.

This is not a Cognos issue.

Thanks,
Adam.

[dougp]

Maybe the problem here is the report does not meet the user's needs.  If the report provided everything the user needed, there would be no reason to use Excel.

I know it's difficult, but try getting the user to tell you what questions the report is intended to answer.  Then complete the development of the report to answer those questions.  ...and maybe that will mean more than one report, or multiple pages in one report.