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
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Can you define bitmap index?
how can you get the errors in job? when loops are araised we get error?
What do you understand by the term 'aggregate advisor?'
what is catalog and types of catalogs in cagnos and which is better?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Which studio is used to create reports?
---------------Tell me about DWH Concepts?
What is the difference b/w macros and prompt?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
----------------Diff b/w Dimensional modeling and Relational modeling?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is meant by drill down?
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.