Kbase P30894: How to display Progress array fields in Crystal Reports 9 wi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/11/2003 |
|
Status: Unverified
GOAL:
How to display Progress array fields in Crystal Reports 9 without using Views
GOAL:
How to display Progress array fields as a list in Crystal Reports 9 without using Views
FIX:
Simple example using MonthQuota array field in the Salesrep table from the Sports2000 database. Connect to the Sports2000 database and add the Salesrep table to the report and then use the following steps:
1) In Field Explorer, right-click Formula Fields and select New
2) Enter a name for the formula and select Use Editor
3) From the Functions list, expand Strings, expand Replace and double-click on Replace (inputString, findString, replaceString)
Replace (, , ) will appear in the editor
4) Drag MonthQuota field into the editor and place it before the first comma.
Replace ({Salesrep.MonthQuota}, , ) will appear in the editor
5) Between the middle commas, enter ";"
Replace ({Salesrep.MonthQuota},";" , ) will appear in the editor
6) Behind the last comma, enter Chr(10)
Replace ({Salesrep.MonthQuota},";" , Chr(10)) will appear in the editor
7) Click Alt+C to check the formula. There should be no errors.
8) Click Save, then Close
9) In Crystal Reports 9 Design View, drag the new Formula Field into the Details area of the report
10) Select the formula, Right-Click on it and select Format Field...
11) Select the Common tab, and check the Can Grow check-box
The MonthQuota field will be displayed as a list when the report is Previewed