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!
- 5 Answers
- 6220 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
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 is Direct and Conventional loading?
Define query studio?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What are the different types of reports present in cognos?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Explain what is the difference between native sql and cognos sql?
Can you define slice?
What is Bitmap Index?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
is cognos 7 is better than cognos 8
What is the difference between drill through, drill across?
What do you understand by ‘ibm predictive maintenance and quality’?
What is meant by junk dimension?
how can you get the errors in job? when loops are araised we get error?
What is the complex report you faced in real time?
