Problem: unwanted rows appended (query retrieve data multiple times)

[davide.canalia]

Hi,
I have just installed JasperServer Community on my CentOS.
I have addded MSSQL datasource /MS drivers)

And i have deployed my first test report.

I have a problem: the data rows are retrieved multiple times (as if i call "select" again and again).

The select is very simple:

SELECT FIELD1, FIELD2, FIELD3, FIELD4 FROM DBO.MYTABLE ORDER BY FIELD1

The Table as 110 rows, if i call the report with that query i get 853 pages!

If i add TOP 1, ie:

SELECT TOP 1 FIELD1, FIELD2, FIELD3, FIELD4 FROM DBO.MYTABLE ORDER BY FIELD1

I get the right pages (8)

And if i add TOP 2, ie:

SELECT TOP 2 FIELD1, FIELD2, FIELD3, FIELD4 FROM DBO.MYTABLE ORDER BY FIELD1

 

I get twice the data (16 pages)... 

I cannot understand what it is happening!

 

Please help me

 

[mcota_1]

Please note that if you are using for example a table element in the detail band, The detail band will repeat itself for every single read record.

Example: if you have a query that returns 2 rows, the detail band will run twice. If you insert a table element in the detail band,
then you will get 2 identicial tables with the same values.

Refer to the Jaspersoft Studio User Guide.