Andrea Packham Posted October 7, 2022 Share Posted October 7, 2022 I am not very experienced in writing reports, but have copied another report and amended to get a list of open calls by analysts who work across different teams,. The report has run but is listing the same call reference a number of times and I am not sure why. The tables used are The columns are The filter is Everything works as I want apart from duplicate records - I have attached a screen shot of the part of the reports - Does anyone have any ideas why? Link to comment Share on other sites More sharing options...
NeilWJ Posted October 9, 2022 Share Posted October 9, 2022 Hi Andrea, It might be because you are reporting off 3 tables and haven't setup table joins. What are the table joins In the view where you setup the tables and select columns? (if you select any of the secondary tables it should show join filter) Cheers, Neil 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