1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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!

Question Posted / shah

Answers were Sorted based on User's Feedback



Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and i..

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 Techies, I got an issue so need your advice here. I have created a report in Report Studio and i..

Answer / shah

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

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and i..

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

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and i..

Answer / am

GO to your Governor Settings and increase BLOLB text limit!!

Is This Answer Correct ?    0 Yes 0 No

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and i..

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

Post New Answer

More Cognos Interview Questions

How can we find out cardinality between two tables?

3 Answers   Dominion,

what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

2 Answers   IBM,

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

Interval Prompt's Usage? Example for usage in Project

2 Answers   Cap Gemini,

----------------Describe DWH Architecture?

0 Answers   Bank Of America,




How to create model and how to test model?

0 Answers  

What is the difference btw reportnet - Report studio and cognos 8 - Report studio

3 Answers   Dominion,

what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

0 Answers   Magna Infotech,

How to create a Left Outer Join in FM? Please explain.

2 Answers   Cisco,

How to crate cubes in transformer ?

3 Answers  

Can you define materialized view?

0 Answers  

what are summary filters? grouped filters?

3 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories