Reports FAQ: Difference between revisions
No edit summary |
|||
| Line 15: | Line 15: | ||
*[[Reports FAQ#How can I do calculations in CommitCRM reports?|How can I do calculations in CommitCRM reports?]] | *[[Reports FAQ#How can I do calculations in CommitCRM reports?|How can I do calculations in CommitCRM 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?]] | |||
<br> | <br> | ||
Revision as of 20:12, 27 November 2009
Getting Started
Advanced Use
- How can I customize CommitCRM reports?
- 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 CommitCRM 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 CommitCRM reports?
- 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?
How can I customize CommitCRM reports?
To customize CommitCRM reports, open the Reports window, select the report you want to customize, select Copy from the toolbar and enter your new report name. The copied report will be selected. Select the Design button from the toolbar, and the report designer will open.
Design the report layout and save.
We recommend on watching this Report Designer Tutorial Video, where you can learn how to add a new customized report. You will learn how to change the report layout and how you can add new data fields to the 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?
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.
We recommend on watching this Report Designer Tutorial Video, where you can learn how to add a new customized report. You will learn how to change the report layout and how you can add new data fields to the report.
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.
We recommend on watching this Report Designer Tutorial Video, where you can learn how to add a new customized report. You will learn how to change the report layout and how you can add new data fields to the report.
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 CommitCRM reports?
You can set/modify a textual header (with your company name, etc.) for all reports at once by selecting Tools > Options… from the main menu. In the Options window, go to the Reports tab and click on Edit Header.
You can brand CommitCRM reports with a customized image logo by customizing the reports.
To customize CommitCRM reports, open the Reports windows and select a report you would like to customize. From the Reports menu, select Copy and choose a name for your new report. Check that the copied report is selected, and select Edit from the Reports menu. The report designer opens.
In order to allow an image to be displayed in the header, you need to disable the textual header. To do so, move all the fields located above the Header title/band to below the Header title. Right-click the Header title and unmark the Visible option.
To add an image to the report, click on the image button on the toolbar and draw a rectangle beneath the Header section. Right-click on the rectangle you have drawn and select Picture... > Load... and select your logo image file. (Please note that your logo needs to be saved as a ".bmp" file.) Save your changes.
We recommend on watching this Report Designer Tutorial Video, where you can learn how to add a new customized report. You will learn how to change the report layout and how you can add new data fields to the report.
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 CommitCRM loads report headers once per login. You should log out from CommitCRM and log in again for the header changes to take effect.
Can I email a report?
You can save CommitCRM 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 CommitCRM 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 CommitCRM 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 CommitCRM 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 CommitCRM 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 CommitCRM installation folder, and restoring it from a backup will return the original header you were using.
The report header file is located at \Commit\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.