Solved

Crystal Reports 10 - how to summarize data across groups and make available to all groups

Posted on 2004-09-13
Medium Priority
269 Views
I have a reports with the following group structure:

Chain - Group 1
Rep - Group 2
Due Date - Group 3

A rep can belong to more than one chain.  I need to know how many chains the rep belonged to at a particular due date to and then make that total it available to a formula in the due date group.

For example, Rep A services Chain 1, Chain 2 and Chain 3 on due date 7/1.  I need to get the value 3 into a formula in the due date group so I can divide a total amount by that number to share costs across all chains the rep serviced in that due date.
0
Question by:kristenhazard
[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
• 2
• 2

LVL 101

Expert Comment

ID: 12050440
I am nt sure if it can be done easily.  How many Reps?

It might make more sense for this report to group it differently.

mlmcc
0

LVL 28

Accepted Solution

bdreed35 earned 2000 total points
ID: 12053817
You could do this using a subreport and a shared variable.

Your subreport would need to get the total amount by rep.
When you add it to the main report, link on rep id (perhaps other fields as well), and then place the subreport in the Group 2 (Rep) Header.  It would be a good idea to create a second Group Header 2 section and place the subreport in section b.
Your subreport is there just to perform a calculation and to provide that value back to the main report.

The next step would be to create several formulas.

1. @Init - Place it in Group Header 2b - Main Report
shared numbervar rep_amount := 0;

2. @Set - Place it in Subreport Report Footer.
shared numbervar rep_amount := count({table.chainid}); //you may be counting a different field here

Now, you can reference the shared variable in your own calculations in the main report to determin that share costs.
0

Author Comment

ID: 12055621
Thanks bdreed35, I'll give that a try.
0

LVL 28

Expert Comment

ID: 12244404
I believe I offered a suitable solution, but the poster never responded back.
0

Author Comment

ID: 12244474
OK, I was not finishing the accept process in the second page. I have now accepted bdreed35.  Sorry for the mix up.
0

Featured Post

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month14 days, 16 hours left to enroll