Rownum for sorted crosstab

Hi. 
I have the crosstab which is sorted by total column like in the screenshot: 
 
<img src='http://img163.imageshack.us/img163/2823/crosstab.png' alt='Posted Image' class='bbc_img' /> 
 
I need to add the rownum column to the report. The sorting is done by Birt, not in sql, so seems I cannot add the computed column and change it in the "onFetch" event for dataset. I think some script is necessary when the crosstab is being built but my scripting knowledge is too poor so far

My crosstab definition is as following (I tried the computed column here): 
 
<img src='http://img841.imageshack.us/img841/820/reportr.png' alt='Posted Image' class='bbc_img' /> 
 
Any help appreciated!

Find more posts tagged with

Comments

mwilliams

You could simply put something like: i = 0, in your initialize script. Then, instead of trying to use your rownum field as a dimension, just put a 2 column / 1 row grid in where your name field is. Put the name field in the right cell and a dynamic textbox in the left cell. For the dynamic textbox expression, put i++; i;. Now, for each row, the variable i will increment and then display in the textbox, giving you a row number. Hope this helps. Let me know if you have questions.

bitec2

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97564" data-time="1331581686" data-date="12 March 2012 - 12:48 PM">
You could simply put something like: i = 0, in your initialize script. Then, instead of trying to use your rownum field as a dimension, just put a 2 column / 1 row grid in where your name field is. Put the name field in the right cell and a dynamic textbox in the left cell. For the dynamic textbox expression, put i++; i;. Now, for each row, the variable i will increment and then display in the textbox, giving you a row number. Hope this helps. Let me know if you have questions. </blockquote>
 
Marvellous! It works! Great, thanks Mike for you dedication

Small question: how can I restrict the widhth of the first cell in the grid so it was constant? I tried to put the width equal 20 px, but this didn't help. Either could not find the "width" property in style. 
 
<a class='bbc_url' href='http://imageshack.us/photo/my-images/834/report2b.png/'><img src='http://img834.imageshack.us/img834/6346/report2b.png' alt='Posted Image' class='bbc_img' /></a> 
 
I put thick borders just to show the variable width of cells

mwilliams

If you select the grid, then select the tab above the "rownumber" column, you should be able to set the width in the property editor and it should work. If it doesn't, let me know your BIRT version.