Summary Fields
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22409
Printed Date: 03 May 2024 at 10:24am
Topic: Summary Fields
Posted By: aqrnl
Subject: Summary Fields
Date Posted: 09 Aug 2017 at 3:14am
I have a report that is supposed to list all the records that have both a "WCP" and a "PPU" code. I added the following Group Selection Formula: Count ({incident_rprt_problem_subcode.problem_subcodes}, {incident_report.incident})=2
Among other conditions the Select Expert shows this: {incident_rprt_problem_subcode.problem_subcodes} in ["PPU", "WCP"]
I have a group for each {incident_report.incident} which includes the fields of the report. I suppress the detail section. The report correctly list the necessary data but shows the report total wrong. The report total includes records with either a "WCP" or a "PPU" code, not just those with both. What do I need to do to get the report totals to be correct?
|
Replies:
Posted By: DBlank
Date Posted: 09 Aug 2017 at 6:40am
I am not sure you are getting to what you want as you would need to group by whatever is considered a "group" and need two formula fields to see if they have both WCP and PPU in that group.
This would be used as a group select.
from there you should be able to use running totals as they should execute after the group select occurs.
The summary types execute before the group select process (allowing the report to use group select criteria at all).
|
Posted By: aqrnl
Date Posted: 10 Aug 2017 at 5:32am
|
The running totals did work. Thank you.
|
|