CODEWITHSUNDEEP
crystal-reportscrystal-reports-2011
John Janssen
John Janssen

Reputation: 323

Crystal Reports distinct values in Report Footer

I created a report that has a field for transcode in the details portion. Transcode can have different values,

R, OT, H, or V

I would like to display this in the report footer for each of my transcodes with the total count of each

For example the line below is how I would like my output:

R      15           $Amount
OT      7           $Amount
H       9           $Amount
V       2           $Amount

There are some instances where some of these transcodes won't exist in the details section so it could just be R and OT and no H or V.

Is there a way I can do this without creating a variable for each of the transcodes?

Upvotes: 0

Views: 1403

Answers (1)

craig
craig

Reputation: 26262

If you want it to be dynamic, add a cross-tab object to the report footer:

enter image description here Add the transcode field to the Rows section.

enter image description here Note the Summarized Field settings.

Otherwise, you could create 8 running-total fields: 4 for the counts and 4 for the amounts:

enter image description here

  • Set Field to summarize and Type of summary to the desired values
  • Set On change of field to transcode.

Upvotes: 1

Related Questions