Your Knowledge Base has moved to the new Help Center.  Check out the release notes for details. And don't forget to update your bookmarks and in-house documentation before May 28.

Reports, Routines, & Notifications - June 2020

video
 
Don't miss the over 130 reports updated for Global Filter, Time Zone and design, the New Responsibilities Transfer Report, the ability to customize the threshold for the Message Recap Notification, and more!

Video: Coaching Corner

Reports 

  • *New* Added a new report on the Users page called "Responsibilities Transfer (Select Both)" based on two selected records to transfer a User's Security Roles, Views, Notifications, User Groups, Charts, and/or Delegate Of users to another User. Intended to be used when a User is leaving or changing roles on your staff to show instances where they are related to current records in the database. It may also reveal specific responsibilities in the database you wish to handle individually outside of the report.
  • *New* Added a new report on the Groups page called "New Group Participants - Selected" which can be used to determine how many people have been added to the select Groups between two dates.
  • *New* Added additional Greeting Types for the Contact column on the Selected Household Donations report that is available on more than 30 pages.
  • Enhanced multiple reports to take Global Filters into account when displaying results so that it will be limited based on the user's rights. See full list of reports below.
  • Enhanced multiple reports to take User's Time Zone into account when displaying results. See full list of reports below.
  • Enhanced multiple reports with updated design (font, logo, etc.). See full list of reports below.
  • Enhanced the Create Deposit From Selected Batches report on the Batches page, to add Congregation to the Deposit it creates which allows Global Filtering to work on the Deposits page. Note: Only for those customers with a Congregation field on the Deposits page already. If desired, you may request this field and enhanced report be added to your system by contacting Support.
  • Enhanced the Donation Summary Export report to include Statement Header titles as the column names.
  • Enhanced the Major Donor report on the Donors page to include the Date of Birth.
  • Enhanced the Selected Group Family Listing report on the Groups page to include the Last Attendance Date of the Group Participant.
  • Enhanced the Selected Group Roster: Parent Info report on the Groups page to include the Date of Birth.
  • Optimized the Compare and Combine Selected Households report on the Households page to take into consideration any custom foreign keys to the Households page.
  • Optimized the Campaign Selected Donor Summary report on the Pledge Campaign page for improved performance.
  • Fixed the Selected Group Directory Photos report on the Groups page to hide Participant's unlisted contact information when Honor Unlisted Preferences is set to True.
  • Fixed an issue on the Giving Band reports where certain date ranges would cause errors.
  • Fixed an issue on the Giving Band reports where long Donor names would cause errors.
  • Fixed a typo on the About This Page report.
  • Fixed the page footer for the Event Setup report on the Events page that was causing extra blank pages in the PDF.
  • Fixed the "Selected Labels: 1 per Family" report by adding the suffix when one head's last name is different than the other head's last name.

Important! Edits to our standard report stored procedures or RDL files are not supported and are highly unusual. Typically, custom reports based on standard reports require copies that are unique to each system. Therefore, the reports updated in this release should have no impact on reports you have had customized. 

If you or one of your technicians had edited one of our standard stored procedures or RDL files and our update has overwritten your changes, please notify Support. We will restore copies of up to 3 reports in a single session as they existed when this update was applied at no charge within 30 days of receiving this update as a one-time offer due to the volume of reports we are updating. Professional Service rates will apply for more than 3 reports or reports you request us to recover after 30 days.

Custom reports are not updated as part of this release. If you desire that one of your custom reports be updated to the latest standards, please contact Support to request a Professional Services proposal.

Routines & Notifications

  • Enhanced the nightly routine for Data Quality by changing old Subpage field references to the new Subpage field references so it will no longer cause it to stop working.
  • Enhanced the Form Response Notification to run every 15 minutes (same as other similar Notifications).
  • Enhanced the Message Recap Notification to allow customization of the threshold of recipients needed to send the notification by adding a new Configuration Setting called SERVICES > MessageRecapMinimumRecipients with a default value of 100.  This can be changed to 50, 150, etc.
  • Enhanced the Activity Log by adding Form Responses and Needs (requests and providers).
  • Fixed the Event Reminder Notification so that it does not send a reminder on a cancelled Event.

System Setup

  • *New* Added a separator called "Donation Activity" and reorganized the fields on the Donors table for ease of use.
  • Enhanced the default field list on the Letters page (under Communications) to include additional fields (Page, Active) to assist faster recognition.
  • Enhanced the default field list on the All Steps page (related to Processes) to include additional fields (Step Type, Email From, Email To, Task To) to assist with troubleshooting.

Processes, Roles, & Configuration Setting Changes

  • Enhanced multiple reports to list only current Congregations (End Date is null or in the future).

