Jaspersoft Community 'Read-Only' as of July 8, 2022
Transition to New TIBCO Community Just Weeks Away
You can still search, review wiki content, and review discussions in read-only mode. Please email firstname.lastname@example.org with questions or issues requiring TIBCO review or response.
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