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 community@tibco.com with questions or issues requiring TIBCO review or response.
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
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.