![]() |
![]() |
| ||
| Search for an article | ||
All Forums![]() RentalDesk Reporting![]() |
|
| Article: NAV185 | Managing the Display of 'Component Parts' in Reports. |
| Summary: | This article requires the use of the Advanced Report Designer, which has no official support in RentalDesk NX. See THIS link for more information. Often users want to be able to give special treatment to 'Component Parts'� (see 'Attached Items are Components' option for equipment Types) in their print outs. Typical requests are being able to hide them completely or being able to indent them. Both of these can be achieved with the Advanced Report Designer, so you may need to refer to the manual if you have some difficulty with terms and techniques. Below we shall illustrate how to achieve these effects with the Quote report, and the same will apply to other equipment list based reports such as Prep Sheets. If you wish to do something similar with, say, an Invoice report, then the exact techniques may differ, although the principles will be the same. 1) Hiding Components completely a) If the lines on an equipment list truly are 'components' because they were attached to a Type with 'Attached Items are Components' set to be true, then this is just a case of extending the selection criteria for the report: Open the report and go to the Data Tab. In the DataView window select the 'Search' button (magnifying glass icon). In the upper panel find the field 'Eqlist_Detail - componentpart'. Double click it to add it to the lower panel. (If you select the wrong field by accident, double click on the incorrect one in the lower panel to remove it). Now in the lower panel click in the 'Value' column for the new field and type in FALSE. Make sure the Operator field contains an '=' sign, then click OK to close and save, then save the report. b) If the lines on an equipment list are not always strictly 'components' but merely any item that you do not charge for, then you can just use a different selection criterion: Open the report and go to the Data Tab. In the DataView window select the 'Search' button (magnifying glass icon). In the upper panel find the field 'Eqlist_Detail - chargedprice'. Double click it to add it to the lower panel. (If you select the wrong field by accident, double click on the incorrect one in the lower panel to remove it). Now in the lower panel click in the 'Operator' column� for the new field and select '>'. In the 'Value' column type 0.00. Click OK to close and save, then save the report. 2) Indenting Components Before you can try any of the techniques below you will need to make sure that the field 'Eqlist_Detail - componentpart' is available in the report. This is because the field was only introduced in RentalDesk NX. To do this you can either add all fields to the report from the menu option Report / Refresh Fields List in the Design Tab; or you will need to add the field specifically from the Data Tab's DataView / Fields button. a) A quick and dirty (and less flexible) solution is to just replace the OnCalc code for the variable component, 'FDescription' with the following:
All this does in addition to the original code is test if the current line is a component part and if it is then prefix the value of the variable component with some spaces before adding the description of the equipment, otherwise just assign this description. b) Our quick fix above doesn't treat components as a field in its own right so if you want to perform additional treatments, such as change the font size, or makie it italic. To do this� you would want to add another variable component to the report and code it up so that it only displays text if the current line is a component part. However, first we would need to change the OnCalc code for the variable component, 'FDescription' so that it does not display anything if it is NOT a component part:
In other words, if the equipment list�line is a component part then print empty text (''), otherwise print the description of the Type or any FreeText Now add another variable component to the Detail Band. Set its OnCalc event code to be the following:
In other words, if the equipment list� line is NOT a component part then print empty text (''), otherwise print the description of the Type. You can now return to the Design Tab and re-size your new variable component. You probably want to simply lay it on top of the FDescription component and indent it to your preferred distance. The techniques outlined in this section can also be applied to the Qty field if deemed necessary. N.B. Users who upgraded from RentalDesk V1 may need to get the latest set of dictionary tables and fields from THIS link. To install these files, close RentalDesk NX, stop the RD Server (Server menu, Stop All Modules), and extract the zip to your DATA folder (normally c:\program files\retnaldesk nx\data) and overwrite existing files. Then restart all modules. |
| Last Updated: | 25 March 2004 - 13:42 |