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!
Answers were Sorted based on User's Feedback
Answer / 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 |
Hi Ramesh, I suggested this option to the business but they
are not comfortable with this options like every row they
have to double click and see the values......
Do we have any option in Cognos 8 with which we can get
these long texts values in wrap format?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
which cognos version are u using to create the report and
which version of Ms-Office is your user used to view the
report? The cognos version doesn't support the MS-Excel version.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / am
GO to your Governor Settings and increase BLOLB text limit!!
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is Cardinality
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
Can we install cognos on windows 7?
what is the use of macros&folders&herarchies in frameworkmanger?
if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............
What is a dashboard in Cognos Report Studio and how do we creae it
Explain the different types of views used in cognos.
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
Tell me about Dnamic and Static Dashboards?
How you drill from powerPLay to Impromptu?Explain all Steps?