Tuesday, May 12, 2015

Crystal Reports Show Value in Bar Chart

How to show a value in a bar chart in Crystal Reports, not a count.

The data source looks like this:
TermID Count Of Events

589
2148 402
2151 8238
2152 542
ldap_orgs 3
ms_rtr 6

By default, in Crystal Reports the report comes out looking like this.

We want it to look like this:
The solution:
1. Right click on the report. Choose report, formula workshop
2. Choose Formula Fields, and the add new button. Name the formula "ValueNum"
3. For ValueNum, assign the value "tonumber({Subreport.CountOfUserID})"
4. Save and close
5. Go back to Chart Expert, and on the Data tab, show value(s), add the new field "ValueNum", and check Don't Summarize.
The report will display as you wanted it to.

d

No comments:

Post a Comment