Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

Crystal Reports XI duplicate rows

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
mebaby333
Asked:
mebaby333
  • 3
  • 2
1 Solution
 
mlmccCommented:
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
 
mebaby333It AdminAuthor Commented:
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
 
mebaby333It AdminAuthor Commented:
it is giving me just the max date not the max date based on the item #
0
 
mlmccCommented:
YOu need to specify the group in the max

Max({YourDateField},{YourGRoupField})

mlmcc
0
 
mebaby333It AdminAuthor Commented:
Thx!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now