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

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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,533 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: 11 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,533 Topics
  • 11 K Posts
  • 43 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×