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

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

-------------How to create a PortalTab?

1 Answers   Cap Gemini,

If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?

2 Answers   IBM, Polaris,

HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

4 Answers   IBM, TCS,

what is the difference between group span and level span

1 Answers   Satyam,




Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

0 Answers   TCS,

what is cube size?

4 Answers   IBM,

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

0 Answers  

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

0 Answers   CTS,

When we save a report in report studio with what extn it save?

0 Answers  

Is cognos models are version compatible?

2 Answers  

what is the difference between group and association?

5 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories