AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Report Data Isn't C...
 
Notifications
Clear all

Questions Report Data Isn't Correct/Complete

 
Acumatica Report Designer
Last Post by Tim Rodman 6 years ago
2 Posts
2 Users
0 Reactions
1,374 Views
RSS
paulsw
Posts: 12
 paulsw
Topic starter
April 3, 2020 5:02 pm
(@paulsw)
Eminent Member
Joined: 6 years ago

I am looking for a new set of eyes to help me determine why my report is not giving me a complete data set.

I have attached what I have so far. Note that not all of the totals are configured yet. This is because I don't have the full data set coming in and I will fix the totals later.

The report is based off 'Employee Hours by Project and Task' (PM623000) with modifications. I have cross-referenced the table joins with 'Employee Hours' (PM622000) to check that joins are not where my issue is.

The issue is this:

When I filter for one employee I get that employee's data but when I ask for all employees or a small range of employees I get a single employee's data.

I don't see why this is happening so that's the assistance I am looking for. Can someone else see where the issue is?

 

Thank you!

Paul

 

pm623000.rpx

 


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
May 21, 2020 9:08 pm
(@timrodman)
Famed Member
Joined: 10 years ago

It doesn't look like you're using any Parameters on the Filters tab so I don't think your Parameters are doing anything.

If you have a Company Tree in place, that might be why you are experiencing filtering.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 5 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×