Jump to content

Duplicate Records in a Report


Andrea Packham
 Share

Recommended Posts

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 

image.png.84efecc86abf576d0180ef60adb3f5c1.png

The columns are

 

image.thumb.png.e748d83593c59515bccf395bb34e22f4.png

The filter is 

 

image.png.70cb6a12e78a524db3d13c20f412ae37.png

 

 

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?

open calls.PNG

image.png

Link to comment
Share on other sites

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...