Kim Williamson
asked on
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
Field is completedqty. How could I do this?
assembly.jpg
ASKER
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.
ASKER
Yes, I need to figure out the formula for the last process step. that is what I am asking for help with.
How do you calculate the qty?
How do you know it is the last step?
How is the report grouped?
mlmcc
How do you know it is the last step?
How is the report grouped?
mlmcc
ASKER
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
1
2
3
the qty comes directly from the table correlated to the sequence step
the report is grouped by workorder
Is it always step 3 or does it vary based on the workorder?
mlmcc
mlmcc
ASKER
it varies based on the workorder. that's why i need it to pull the last sequence.
I don't think you can get it to the top then unless you use a subreport
mlmcc
mlmcc
ASKER
Any other ideas. A subreport really will not work.
Can you sort in the other order?
Otherwise there is no way
mlmcc
Otherwise there is no way
mlmcc
ASKER
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.
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
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
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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