Hi Techies, I got an issue so need your advice here.
I have created a report in Report Studio and it's having 2
columns which are having long text as a value (BLOB data
type). Report is displaying entire text items in HTML
format, but when I'm exporting it into EXCEL it's give me
##########. How to correct (wrap) it in Excel? so when end
users they are directly running that report in Excel so
instead of seeing ######### for long text items they should
see the entire text items in those columns. Please advice!

Answer Posted / samir kumar

Just set the column proprty in properties pane to No wrap.
It'll display the full data without the hashesh.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different uses of a repository manager?

684


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1641


What are all the advantages of Cognos?

713


What do you understand by the cognos?

620


What is meant by junk dimension?

658






Can you define confirmed dimension?

715


What is the difference between a cascading report and drill through report?

744


Can you define report item?

669


explain how to create powerplay reports?

688


how u will determine the performence tune will occur either in report or system

1778


What is the complex report you faced in real time?

1814


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

1966


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2222


hi my name is siraj i want to know cognos queriy language

1912


Cleared COG-112 with 100% score today. What next certification should i go for?

1513