nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sorting in Table

mh10

Hi,
I have column with vlaues

ABC 1
ABC 2
ABC 3
.
.
.
.
ABC 10

I have inserted group in table on this column. and i am looking to display group details in order as it is with above column values. so i put sort key on this column as ascending..

but it shows group details with

ABC 1
ABC 10

I WANT "ABC 10" group detail at last position
ABC 2
ABC 3
.
.
.
ABC9

Any suggestions?

Find more posts tagged with

Comments

bhanley

This is a problem with all alphanumeric sorts. The sorting engine in BIRT can handle this without a lot of additional work on your part. You need to make one change to your data (if possible). 
 
Right now your data look like this: 
 
<blockquote class='ipsBlockquote' >ABC 1 
ABC 10 
ABC 2 
ABC 3</blockquote>
 
If you can change them to read in the following format, they will sort correctly without any more scripting work for you: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>ABC 01
ABC 02
ABC 03
ABC 10</pre>
 
BIRT (and JavaScript for that matter) can successfully deal with the alpha numerics if the strings and numbers are consistent. This example will work for numbers through 99. If you need higher values, add more elading zeros. 
 
I have attached a sample where I add a comuted column to the data saet with alpha-numeric values and then sort by that column. Look at the expression building the computed column to see how to padd the numeric portion of the column value with the required leading zeros. 
 
Hope this helps, good luck!

mh10

Thanks bhanley, 
It worked with 01, 02, 03......10 
 
 
 
<blockquote class='ipsBlockquote' data-author="bhanley">This is a problem with all alphanumeric sorts. The sorting engine in BIRT can handle this without a lot of additional work on your part. You need to make one change to your data (if possible). 
 
Right now your data look like this: 
 
 
 
If you can change them to read in the following format, they will sort correctly without any more scripting work for you: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>ABC 01
ABC 02
ABC 03
ABC 10</pre>
 
BIRT (and JavaScript for that matter) can successfully deal with the alpha numerics if the strings and numbers are consistent. This example will work for numbers through 99. If you need higher values, add more elading zeros. 
 
I have attached a sample where I add a comuted column to the data saet with alpha-numeric values and then sort by that column. Look at the expression building the computed column to see how to padd the numeric portion of the column value with the required leading zeros. 
 
Hope this helps, good luck!</blockquote>