Database Object 

  • *New* Added a new view for Deleted Records on the "All Submissions" page to aid in troubleshooting Processes.
  • *New* Added a new view for Unfinished Commands on the "All Submissions" page to aid in troubleshooting Processes.
  • *New* Added a new view "Fix: Single Filtered Page" on the Pages page to show when a primary page is filtered.
  • Enhanced several standard Charts to provide consistent month labels.
  • We have added "Other Needs" column to the All Records view on the Need Type Providers page.
  • We have removed the following deprecated items (and updated any Security Roles with these items accordingly):
    • Pages: User Congregations
    • Subpages User Allowed (on Congregations)
    • User Groups: Allowed by Congregations
Need help moving to Global Filters? Reach out to a Coach!
Reports updated to honor Global Filter, honor User Time Zone, and/or with updated design:
  • 3D Ministry Grid-Selected
  • Add/Remove Series Rooms
  • Alter Subscription
  • Audit Log Search (Selected)
  • Campaign Dashboard
  • Campaign Dashboard Selected
  • Campaign Donation List
  • Campaign Donation List Selected
  • Campaign Donation to Pledge Matching
  • Campaign Pledge Dashboard
  • Campaign Pledge List
  • Campaign Projection
  • Compare & Combine Selected Households
  • Data Quality Report
  • Deleted Record Research
  • Donation Listing - ChurchAnalytics.com
  • Donation Summary Export
  • Donation Summary Export - Selected
  • Donor Household Retention
  • Donor Household Summary-Selected
  • Double Booked Rooms
  • Feedback Printout
  • Feedback Report
  • Find Contacts By Attributes
  • Find Contacts By Attributes Selected
  • Group Involvement Summary
  • Group Participant Attendance
  • Group Participant Changes By Month
  • Group Recommendations
  • Group Seasonal Dashboard
  • Group Seasonal Summary
  • Group Snapshot Dashboard
  • Group Snapshot Summary
  • Group/Team Export
  • Household Source Analysis
  • Households New Again
  • Journey Participants
  • Milestones By Week
  • Ministry Metrics
  • New Group Participants
  • New Participants By Week
  • Opportunities Selected
  • Opportunity Summary
  • Page Listing
  • Participant Analysis
  • People Totals
  • Planned Contact Listing
  • Pledge Campaign Statement
  • Pledge Campaign Statement: Selected
  • Procedure Manual
  • Process Selected Payment - ShelbyNext Excel Export
  • Process Selected Payments
  • Process Selected Payments Intacct Export
  • Process Selected Payments to Financial Edge
  • Record Review and Useful Links
  • Response Closure By Month
  • Response Summary
  • Room Availability Research
  • Room Use Forecast
  • Selected Background Checks
  • Selected Campaign Donor Summary
  • Selected Campaign Donor Summary Export
  • Selected Campaign Summary
  • Selected Deposit - Items List
  • Selected Deposit - ShelbyNext Excel Export
  • Selected Event Group Attendance
  • Selected Event Metrics
  • Selected Event Nametags: Avery 5160
  • Selected Event Participants List
  • Selected Event Registrants Summary
  • Selected Event Registrations
  • Selected Event Setup Form
  • Selected Event Summary
  • Selected Feedback Digest
  • Selected Feedback Report
  • Selected Form Responses
  • Selected Group Attendance
  • Selected Group Attendance By Event Type
  • Selected Group Attendance By Individual
  • Selected Group Attendee Search
  • Selected Group Birthday List
  • Selected Group Call List
  • Selected Group Directory
  • Selected Group Directory - Photos
  • Selected Group Family Listing
  • Selected Group Involvement
  • Selected Group Last Attended
  • Selected Group Nametags: Avery 5160
  • Selected Group Parent Email List
  • Selected Group Participation Percentages
  • Selected Group Participation Summary
  • Selected Group Rollscan Roster
  • Selected Group Roster
  • Selected Group Roster Plus Family
  • Selected Group Roster: Parent Info
  • Selected Group Weekly Attendance by Group
  • Selected Household Care
  • Selected Household Donation Summary
  • Selected Household Facts
  • Selected Household Labels
  • Selected Household Matches
  • Selected Household Photos
  • Selected Invoice Printout
  • Selected Message Recap
  • Selected Milestone Summary
  • Selected Milestones Letter
  • Selected Payment Listing
  • Selected Pledge Donation List
  • Selected Pledge Letter
  • Selected Pledge Mail Merge
  • Selected Procedure Manual
  • Selected Program Donations
  • Selected Program Donations Enhanced
  • Selected Program Donors
  • Selected Program Group Rosters
  • Selected Program Groups Multi-week Roster
  • Selected Program Groups RollScan Roster
  • Selected Program List Export
  • Selected Program Participants List
  • Selected Programs Household Giving
  • Selected Publication Household Export
  • Selected Publication Subscriber Export
  • Selected Response Letter
  • Selected Response Listing
  • Servicing Analysis
  • Servicing Forecast
  • Supervisor List
  • Tasks Incomplete
  • User Audit Log Activity
  • User Audit Log Detail
  • User Message Activity
  • User Permissions
  • User Permissions: Reports & Tools