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
Kim WilliamsonSystems AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.