Solved

Crystal Reports XI duplicate rows

Posted on 2014-01-02
5
539 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
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 100

Accepted Solution

by:
mlmcc earned 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report detail 15 51
FreeFileSync Batch Files 1 32
How to set up a video conference between two classrooms 8 36
internet fax? 7 19
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
This video shows how use content aware, what it’s used for, and when to use it over other tools.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

821 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