 |
| Accpac tip about Accounting and I/C, O/E, P/O |
Week |
Feb week 2 2011 |
Subject |
Creating a custom report that can run on any ACCPAC company database |
Details |
To create a report which works with any ACCPAC Company database, Crystal Reports needs a method to determine the path of the data needed in the report. Fortunately, ACCPAC automatically passes this information to the report if 3 parameters are added to the report. These parameters are CMPNAME, PATH and EXT. The parameters must be in uppercase and spelled exactly the same. To add parameters:
1) Click the Insert pull down menu and select "field object."
2) Expand the section titled "Parameters." Click on "New Icon."
3) Type in the parameter name. Make sure the value type is a string, and discrete values is checked. Click "OK"
4) Repeat for the remaining parameters.
5) Save the report.
6) Open ACCPAC and select a folder (either existing or new custom folder), right click and select "new report".
7) Enter a name for the report and then browse the path of the report. Click "OK."
8) Double click the newly created icon to open the report. |
| |
|
