| Knowledge Base Article #160 - Listing files associated with a set of settings in a Crystal Report. |
|---|
| Date | Jan 14, 2008 |
| By | ENOSERV |
| Filed Under | PowerBase |
| Class | General |
| |
| Issue Addressed |
|---|
| With the release of PowerBase 5.0.4.0, it is now possible to add a list of the files that are attached to a relay settings record in your reports generated by Crystal Reports. |
| |
| Causes of Issue |
|---|
| In order to access these new fields, the new version of PowerBase must be run, and the PRINTRELAY table must be rebuilt to include the new file fields. This is done by selecting Utility -> Administrative Duties -> Rebuild the PRINTRELAY table. This will add the fields RELAY_FILE_NAME, RELAY_FILE_UPLOAD_DATE, and RELAY_FILE_USERNAME. |
| |
| Solution to this Issue |
|---|
These fields can then be used in Crystal Reports to list the file names, date they were uploaded, and who they were uploaded by. In the case that there is more than one file associated, the names, dates and users will be listed in order and seperated by a comma ( , ).
|