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
