Custom reporting displaying multiples of the same information

I have created a custom report for our laptops and desktops, it includes Ship Date, Dell Service Tag, System Name, and User Logged. When I run the report the results include multiple lines for the same user (see screenshot). I would understand the results if there was different information to display but it's all the same. Why is it doing that and how do I get it to only display one result per user? (hashtags and asterisks are for privacy) 

Choices for the first step in the wizard (1st ss), then I checked the fields to display and chose the Column Order then the Sort and Breaks (2nd ss), lastly, I did not add any Filters.

2 Comments   [ + ] Show comments
  • did you use sql or the wizard to create. can you post the report itself the results do not help troubleshoot it - SMal.tmcc 1 year ago
  • I used the wizard. Does that make a difference? I will edit the post to include some of my choices. - hkroeger 1 year ago
    • it helps to know to answer for the wizard or sql - SMal.tmcc 1 year ago

Answers (1)

Answer Summary:
Posted by: SMal.tmcc 1 year ago
Red Belt

Top Answer

swap the device and dell warranty on the first page, choose tag from device, there can be multiple warranties and the ship date is tied to everyone.

  • if you export as pdf or csv like you did the ship date will be there visible also - SMal.tmcc 1 year ago
  • With this suggestion I was able to make adjustments and get what I needed. Thank you. - hkroeger 1 year ago
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