Summary as a percentage
I have found it very useful to include the summary percentage
in cross tab reports. What we would like to accomplish is to show what
percentage the total product cost is for each product for each customer.
1.
Right click on the cross tab and select “Cross-Tab Expert”.
2.
Select the “Order_Details.UnitPrice” field and add it to the “Fields to Summarize”
collection.
3.
Click on the newly added "Order_Details.Unitprice” item and click
“Change Summary” button.
4.
Ensure that “Sum” is selected for Calculate this summary.
5.
Check the “Show as percentage of” check box is checked.
Figure 9: Summary as percentage
Vertical text
To save space on cross tabs you have the option to make the
text display vertically instead of horizontally. In this example we will change
the headers of the cross tab to display vertically. Web disclaimer - currently
text will not render vertically if using the Crystal Reports Web XI or lower viewer
control.
1.
Right click on the “Column #1 Name” field and select “format field”.
2.
Select the “Common” tab.
3.
Set the value to 90 in the “Text Rotation box".
Figure 10: Vertical Text
Repeat the steps above for the “Total” header field.
Text Highlighting
The data presented in the cross tab we have created is very
clean and easy to read, but sometimes it’s nice to be able to highlight certain
areas of interest in the report. Let's add a requirement to highlight product
totals that are over $30.00.
1.
In “Row #2”, right click on the “Order_Details.UnitPrice” field and
select “Hightlighting Expert”.
2.
Click the “New” button.
3.
Set the “Value Of” to “this field”, “Is greater than” and “$30.00”.
4.
Set the Font color to red.
Figure 11: Highlighting Expert
Figure 12: Report with Vertical Text and
Highlighting
