When I create an Ad-Hoc report, to display all ports, with more than 60 days idle, why does Jaspersoft show the same interface, multiple times, with different values for the ?Total Days Idle??

Document ID : KB000015335
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

When I create an Ad-Hoc report, to display all ports, with more than 60 days idle, why does Jaspersoft show the same interface, multiple times, with different values for the “Total Days Idle”?

Environment:
Jaspersoft 6.3Spectrum 10.2Spectrum 10.2.1
Answer:

Report Manager contains all historical data, so it is possible that you will have the same interface duplicated, if the device or interface was previously destroyed and remodelled.

If you do not want this information, you can add a filter in your Jaspersoft Ad-Hoc report.

“Destroy Time” Equals  <empty value>

 

This filter when used will list all interfaces, that do not have a destroy time listed, and you will receive only the current interface in your report.