Solved

Crystal Reports

Posted on 2014-01-29
14
271 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: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
  • Learn & ask questions
  • 7
  • 7
14 Comments
 
LVL 101

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:Kim Williamson
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:Kim Williamson
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
LVL 101

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:Kim Williamson
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

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

mlmcc
0
 

Author Comment

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

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:Kim Williamson
ID: 39843655
Any other ideas.  A subreport really will not work.
0
 
LVL 101

Expert Comment

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

Otherwise there is no way

mlmcc
0
 

Author Comment

by:Kim Williamson
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

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:Kim Williamson
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

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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

615 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