Solved

Crystal Reports XI duplicate rows

Posted on 2014-01-02
5
535 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
  • 3
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
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
Comment Utility
it is giving me just the max date not the max date based on the item #
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
YOu need to specify the group in the max

Max({YourDateField},{YourGRoupField})

mlmcc
0
 
LVL 5

Author Comment

by:mebaby333
Comment Utility
Thx!!
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now