Rownum for sorted crosstab
Posted 10 March 2012 - 11:17 AM
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!
Posted 12 March 2012 - 11:48 AM
Posted 12 March 2012 - 12:32 PM
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
Posted 12 March 2012 - 12:58 PM