Display n # of rows in report.

[2001 JI Open Discussion]

By: Keith Berman - bobbassen

Display n # of rows in report.

2002-10-29 12:30

Is it possible to display only a subset of the rows from a result set based on a parameter. For example, my result set has 1000 rows but I only want to show the first 100 in the report. I was planning on passing the number of rows in as a parameter and then using a count variable to compare against that parameter using the printWhenExpression.

 

Is there an easier way?

 

Thanks in advance!!

 

 

By: Teodor Danciu - teodord

RE: Display n # of rows in report.

2002-10-29 13:14

 

Hi,

 

I don't see an easier way or any other way at all.

 

Good luck!

Teodor

 

 

 

By: Alex Parfenov - aparfeno

RE: Display n # of rows in report.

2002-10-29 13:33

In informix, I can insert 'first XXX' into my select statement like so: 'select first 100 sku,desc, ... from product where ...' thus limiting number of records brought back. I am not sure if such device exists in Oracle or MS-SQL. If your database supports it, I believe you can use JR's query arguement to embed your MRW right into the query (I think the JR syntax might me slightly different since you are not passing a whereClause parameter, but simply a part of the SQL query). If this is possible in your situation, this solution would be much more efficient since you are not going to pull unnecessary rows from database.

 

 

By: Keith Berman - bobbassen

RE: Display n # of rows in report.

2002-11-05 12:57

It does exist but I think it will slow down the processing and make are SQL retrieval less efficient.

 

One problem with only printing the first n rows on my report is that the remaining rows that are not printed still add a blank line to the report. This causes my summary to appear many lines after the results I have displayed. Is there any easy way around this. If not, I think I can move my summary info into the detail area and try to print it 1 time, after my nth row has printed.

 

 

By: Teodor Danciu - teodord

RE: Display n # of rows in report.

2002-11-05 13:07

 

Hi,

 

Have you seen that you have

<printWhenExpression>

also at band level.

In newer versions, of course.

 

The blank should not appear if you remove

the entire report band and not each and every

element on that band.

 

Still, the blank space could also be removed

if you set isRemoveWhenBlank="true" to all

of them.

 

Thank you,

Teodor

 

 

 

By: Teodor Danciu - teodord

RE: Display n # of rows in report.

2002-11-05 13:09

 

Sorry, I meant

 

isRemoveLineWhenBlank="true"

 

Teodor

 

 

 

By: Keith Berman - bobbassen

RE: Display n # of rows in report.

2002-11-05 13:07

I found the isRemoveLineWhenBlank="true" option, that handled it, thanks!!