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 / dramesh511

In excel format you simply double click on the that value
place then u get result.




ragards,
ch.ramesh

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is called a slice?

664


What are the advantages of shortcuts?

618


What are the considerations regarding performance kept in mind while setting up cognos?

651


What is main advantage datawarehousing over oracle?

635


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

744






2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1808


What are the types of studio?

788


What do you understand by the term 'aggregate advisor?'

630


How can I schedule reports in cognos?

671


What is Metrics designer?

680


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1761


Explain difference between powerplay transformer and power play reports?

639


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1871


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

656


What are the steps to import the two data sources in framework manager?

690