|1. ||Go into Report Writer. (Tools-Customize-Report Writer) |
|2. ||Click on the Reports icon from the top menu bar. |
|3. ||From the Original Reports side, highlight the PA Fees List – by Project report and choose insert. |
|4. ||Then on the Modified Reports side, highlight the same report and choose the Open button. |
|5. ||In the Report Definition window choose the Tables button. |
|6. ||In the Report Table Relationships window, highlight the PA Project Fee Master File and choose the New button. |
|7. ||Highlight the Project Fee Schedule Master and choose the OK button. |
|8. ||Select the Close button |
|9. ||In the Report Restrictions window choose New |
|10. ||Name the restriction Dummy |
|11. ||In the fields section, click on the drop down list for Report Table and choose the PA Project Fee Schedule Master . |
|12. ||Click on the drop down list for Table Fields and choose Line Item Sequence . |
|13. ||Choose the Add Field button. |
|14. ||In the operators section, choose the = button. |
|15. ||Chose the Add Field button again. |
|16. ||The Restriction Expression should read |
PA Project Fee Schedule Master.Line Item Sequence = PA Project Fee Schedule Master.Line Item Sequence
|17. ||Choose the OK button. |
|18. ||Close the Report Restrictions window. |
|19. ||Click on the Layout button from the Report Definition Window. |
|20. ||Choose the Tools option from the top menu bar, then select Report Section Options . |
|21. || |
In the Additional Headers section highlight Project choose the New button.
|22. || |
Name the Report Header Fee .
|23. || |
Click on the drop down list for Report Table and choose the PA Fee Master File .
|24. || |
In the Fields section, highlight PA Fee ID .
|25. || |
Select OK .
|26. || |
Drag all of the fields from the B (Body) section up to H2 (Header 2) section.
|27. || |
In the Toolbox choose PA Project Fee Schedule Master from the drop down list.
|28. || |
In the scrolling window find PA Date and drag it into the B (Body) section on the report.
|29. || |
In the scrolling window find PA Fee Amount and drag it into the B (Body) section on the report.
|30. ||Choose the X from the top right corner of the Report Layout window. |
|31. ||Save your changes. |
|32. ||Click OK in the Report Definition window. |
|33. ||From the top menu bar, choose File - Great Plains Dynamics. |
|34. ||Give users access to the modified report in the Security Setup window (Setup - System - Security) within Dynamics. |