[REPORT_COUNT not counting logically]

I'm using the $V{REPORT_COUNT} function in iReport to generate row numbers per ID, but when an ID has more than one Value it is using the rows to add to the row count giving the current output below.

 

Current Output

 

Row Number	ID	Value
1	23	A
2	65	N
3	89	P
4	34	B
		Q
		A
7	77	B

 

 

 

 

 

 

 

 

 

 

 

 

 

I want the output to be like the below with each row number only incriminating by ID

 

$V{REPORT_COUNT} Settings

 

Print Repeated Values is TRUE

 

Evaluation Time is NOW

 

Desired Output

 

Row Number	ID	Value
1	23	A
2	65	N
3	89	P
4	34	B
		Q
		A
5	77	B

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[$F{FIELD} Jaspersoft iReport Return one value only]

Yeh thats what im hoping someone can tell me as i dont know the equivalent statements when using $F{Field} etc

[$F{FIELD} Jaspersoft iReport Return one value only]

Im not using SQL in this

[$F{FIELD} Jaspersoft iReport Return one value only]

Its already in its own band,

 

What query do i need to use to achieve this

[$V{REPORT_COUNT} start at 1]

JasperReports iReport $V{REPORT_COUNT} is starting at 0 instead of 1

How can i make it start at 1 rather than 0

I think this is a setting in th properties but not 100% sure, may be in the XML

[$F{FIELD} Jaspersoft iReport Return one value only]

When using $F{FIELD} in Jaspersoft iReport, i want to return one value only (the first value).

Whether this is used in the 'Print when expression' or in the 'Text field expression' i don't know.

[Help, cant post, saying Your submission has triggered the spam filter and will not be accepted.]

Im having the same issue