Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal Reports XI duplicate rows

Posted on 2014-01-02
5
Medium Priority
?
543 Views
Last Modified: 2014-01-02
My manager has created a report and I created a report. I am now attempting to simply go into his report and link the tables so I can use my data on his report.
I added the view and linked it with a left Outer join since The info it is being compared to is in the from table.
I then take a field from my added view and create a max formula to find the last date an item was picked from inventory and when I add it to the report it duplicates rows but prior to me adding in the other view it did not.... Do I need to use a summary report or is there a detail I am missing?
0
Comment
Question by:mebaby333
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39751945
Since you are using MAX to get the last date an item was picked from inventory, there are multiple records for at least some of the inventory items.

To prevent this you will need filter the data so that only the records with the "MAX" dates are selected for the report.

You can do this by grouping on the item then displaying the information in the group header or footer.

mlmcc
0
 
LVL 5

Author Comment

by:mebaby333
ID: 39752001
I have moved the info into a Group, grouped by item number... and tried to use the MAXdate formula to find the last date picked and it only gives me one date throughout all the items...
0
 
LVL 5

Author Comment

by:mebaby333
ID: 39752006
it is giving me just the max date not the max date based on the item #
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39752028
YOu need to specify the group in the max

Max({YourDateField},{YourGRoupField})

mlmcc
0
 
LVL 5

Author Comment

by:mebaby333
ID: 39752053
Thx!!
0

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
If you're a modern-day technology professional, you may be wondering if certifications are really necessary. They are. Here's why.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question