There are more than one hundred standard reports in The Raiser's Edge. If they contain more information than you need or you want to annotate them, you can easily edit them by exporting them to your word processor. If you need to create more specialized reports, use Crystal Reports for Blackbaud, a comprehensive report writer. 
 
A Crystal report is composed of two elements: a data file (MDB) and a report file (RPT). To create a data file (MDB) for use with Crystal Reports for Blackbaud, extract the fields you need in Blackbaud Report Writer Database (MDB) format (MS Access Report Writer Database format in version 6). Crystal Reports for Blackbaud is a run-time version of Crystal Reports that is licensed for use only with Blackbaud Report Writer Database files exported from The Raiser's Edge. 
 
You can add special fields to your Crystal reports to add information not found in your data file. Simply select Insert, Special Field from the menu bar to insert special fields such as date and time fields, comments, and page numbers. These are some of the most commonly used special fields: 

  • Page Number — prints a page number on every page when placed in the Page Header or Page Footer.
  • Total Page Count — prints the sum of all the pages. Insert this field in the Report Header or Footer as well as the Page Header or Footer. You can combine Total Page Count with the Page Number field to create running total page numbers, such as "Page 1 of 10."
  • Print Date or Print Time — prints the current date or time in any section it is placed. Use these fields when comparing reports to determine when a report was printed.
  • Data Date or Data Time — prints the date or time the data was last retrieved or refreshed in any section of a report it is placed.
  • Last Modification Date or Last Modification Time - prints the date or time the report was last modified. Modified refers to any modification, including something as simple as moving a field. When you modify the report and print it, the program prints the modification date and time even if you do not save the report before printing.
  • Report Title — prints the title of the report as defined in the report's Summary Info.
  • To define Summary Info, select File, Summary Info from the menu bar. You can insert this field in any section.
  • Report Comments — prints report comments as defined in the report's Summary Info. You can insert this field in any section to explain report contents or make notes. 
  • Page N of M — combines the Page Number and Total Page Count fields into a single field; for example, "Page 3 of 10." Insert this field in the Page Header or Footer.
  • File Path and Name — prints the name and location of the Crystal report (RPT) file in any section it is placed; for example, "C:\REWIN\2002_Annual.rpt." This field prints only if you save the report.
  • File Author — prints the author's name as defined in the report's Summary Info.
  • File Creation Date — prints the date the report was created. Use this field to identify the age of a report.
  • Record Selection Formula — prints the criteria of record selection formulas in a report. For example, if you selected specific constituent IDs to be included in a report, the Record Selection Formula field prints {Constituent.Constituent ID} in ["0234-FR", "0643-RR", "0983-WY", "0987-HS", "1023-HH"].
  • Group Selection Formula — prints the criteria of any group selection in a report. For example, you create a report of constituents grouped by the city in their preferred address. In the report, you insert a count of constituents per city and select only cities with 50 or more constituents. The Group Selection Formula field prints Count ({CNADRSAL.EN_US}, {CNADRPRF.EN_US}) >= 50.00.
Next steps:
  • For help with specific Crystal Reports functions, such as formatting, parameters, formulas, and variables, search Knowledgebase.
  • For answers to the most commonly asked questions, visit Crystal Reports FAQs.
  • For assistance with a Crystal report, click Chat with Support and reference this article. Support for Crystal reports is available for organizations with Advantage Professional and Advantage Priority maintenance.
  • If you would like us to create a custom Crystal report for your organization from scratch, contact your account manager directly or email solutions@blackbaud.com