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

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

Crystal Reports

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
Kim Williamson
Asked:
Kim Williamson
  • 7
  • 7
1 Solution
 
mlmccCommented:
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
 
Kim WilliamsonSystems AdministratorAuthor Commented:
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
 
Kim WilliamsonSystems AdministratorAuthor Commented:
Yes, I need to figure out the formula for the last process step.  that is what I am asking for help with.
0
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
mlmccCommented:
How do you calculate the qty?

How do you know it is the last step?

How is the report grouped?

mlmcc
0
 
Kim WilliamsonSystems AdministratorAuthor Commented:
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
 
mlmccCommented:
Is it always step 3 or does it vary based on the workorder?

mlmcc
0
 
Kim WilliamsonSystems AdministratorAuthor Commented:
it varies based on the workorder.  that's why i need it to pull the last sequence.
0
 
mlmccCommented:
I don't think you can get it to the top then unless you use a subreport

mlmcc
0
 
Kim WilliamsonSystems AdministratorAuthor Commented:
Any other ideas.  A subreport really will not work.
0
 
mlmccCommented:
Can you sort in the other order?

Otherwise there is no way

mlmcc
0
 
Kim WilliamsonSystems AdministratorAuthor Commented:
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
 
mlmccCommented:
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
 
Kim WilliamsonSystems AdministratorAuthor Commented:
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
 
mlmccCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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