As a beginner I have tried to create a report, grouped by employee, that requires data from a sub-report. The sub-report data has to be added to data in the main report. I then wish to sum the calculated field, to give a total by employee. Using shared variables I have managed achieve most of this except that the formula field that sums the calculated field is displayed next to each record. I want just the employee total to show.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running total of calculated field - can I show final figure only? 1
- Thread starter tonuptone
- Start date
-
1
- #2
synapsevampire
Programmer
A lot of assumptions are required here as you didn't post technical information.
Please post:
Crystal version (in any software post, state your version)
Database/Connectivity used
Example data
Expected output
Keep in mind that subreports are generally a bad idea because they're slow, so stating the above might demonstrate another architecture which doesn't require subreports, and will certainly help people to provide assistance.
"I have managed achieve most of this except that the formula field that sums the calculated field is displayed next to each record. I want just the employee total to show. "
Did you group by employee?
Assuming that people will know your report layout will simply result in a wave of additional posts, please state specifics.
Group the main report by employee.
Righ click the group footer and select Insert section below
Place your subreport in Group Footer A
In the Group footer b you can display the results using shared variables.
-k
Please post:
Crystal version (in any software post, state your version)
Database/Connectivity used
Example data
Expected output
Keep in mind that subreports are generally a bad idea because they're slow, so stating the above might demonstrate another architecture which doesn't require subreports, and will certainly help people to provide assistance.
"I have managed achieve most of this except that the formula field that sums the calculated field is displayed next to each record. I want just the employee total to show. "
Did you group by employee?
Assuming that people will know your report layout will simply result in a wave of additional posts, please state specifics.
Group the main report by employee.
Righ click the group footer and select Insert section below
Place your subreport in Group Footer A
In the Group footer b you can display the results using shared variables.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question