Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Reports XI duplicate rows

Posted on 2014-01-02
5
Medium Priority
?
545 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 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

If you are like me and like multiple layers of protection, read on!
I originally wrote this article to compare SARDU and YUMI, but have now added Easy2Boot, since that is the one I currently use and find the easiest to create and alter.
Viewers will learn how to use the Hootsuite Dashboard.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

963 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