Reports FAQ: Difference between revisions
No edit summary |
No edit summary |
||
Line 7: | Line 7: | ||
===Advanced Use=== | ===Advanced Use=== | ||
*[[Reports FAQ#How can I customize | *[[Reports FAQ#How can I customize RangerMSP reports?|How can I customize RangerMSP reports?]] | ||
*[[Reports FAQ#How can I delete a custom report?|How can I delete a custom report?]] | *[[Reports FAQ#How can I delete a custom report?|How can I delete a custom report?]] | ||
*[[Reports FAQ#I want to create a custom report. How do I select the existing report I wish to copy for using as a basis for the new custom report?|I want to create a custom report. How do I select the existing report I wish to copy for using as a basis for the new custom report?]] | *[[Reports FAQ#I want to create a custom report. How do I select the existing report I wish to copy for using as a basis for the new custom report?|I want to create a custom report. How do I select the existing report I wish to copy for using as a basis for the new custom report?]] | ||
*[[Reports FAQ#How can I add new data fields and labels to a report?|How can I add new data fields and labels to a report?]] | *[[Reports FAQ#How can I add new data fields and labels to a report?|How can I add new data fields and labels to a report?]] | ||
*[[Reports FAQ#Where can I find the customized reports?|Where can I find the customized reports?]] | *[[Reports FAQ#Where can I find the customized reports?|Where can I find the customized reports?]] | ||
*[[Reports FAQ#How can I embed my company logo in | *[[Reports FAQ#How can I embed my company logo in RangerMSP reports?|How can I embed my company logo in RangerMSP reports?]] | ||
*[[Reports FAQ#I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?|I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?]] | *[[Reports FAQ#I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?|I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?]] | ||
*[[Reports FAQ#How can I do calculations in | *[[Reports FAQ#How can I do calculations in RangerMSP reports?|How can I do calculations in RangerMSP reports?]] | ||
*[[Reports FAQ#I customized a report and some fields are not printing in the right place. How can I fix this problem?|I customized a report and some fields are not printing in the right place. How can I fix this problem?]] | *[[Reports FAQ#I customized a report and some fields are not printing in the right place. How can I fix this problem?|I customized a report and some fields are not printing in the right place. How can I fix this problem?]] | ||
*[[Reports FAQ#My_report_header_doesn't_display_correctly._How_can_I_have_it_restored_from_a_backup?|My report header doesn't display correctly. How can I have it restored from a backup?]] | *[[Reports FAQ#My_report_header_doesn't_display_correctly._How_can_I_have_it_restored_from_a_backup?|My report header doesn't display correctly. How can I have it restored from a backup?]] | ||
Line 22: | Line 22: | ||
---- | ---- | ||
===How can I customize | ===How can I customize RangerMSP reports?=== | ||
To customize | To customize RangerMSP reports: | ||
# Open the Reports window | # Open the Reports window | ||
# Select the report you want to customize | # Select the report you want to customize | ||
Line 53: | Line 53: | ||
===How can I embed my company logo in | ===How can I embed my company logo in RangerMSP reports?=== | ||
The Report header can be designed with your textual header (with your company name, etc.) and your logo. The Report header is defined once for all reports and can be edited from the Tools menu. The Report header includes two parts: Text and Image (usually your Logo). | The Report header can be designed with your textual header (with your company name, etc.) and your logo. The Report header is defined once for all reports and can be edited from the Tools menu. The Report header includes two parts: Text and Image (usually your Logo). | ||
Line 59: | Line 59: | ||
===I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?=== | ===I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?=== | ||
In order to increase report generation performance | In order to increase report generation performance RangerMSP loads report headers once per login. You should log out from RangerMSP and log in again for the header changes to take effect. | ||
===Can I email a report?=== | ===Can I email a report?=== | ||
You can save | You can save RangerMSP reports as PDF files using any of the standard PDF creation tools (Adobe Acrobat, PDF Maker, etc.). You can then email the file to your customers. | ||
Starting with | Starting with RangerMSP 5.0 you can print reports directly to PDF from the report generation window by using the "Print to file" button in the report generation window. When using this option, the system allows you to save to a PDF file or email the output PDF file directly from the report generation window. When emailing the report, this email will be filed under the relevant account, together with the attached PDF report. | ||
Line 72: | Line 72: | ||
===How can I do calculations in | ===How can I do calculations in RangerMSP reports?=== | ||
Field based calculations – Average, Sum, Minimum etc. - can be calculated in the report designer. | Field based calculations – Average, Sum, Minimum etc. - can be calculated in the report designer. | ||
Line 81: | Line 81: | ||
===I customized a report and some fields are not printing in the right place. How can I fix this problem?=== | ===I customized a report and some fields are not printing in the right place. How can I fix this problem?=== | ||
This question describes the following problem: You have customized a | This question describes the following problem: You have customized a RangerMSP report, and it looks fine on the screen while being edited in the report designer. However, when you actually run the report, some of the fields are printed in a higher or lower location than they had appeared on the screen. | ||
To solve this problem, open the customized report in the report designer, select a field that is not displaying in the right place, right-click it and select 'ShiftWithParent'. Repeat this for all the fields that are not printing in the right place. | To solve this problem, open the customized report in the report designer, select a field that is not displaying in the right place, right-click it and select 'ShiftWithParent'. Repeat this for all the fields that are not printing in the right place. | ||
Line 87: | Line 87: | ||
===My report header doesn't display correctly. How can I have it restored from a backup?=== | ===My report header doesn't display correctly. How can I have it restored from a backup?=== | ||
The | The RangerMSP Report Header can be edited to fit your businesses needs from '''Tools > Options > Reports'''. Once the header has been edited, this change will take effect on every report which displays a header section. In some cases, you may want to restore the customized header after you already changed it. | ||
The Header itself is saved in a file in your | The Header itself is saved in a file in your RangerMSP installation folder, and restoring it from a backup will return the original header you were using. | ||
The report header file is located at '''\ | The report header file is located at '''\RangerMSP\DbSys\ReportHeader.Rtf'''. | ||
* Please note that this file '''must not''' be edited manually! You must edit the header from '''within the application only''', using the '''Tools > Options window'''.<br> | * Please note that this file '''must not''' be edited manually! You must edit the header from '''within the application only''', using the '''Tools > Options window'''.<br> | ||
==See Also== | ==See Also== | ||
*[[Charges#Using | *[[Charges#Using RangerMSP Charge Reports|Charge Reports]] | ||
*[[Report Customization]] | *[[Report Customization]] | ||
[[Category:FAQ]] | [[Category:FAQ]] | ||
__NOTOC__ | __NOTOC__ |
Latest revision as of 13:40, 8 July 2020
Getting Started
Advanced Use
- How can I customize RangerMSP reports?
- How can I delete a custom report?
- I want to create a custom report. How do I select the existing report I wish to copy for using as a basis for the new custom report?
- How can I add new data fields and labels to a report?
- Where can I find the customized reports?
- How can I embed my company logo in RangerMSP reports?
- I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?
- How can I do calculations in RangerMSP reports?
- I customized a report and some fields are not printing in the right place. How can I fix this problem?
- My report header doesn't display correctly. How can I have it restored from a backup?
How can I customize RangerMSP reports?
To customize RangerMSP reports:
- Open the Reports window
- Select the report you want to customize
- Click Copy on the toolbar and enter your new report name.
- The copied report is now selected.
- Click the Design button from the toolbar, and the report designer will open.
- Design the report layout and save your changes.
How can I delete a custom report?
To delete a custom report:
- Open the Reports window.
- Choose the relevant Category and click the Custom Reports button beneath the Categories list to view the custom reports list.
- Choose the custom report you want to delete.
- From the main menu, choose Reports > Delete.
I want to create a custom report. How do I select the existing report I wish to copy for using as a basis for the new custom report?
It is very important to identify an existing report which can serve as the basis for the customized report you wish to create. You must take into consideration when choosing the report both its layout and its data structure. Every report has predefined data source relations and fields that can be selected.
How can I add new data fields and labels to a report?
To add new data field to a custom report, select a DBText button from the report designer toolbar and place it where desired in the report layout. With the newly created field selected, select the appropriate Data Field from the drop down list on the toolbar, which is located on the upper left corner.
Where can I find the customized reports?
All customized reports are listed under the same report categories once the Custom Reports radio button has been selected on the Reports window.
How can I embed my company logo in RangerMSP reports?
The Report header can be designed with your textual header (with your company name, etc.) and your logo. The Report header is defined once for all reports and can be edited from the Tools menu. The Report header includes two parts: Text and Image (usually your Logo).
See more details in Reports Image Header.
I changed the report header using the Options window, but when I preview a report the new header is not there, What should I do?
In order to increase report generation performance RangerMSP loads report headers once per login. You should log out from RangerMSP and log in again for the header changes to take effect.
Can I email a report?
You can save RangerMSP reports as PDF files using any of the standard PDF creation tools (Adobe Acrobat, PDF Maker, etc.). You can then email the file to your customers.
Starting with RangerMSP 5.0 you can print reports directly to PDF from the report generation window by using the "Print to file" button in the report generation window. When using this option, the system allows you to save to a PDF file or email the output PDF file directly from the report generation window. When emailing the report, this email will be filed under the relevant account, together with the attached PDF report.
Can I change the page size used for reports (Letter/A4)?
Yes. Go to Tools > Options > Reports > Default Paper Size settings.
How can I do calculations in RangerMSP reports?
Field based calculations – Average, Sum, Minimum etc. - can be calculated in the report designer.
From the toolbar select the DbCalc field and place it on the Group Footer or Report Summary bands. Then select the DbCalc field and assign the relevant data field to it using the drop down field selection list on the toolbar (Note: Calculations work only with numeric and date fields) Amount).
To select the DbCalc field formula – right-click on a Calc field and select Calculations… A window will open where you can select the formula.
I customized a report and some fields are not printing in the right place. How can I fix this problem?
This question describes the following problem: You have customized a RangerMSP report, and it looks fine on the screen while being edited in the report designer. However, when you actually run the report, some of the fields are printed in a higher or lower location than they had appeared on the screen.
To solve this problem, open the customized report in the report designer, select a field that is not displaying in the right place, right-click it and select 'ShiftWithParent'. Repeat this for all the fields that are not printing in the right place.
My report header doesn't display correctly. How can I have it restored from a backup?
The RangerMSP Report Header can be edited to fit your businesses needs from Tools > Options > Reports. Once the header has been edited, this change will take effect on every report which displays a header section. In some cases, you may want to restore the customized header after you already changed it. The Header itself is saved in a file in your RangerMSP installation folder, and restoring it from a backup will return the original header you were using.
The report header file is located at \RangerMSP\DbSys\ReportHeader.Rtf.
- Please note that this file must not be edited manually! You must edit the header from within the application only, using the Tools > Options window.