--- title: How Does Sage 300 Crystal Reports Work? description: A brief look at how Crystal Reports looks at Sage 300 data and the 3 stages it passes through before rendering a report. image: https://www.equationtech.us/hs-fs/file-14051415-jpg/images/crystal_reports_11-resized-600.jpg --- [866.436.3530](tel:+8664363530) | [** Customer Portal Login](https://na.myconnectwise.net/support/index.htm?Company=equationtech) [Speak With an Expert](https://www.equationtech.us/speak-with-an-expert) [![Equation Technologies - Sage Business Partner | San Diego](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?width=230&name=logo.png "Equation Technologies - Sage Business Partner | San Diego")](https://www.equationtech.us/) - [Sage Services](https://www.equationtech.us/sage-services) - Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage Payroll](https://www.equationtech.us/sage-services/sage-payroll) - [Sage HCM](https://www.equationtech.us/sage-services/sage-hcm-software) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - Services We Offer - [Software Selection](https://www.equationtech.us/software-solution-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Cloud](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) - [Extend Sage](https://www.equationtech.us/sage-integrations) - [Magento eCommerce](https://www.equationtech.us/sage-integrations#magento) - [ADP](https://www.equationtech.us/en/sage-300-sage-intacct-payroll-powered-by-adp) - [Aloha POS](https://www.equationtech.us/sage-integrations#aloha) - [Salesforce](https://www.equationtech.us/sage-integrations#salesforce) - [TimeClockPlus](https://www.equationtech.us/timeclockplus) - [Other Solutions](https://www.equationtech.us/other-solutions) - Industries - [Distribution](https://www.equationtech.us/distribution-management-software-solution) - [Education Nonprofit](https://www.equationtech.us/education-nonprofit-accounting-software) - [Financial Services](https://www.equationtech.us/financial-services-software) - [Franchise](https://www.equationtech.us/franchise-management-software) - [Healthcare](https://www.equationtech.us/healthcare-finance-software) - [Hospitality](https://www.equationtech.us/hotel-restaurant-accounting-software-solutions) - [Metal Processors & Distributors](https://www.equationtech.us/erp-for-metal-industry-businesses) - [Nonprofit](https://www.equationtech.us/nonprofit-accounting-software) - [Professional Services](https://www.equationtech.us/professional-services-software) - [SaaS & Technology](https://www.equationtech.us/erp-software-for-technology) - [Resources](https://www.equationtech.us/sage-software-resource-library) - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Online Videos](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) - [About](https://www.equationtech.us/about-us) - [Meet The Team](https://www.equationtech.us/management-team) - [Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # How Does Sage 300 Crystal Reports Work? ![technology blog](https://www.equationtech.us/hs-fs/file-14051415-jpg/images/crystal_reports_11-resized-600.jpg) **twitter **linkedin **facebook Have you ever asked yourself how does [Crystal Reports](https://www.equationtech.us/sage-accpac/reporting/crystal-reports/) for [Sage 300](https://www.equationtech.us/sage_erp_accpac/) work?  Did you know that the reports and forms you work with go through 3 Stages (Passes) before you are left with the end data?  Read below for a brief look at how Crystal Reports looks at the data encoded in the reports and for a summary of how the three stages work together. ![Crystal Reports 1 resized 600](https://www.equationtech.us/hs-fs/file-14051415-jpg/images/crystal_reports_11-resized-600.jpg)   **Pre-Pass 1** ("BeforeReadingRecords")  - This just calculates any constant formulas within the report that are manually entered (10*5 for example) **Pass 1** ("WhileReadingRecords")– At this point, Crystal pulls the database that you are pointed to and pulls the records selected.  It then calculates any formulas using those particular records. Next it will sort, separate, and calculate the records by the group the record is located.  Then, it stores this information into temporary files.  **Pre-Pass 2** – Crystal now sorts the groups as indicated in the Hierarchaial Group Settings. **Pass 2** ("WhilePrintingRecords") – Crystal will pull the stored data from Pass 1 and will complete all print related formulas, running totals, and sub-reports. ***Note:***  If the report has a group selection formula subtotals, grand totals, and summaries might appear incorrectly. This occurs because the grand totals and summaries are calculated during Pass 1, but the group selection formula filters the data again in Pass 2. Running total fields or Formula fields with variables can be used instead of summaries to total data successfully with group selection formulas. **Pass 3** – The Total Page count is determined. ## Was This Helpful? Please leave a comment and let us know if this Crystal Report tip was helpful and please feel free to suggest any other Sage 300 tips and tricks you'd like to see on our blog. ### Related Articles ##### [Sage 300 & Windows 10 End of Life: What You Need to Know](https://www.equationtech.us/sage-accpac-blog/sage-300-windows-10-end-of-life-what-you-need-to-know) There’s been a lot of conversation lately around Windows 10 end of life and what that means for... ##### [From Start-Up to Quarter Billion – How Sage 300 Scaled Success](https://www.equationtech.us/sage-accpac-blog/from-start-up-to-quarter-billion-how-sage-300-scaled-success) We also have a [video version](https://drive.google.com/file/d/1ssdM9iHt6Wz86A-VDvAER03NdXkAodg9/view?usp=sharing) of this article, where you can hear directly from one of our ERP... ##### [How to Simplify Payroll and Job Costing with Sage 300](https://www.equationtech.us/sage-accpac-blog/how-to-simplify-payroll-and-job-costing-with-sage-300) Getting payroll to play nice with your job costing system is like fitting a square peg into a round... ## Need Help Now? [![Request a Call](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/0d27fa16-1614-41b4-9caf-f9597d262c41.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/0d27fa16-1614-41b4-9caf-f9597d262c41) Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage HRMS](https://www.equationtech.us/sage-services/sage-hrms) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - [Sage Financials](https://www.equationtech.us/sage-services/sage-live) Services We Offer - [Software Selection & Licensing](https://www.equationtech.us/sage-services/erp-software-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Hosting](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) Resources - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Software Video Tutorials](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) About - [Meet The Team](https://www.equationtech.us/management-team) - [Certifications & Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) - [San Diego Location](https://www.equationtech.us/sage-300-support-san-diego) - [Orange County Location](https://www.equationtech.us/sage-300-support-orange-county) - [Seattle Location](https://www.equationtech.us/sage-300-support-seattle) [![Equation Technologies - Sage 300 Authorized Partner](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo-footer.png?width=220&name=logo-footer.png "Equation Technologies - Sage 300 Authorized Partner")](https://www.equationtech.us/) **Equation Technologies** United States: 533 2nd Street Encinitas, CA 92024 Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6 Phone: 866.436.3530  •  E-mail: [info@equationtech.us](mailto:info@equationtech.us) Equation Technologies ©2016 [Contact Us](https://www.equationtech.us/contact)  | [Privacy Policy](https://www.equationtech.us/privacy-policy) ```json { "@context" : "http://schema.org", "@type" : "Article", "author" : { "@type" : "Person", "name" : "Mark Badran" }, "dateModified" : "Wed, Oct 24, 2012", "datePublished" : "Wed, Oct 24, 2012", "description" : "Sage 300 (formerly Sage Accpac) blog with informative articles in reference to financial software processes and procedures including payroll taxes, training, product information, custom development.", "headline" : "How Does Sage 300 Crystal Reports Work?", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "//cdn2.hubspot.net/hub/41683/file-14051415-jpg/images/crystal_reports_11-resized-600.jpg", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/bid/90274/How-Does-Sage-300-Crystal-Reports-Work", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "height" : 60, "url" : "https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?t=1474998725496&width=230&name=logo.png", "width" : 600 }, "name" : "Equation Technologies Inc." } } ```