Duplicate values in the Jasper report

[akshay.vallabh]

Hi,

While genertaing the report in jasper reports we are getting duplicate values which are returned by the DB.Is there a way to get the distinct values?We tried the option of setting the summary as "countdistinct" in domain designer for all the columns but it did not work.Have attached a sample report screenshot.Here the values from 2nd row are reprated.Please help us know how to fix this problem.

 

 

Thank You,

 Akshay

[dnaboka]

I can see all the columns have duplicate values. But what if 5th row has COL1 = "AP8" and/or 4th row has DATEVAL = "Apr 31, 2013" for example. What do you expect to see?

You could try creating a derived table with distinct(COL1) syntax. Not sure the output will meet your needs though

[hozawa]

If you have access to the domain designer that is being used by the adhoc view, try modifying the sql to only return distinct value. Can't say anything more because you haven't provided any sql statement used to get the data.

 

There's also a "View SQL Query" icon on top of the Adhoc View that you can select to view the sql command being used to get the data.

[email_registration_dshRs5U]

If you have duplication records in your database or you want to do some data cleansing, you can always try TIBCO Clarity for free

Data Cleansing and Transformation Software

 

TIBCO Clarity is the data cleaning and standardization component of the TIBCO Software System. It serves as a single solution for business users to handle massive messy data across various sources,  applications and systems, such as database, cloud storage, TIBCO Jaspersoft, Spotfire, ActiveSpaces,  MDM, Marketo and Salesforce. TIBCO® Clarity makes it easy for business users to profile, validate, dedup, address cleansing, standardize, transform, and visualize data so that trends can be identified and smart decisions can be made quickly. TIBCO Clarity provides both on cloud version and enterprise edition version.