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

0

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

 
davide.canalia's picture
Joined: Apr 9 2014 - 2:06am
Last seen: 1 year 10 months ago

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.

 

 

mcota_1 - 4 years 11 months ago

0 Answers:

No answers yet
Feedback
randomness