My report output is showing data as 1 11 111 2 22 222 3 33 333 How can

My report output is showing data as
1
11
111
2
22
222
3
33
333
How can I sort this to
1
2
3
11
22
33
111
222
333

Question Posted / guest

1 Answers
3607 Views
I also Faced
E-Mail Answers

My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 ..

Answer / naveen

add another column of LENGTH of value then order by length,
column.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Cognos Interview Questions

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers

How do we run stored procedure?

1 Answers

how u will design the report if the objects are available

0 Answers Ness Technologies,

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 HCL, Wipro,

---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers Bank Of America,

Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers DELL,

how u create cubes in ur project

2 Answers IBM,

----------------------Diff b/w MOLAP and ROLAP?

4 Answers Bank Of America,

1.How to apply sorting to Crosstab report? If so please give me example? 2.How to create Report level Joins?explain with example?

2 Answers Cognizant,

What is model?