How to use a general variable on a crosstab?

[gabrielmatosdesouza]

Hi Guys!

 

I have a Crosstable element on my report and no detail band whatsoever.

Now i need to have a num_line on each element of my crosstable, but they are in a group like this: 

 

I need to put a count variable in the beginning of each of those rows, but a simply cant with SQL, so i'm trying with ireport but i can't do it do.

I get really close when i created a variable called counter with those properties:

Name : count

Variable Class: Integer

Calculation: Distinct Count

Reset Type: None

Increment type: Column

Variable Expression: $F{cod_aluno}

 

If i add the datail band and put the count variable into, i can use that variable in my crosstable normally.

If i hide the datail band the variable value inside crosstable keep showing '1' instead of 1,2,3,4,5....

 

Guys i nearly trying anything i could, done much research but had no success at all.

Obs.: I tried to just make a field on SQL but my postgres version is 8.2, so i don't have functions like row_num(), generate_series, etc.

 

Please help. Thanks in advance.

[gabrielmatosdesouza]

I finally figured that out!!

 

You just need to use a variable called $V{ROW_COUNT} and thats done :D

 

Thanks all anyways.

[gabrielmatosdesouza]

I finally figured that out!!

 

You just need to use a variable called $V{ROW_COUNT} and thats done :D

 

Thanks all anyways.