MikeM19 Posted October 2, 2015 Share Posted October 2, 2015 Hello,I just created a new report, includes 3 table elements with a different dataset with different querys, the 3 tables fields are totally aligned so when i make the excel exportation appers fine, each field on one column for the 3 tables, the problem i'm facing now is that there are some duplicated rows because the 3 database tables have some repeated values and i understand is natural to happen this, but there is anyway to avoid that? i mean how can i be sure that the report does not print duplicated values? any validation? i already tried with the print repeated values but is not working, i hope any of you guys can give a hand here.Regards! Link to comment Share on other sites More sharing options...
hozawa Posted October 2, 2015 Share Posted October 2, 2015 If you are using 3 different dataset and queries, you'll probably have to consolidate them into one table, one dataset, and one query to make sure there aren't any duplicate values. Link to comment Share on other sites More sharing options...
Tarun Gupta Posted October 3, 2015 Share Posted October 3, 2015 Hey,,u try DISTINCT in ur query ,,,,,,i think its working,,,,,, Link to comment Share on other sites More sharing options...
MikeM19 Posted October 6, 2015 Author Share Posted October 6, 2015 Thanks again hozawa, i just did that and it works.Regards! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now