Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7617 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
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 |
Mention the difference between ‘macros’ and ‘prompt’?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
What is the use of report studio?
What is Additive function?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
What is the metric store database?
what is the difference between group and association?
What is Stich Query in Reportnet?
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.
what is the use of lock and unlock
Any Cognos planning Queries Rise
-------------Diff b/w Union and Unionall?
Teradata 
