Solved

Crystal Reports

Posted on 2014-01-29
14
263 Views
Last Modified: 2014-02-24
I have a report that I want to be able to put the qty complete from the last seq step of the information into the header for a completed field.  See attached.  I have 2 process steps - I want to put the qty complete up next to the final assembly, but it has to be the last sequence in the process.  

Field is completedqty.  How could I do this?
assembly.jpg
0
Comment
Question by:delta1734
  • 7
  • 7
14 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39818374
How do you know it is the last step?

Just to make sure I understand what you want,
  The picture has 1400 highlighted in yellow.  It is in what appear to be 2 groups
  I assume you want it to appear only once.
  You could conditionally suppress it with a formula like
     Not LastStep

You just need to be able to determine the formula for LastStep

mlmcc
0
 

Author Comment

by:delta1734
ID: 39818539
Not exactly.  I want to take the qty report from the last step and put it up next to the final assembly qty on the top.  But I need it to be from the last process step.
0
 

Author Comment

by:delta1734
ID: 39818544
Yes, I need to figure out the formula for the last process step.  that is what I am asking for help with.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39818699
How do you calculate the qty?

How do you know it is the last step?

How is the report grouped?

mlmcc
0
 

Author Comment

by:delta1734
ID: 39818704
It is the last step because of the sequence number.  Each sequence has a number
1
2
3

the qty comes directly from the table correlated to the sequence step
the report is grouped by workorder
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39818721
Is it always step 3 or does it vary based on the workorder?

mlmcc
0
 

Author Comment

by:delta1734
ID: 39818830
it varies based on the workorder.  that's why i need it to pull the last sequence.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 100

Expert Comment

by:mlmcc
ID: 39819249
I don't think you can get it to the top then unless you use a subreport

mlmcc
0
 

Author Comment

by:delta1734
ID: 39843655
Any other ideas.  A subreport really will not work.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39843697
Can you sort in the other order?

Otherwise there is no way

mlmcc
0
 

Author Comment

by:delta1734
ID: 39844182
No I cannot sort in any other method. And it really isn't a sorting issue.  What I need to do is pull a field qty in  the last sequence in the detail to the group level.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39844207
Is there any identifier that makes it the last record?

I don't know why you think a subreport will not work
All it needs to do is filter to get the records for that group (just the field in question) and display the last value in the report footer
The rest of the subreport can be suppressed

The problem is with the way Crystal works, the group header is built long before the last record in the group is processed and the report can't return to it.

mlmcc
0
 

Author Comment

by:delta1734
ID: 39844233
the sequence of the process is the identifier that makes it the last record.
I guess I didn't understand what was previously meant by doing a subreport.  I thought it would require me to rebuild the entire detail section.  I can try that.  Can you give me some guidance as I haven't worked with subreports too much.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39844424
A subreport is just like any other report.

You could duplicate the one you have and delete everything except the field you need and the selection criteria

Put the field you need in the report footer on the left margin
Save the subreport under a new name myReport_sub

Insert the subreport into the main report
   Click INSERT --> SUBREPORT
    Choose to use an existing report
    Navigate to the report you just saved
    Select it and click open
    Link it to the main report on the group value (Workorder)
    Place it on the main report where you want it.
     You can resize it

mlmcc
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 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

15 Experts available now in Live!

Get 1:1 Help Now