Administration Features and Functions > Enhancing Reports
  
Enhancing Reports
You can display selected non-component based reports in an enhanced format. The enhanced format improves the appearance of reports, including:
Enhanced report header and footer
Report header inclusion of company logo
Data representation using HTML tables
True Type font support
Different colors for alternate rows
The upper-right area displays the date and time. Additionally, to improve readability, the program name and number are at the bottom of a report rather than at the top near the report title.
Setting Report Format
You can specify whether to use the enhanced format on selected reports or the standard format on a system-wide basis as follows:
1 To use the enhanced format, edit the settings.dat file in the QADInstallDir/qadui/com/mfgpro directory, setting beautifyReports to yes. For information on the setting.dat file, see Editing setting.dat File.
2 The selected reports that display in the enhanced format are specified in the beautifyReports.lst file. For more information on using the beautifyReports.lst file to select which reports use the enhanced format, see Selecting Which Reports Use Enhanced Format.
3 To use the standard format, set beautifyReports to no. By default, beautifyReports is set to yes.
4 Restart the Connection Manager for the changes to take effect.
5 Finally, all users must clear the QAD .NET UI’s cache of temporary Internet files before running further reports.
Editing setting.dat File
The setting.dat file is located in the QADInstallDir/qadui/com/mfgpro directory. However, you must also edit the additional setting.dat file located in the QADInstallDir/qadui/com/qad/mfgpro directory.
The setting.dat file in the QADInstallDir/qadui/com/mfgpro directory is compiled from the setting.dat file in the QADInstallDir/qadui/com/qad/mfgpro directory. When you change the files in the QADInstallDir/qadui/com/mfgpro directory, you see the effect of the change right after you edit the file.
When you change the files in the QADInstallDir/qadui/com/qad/mfgpro directory, you do not see the effect of the change until after a compile, at which time the files in the QADInstallDir/qadui/com/mfgpro directory are over-written by the new files compiled from the files in the QADInstallDir/qadui/com/qad/mfgpro directory.
After you make changes to the setting.dat file, you must restart the Connection Manager for the changes to take effect.
Selecting Which Reports Use Enhanced Format
The beautifyReports.lst file in the QADInstallDir/qadui/com/mfgpro directory lists the reports that will use the enhanced format when the beautifyReports setting in the setting.dat file is set to yes.
The reports listed in beautifyReports.lst have been tested to display using the enhanced format. You can include other reports in this list but QAD recommends only using the reports listed by default in beautifyReports.lst. If you do modify the beautifyReports.lst file, be sure to restart the Connection Manager and have all users clear the QAD .NET UI’s cache of temporary Internet files before running further reports.
As with the two setting.dat files, the beautifyReports.lst file is located in the QADInstallDir/qadui/com/mfgpro directory. However, you must also edit the additional beautifyReports.lst file located in the QADInstallDir/qadui/com/qad/mfgpro directory.
The beautifyReports.lst file in the QADInstallDir/qadui/com/mfgpro directory is compiled from the beautifyReports.lst file in the QADInstallDir/qadui/com/qad/mfgpro directory. When you change the files in the QADInstallDir/qadui/com/mfgpro directory, you see the effect of the change right after you edit the file. When you change the files in the QADInstallDir/qadui/com/qad/mfgpro directory, you do not see the effect of the change until after a compile, at which time the files in the QADInstallDir/qadui/com/mfgpro directory are over-written by the new files compiled from the files in the QADInstallDir/qadui/com/qad/mfgpro directory.
Including Company Logo
With the enhanced format, the upper-left area can include your company’s logo. To include a logo:
1 Locate the Tomcat installed images directory (for example, TomcatInstallDir/webapps/qadui/images).
2 Place any graphics files containing company logos in this directory. For example, place a file named myLogo.jpg that contains the logo you want to use. By default, the directory includes companyLogo.jpg, which contains the QAD logo. For example, place a file named myLogo.jpg that contains the logo you want to use. By default, the directory includes companyLogo.jpg, which contains the QAD logo.
Note: Use companyLogo.jpg as the file name so that you do not have to modify the setting.dat file as described in the next step.
Note: If the height of the logo exceeds 60 pixels, report page formatting can be affected.
3 To add your company’s logo to the report, edit the setting.dat file in the QADInstallDir/qadui/com/mfgpro directory, setting reportCompanyLogoImage to the graphics file (for example, images/myLogo.jpg). By default, reportCompanyLogoImage is set to image/companyLogo.jpg. (Note that the file name is case-sensitive.) For information on the setting.dat file, see Editing setting.dat File.
4 If you do not want to display a logo on reports, set reportCompanyLogoImage to blank (do not enter any graphics file).
5 Finally, all users must clear the QAD .NET UI’s cache of temporary Internet files before running further reports.
Removing Report Footer
The enhanced report footer now includes the program name and number at the bottom of the report. If required, you can remove the footer information as follows:
1 Edit the TomcatInstallDir/webapps/qadui/css/
AppReportStandard.css
file, changing the div.reportFooter statement to the following:
div.reportFooter {display:none;}
2 Finally, all users must clear the QAD .NET UI’s cache of temporary Internet files before running further reports.
Setting Default Browser Text Size
To have reports use your default browser text size setting, edit the setting.dat file in the QADInstallDir/qadui/com/mfgpro directory, setting allowBrowserFontSize to yes. The default setting is no. (Note that to set the default browser text size setting in Internet Explorer, select View|Text Size). For information on the setting.dat file, see Editing setting.dat File.
Different Colors for Alternate Rows
If a report includes different colors for alternate rows, to have the different colors display, select Tools|Internet Properties and click the Advanced tab. In the Settings view, scroll down to Printing and select Print background color and images.
Saving Enhanced Reports to Excel
In general, you cannot export reports from the QAD .NET UI to Microsoft Excel. While in a report, right-clicking and selecting Internet Explorer’s Export to Microsoft Excel will not export the report data to Excel. However, you can quickly copy data from an enhanced report and place it into Excel. To do so, while in an enhanced report, right-click and select Select All (Ctrl+A) and then select Copy (Ctrl+C). Next, open Excel and select Paste. Excel places the report data into appropriate columns and rows in Excel.