Want to update the Materials reports, so that it only shows Tasks in each of the Task Lists which affect the current client.
Also, want to change the way Codes are displayed in the Report. The name of the Client Code column will change to concat the tbl_client.name with the word Code. If it is blank, as is the case with SP, then it will not display. The network id will be displayed in a similar way except for the Standard. The WCE code will be placed in its own column also. This will ensure that exports to excel can work a lot easier.
Task for Hawea.
Want to update the Materials reports, so that it only shows Tasks in each of the Task Lists which affect the current client.
Also, want to change the way Codes are displayed in the Report. The name of the Client Code column will change to concat the tbl_client.name with the word Code. If it is blank, as is the case with SP, then it will not display. The network id will be displayed in a similar way except for the Standard. The WCE code will be placed in its own column also. This will ensure that exports to excel can work a lot easier.