Display row numbers

2
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.

oturan_'s picture
11
Joined: Aug 6 2006 - 9:11pm
Last seen: 12 years 7 months ago

4 Answers:

3
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
giulio's picture
18796
Joined: Jan 2 2007 - 4:15pm
Last seen: 1 month 1 week ago

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

sivesh - 4 years 2 months ago

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

rookielector - 6 months 3 weeks ago
0
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)
chetan_33's picture
Joined: Jul 20 2006 - 5:41pm
Last seen: 5 years 2 months ago
0
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
giulio's picture
18796
Joined: Jan 2 2007 - 4:15pm
Last seen: 1 month 1 week ago
2
Hi Print the variable $V{REPORT_COUNT} in a textfield with class type Integer and evaluation time now or band.
harinderrakkar's picture
Joined: May 5 2009 - 3:27am
Last seen: 6 years 1 month ago
Feedback
randomness