Display row numbers

[oturan_]

Hi,

 

I don't know if this question was already asked here, but is there any way that I can display the row number of the result set for the master report? And also in the crosstab section of the report?

 

Hoping for anybody's response for help.

 

Thanks and good day.

 

 

[giulio]

Print the variable $V{REPORT_COUNT} in a textfield with class type Integer and evaluation time Report.

 

If you print the crosstab in the summary you can pass this value as parameter to the crosstab (not tried).

 

Giulio

[chetan_33]

Giulio

Can this be used to do page breaks by number of records for display on HTML page in a crosstab or any other form(group,subreports,etc)

[giulio]

Printing a crosstab you have not on page break.

 

By record count you can create a group with an expression that changes every N records.

 

1. Create a variable: GROUP_EXP

type: Integer

calculation: Nothing

default exp: new Integer(0)

expr:

 

(($V{REPORT_COUNT}.intValue()%N) == 0) ? new Integer($V{GROUP_EXP}.intValue()+1) : $V{GROUP_EXP}

 

2. Create a group (i.e. N_GRP) and set $V{GROUP_EXP} as group expression.

 

GROUP_EXP will change each time N records are printed,

so each N records, a new group will be created. If you set in the group properties to start the group an a new page you get a page break each N records.

 

Giulio

[harinderrakkar]

Hi

Print the variable $V{REPORT_COUNT} in a textfield with class type Integer and evaluation time now or band.

[sivesh]

Hi Giulio,

 

I have created a variable in main report with variable class type as integer, calculation type as count, Reset Type as Report and Variable expression as REPORT_COUNT. And the same I have reffered from crosstab Report using new Measure variable. Still i'm not able to get serial number in crosstab.

 

Please help me to resolve this ,

 

Thanks in Advance

[rookielector]

Agregue la variable $V{REPORT_COUNT} y me asegure de evaluarla en el tiempo del Reporte y funciono. Gracias