Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Crystal Reports

Posted on 2014-01-29
Medium Priority
273 Views
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
Question by:Kim Williamson
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 7
• 7

LVL 101

Expert Comment

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

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

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 101

Expert Comment

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

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 101

Expert Comment

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

mlmcc
0

Author Comment

ID: 39818830
it varies based on the workorder.  that's why i need it to pull the last sequence.
0

LVL 101

Expert Comment

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

mlmcc
0

Author Comment

ID: 39843655
Any other ideas.  A subreport really will not work.
0

LVL 101

Expert Comment

ID: 39843697
Can you sort in the other order?

Otherwise there is no way

mlmcc
0

Author Comment

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 101

Expert Comment

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

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 101

Accepted Solution

mlmcc earned 2000 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

Question has a verified solution.

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

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. â€¦
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater â€¦
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: â€¦
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrasâ€¦
###### Suggested Courses
Course of the Month7 days, 15 hours left to enroll