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