[bitec2]

Hi.
I have the crosstab which is sorted by total column like in the screenshot:



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):



Any help appreciated!

[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]

mwilliams, on 12 March 2012 - 11:48 AM, said:

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.

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.



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.