Crystal Reports: suppress value and display a different value

[former_member548403]

I am not entirely sure if this is possible, but I am working on a report that has a cross-tab to show people (row), courses (column), and the percentage of the course completion for each person. The value for the completion percentage is good, but the total percentage number at the end of the column is off.

So I want to suppress what is currently showing under the Total column, and display something else (a different value from a different formula). Is this possible?

[DellSC · Accepted solution]

Yes, it might be possible. However, you'll have to do it as a total within the cross-tab instead of a separate formula that you create in the report instead of in the Cross-tab.

- Right-click on your current total field in one row.

- Select Embedded Summary >> Insert Embedded Summary

- Right-click on the new {@EmbeddedSummary} formula that appears below your current total.

- Select Embedded Summary >> Edit Embedded Summary

- Edit the formula. You'll need to refer to other cells in the row where the total is located using the functions found in the "Grid Value" category in the list of functions in the Formula Editor.

-Dell

[former_member548403 · Accepted solution]

Hi, Dell. Thanks for the comment. If it has to be done within the cross-tab, then I am not sure if it will work because the other values are correct. I'm going to close the question, and post a new one and see if this can be done another way. Thanks!