--- title: Creating a Custom Report using Minitab, part 1 description: Creating a Custom Report using Minitab, part 1 image: https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/capability-3.png --- English - [English](https://blog.minitab.com/en/?hsLang=en) - [Français](https://blog.minitab.com/fr/?hsLang=en) - [Deutsch](https://blog.minitab.com/de/?hsLang=en) - [Português](https://blog.minitab.com/pt/?hsLang=en) - [Español](https://blog.minitab.com/es/?hsLang=en) - [日本語](https://blog.minitab.com/ja/?hsLang=en) - [한국어](https://blog.minitab.com/ko/?hsLang=en) - [中文（简体）](https://blog.minitab.com/zh/?hsLang=en) - [![Icon Partners](https://blog.minitab.com/hubfs/WCM/Partners.png) Partners](https://www.minitab.com/en-us/company/partners/) - [![Icon Contact](https://blog.minitab.com/hubfs/WCM/Contact.png) Contact](https://www.minitab.com/en-us/company/contact-us/) - [![Icon Talk to Minitab](https://blog.minitab.com/hubfs/WCM/Phone.png) Talk to Minitab](https://www.minitab.com/en-us/talk-to-minitab/) - [![Icon My Account](https://blog.minitab.com/hubfs/WCM/MyAcct.png) My Account](https://licensing.minitab.com/account/manage) [![Minitab](https://blog.minitab.com/hubfs/WCM/minitab-corp-logo.svg)](https://www.minitab.com/en-us/) - Products Back [Products](https://www.minitab.com/en-us/products/) [All Products](https://www.minitab.com/en-us/products/) - [Minitab Solution Center](https://www.minitab.com/en-us/products/minitab-solution-center/) - [Minitab Statistical Software](https://www.minitab.com/en-us/products/minitab/) - [Minitab Connect](https://www.minitab.com/en-us/products/connect/) - [Minitab Model Ops](https://www.minitab.com/en-us/products/model-ops/) - [Minitab Education Hub](https://www.minitab.com/en-us/products/education-hub/) - [Minitab Engage](https://www.minitab.com/en-us/products/engage/) - [Minitab Workspace](https://www.minitab.com/en-us/products/workspace/) - [Real-Time SPC](https://www.minitab.com/en-us/products/real-time-spc/) - [Prolink Data Collection & SPC](https://www.minitab.com/en-us/products/prolink) - [Simul8 Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [SPM](https://www.minitab.com/en-us/products/spm/) - Solutions Back [Solutions](https://www.minitab.com/en-us/solutions/) [All Solutions](https://www.minitab.com/en-us/solutions/) - [Analytics](https://www.minitab.com/en-us/solutions/analytics/) - [Statistics & Predictive Analytics](https://www.minitab.com/en-us/solutions/analytics/statistical-analysis-predictive-analytics/) - [Data Science & Machine Learning](https://www.minitab.com/en-us/solutions/analytics/data-science-machine-learning/) - [Business Analytics & Intelligence](https://www.minitab.com/en-us/solutions/analytics/business-analytics-intelligence/) - [Statistical Process Control](https://www.minitab.com/en-us/solutions/analytics/statistical-process-control/) - [Quality Analytics](https://www.minitab.com/en-us/solutions/analytics/quality-analytics/) - [Live Analytics](https://www.minitab.com/en-us/solutions/analytics/live-analytics/) - [Reliability & Life Data Analysis](https://www.minitab.com/en-us/solutions/analytics/reliability/) - [Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [Process Mining](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [Key Capabilities](https://www.minitab.com/en-us/solutions/key-capabilities/) - [Continuous Improvement](https://www.minitab.com/en-us/solutions/key-capabilities/continuous-improvement/) - [Data Integration & Data Prep](https://www.minitab.com/en-us/solutions/key-capabilities/data-integration-data-prep/) - [Diagramming & Mind Mapping](https://www.minitab.com/en-us/solutions/key-capabilities/diagramming-mind-mapping/) - [Digital Twins](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [Model Deployment & ML Ops](https://www.minitab.com/en-us/solutions/key-capabilities/model-deployment-ml-ops/) - [Innovation & Project Management](https://www.minitab.com/en-us/solutions/key-capabilities/innovation-project-management/) - [Process Excellence: Detect, Correct & Prevent](https://www.minitab.com/en-us/solutions/key-capabilities/process-excellence/) - [Featured Industries](https://www.minitab.com/en-us/solutions/industry/) - [Academic](https://www.minitab.com/en-us/solutions/industry/academic/) - [Energy & Natural Resources](https://www.minitab.com/en-us/solutions/industry/energy-resources/) - [Government & Public Sector](https://www.minitab.com/en-us/solutions/industry/government/) - [Healthcare](https://www.minitab.com/en-us/solutions/industry/healthcare/) - [Insurance](https://www.minitab.com/en-us/solutions/industry/insurance/) - [Manufacturing & Industrial](https://www.minitab.com/en-us/solutions/industry/manufacturing-industrial/) - [Services](https://www.minitab.com/en-us/solutions/industry/service-industries/) - [Software & Technology](https://www.minitab.com/en-us/solutions/industry/software-technology/) - [Construction](https://www.minitab.com/en-us/solutions/industry/construction/) - [Featured Roles](https://www.minitab.com/en-us/solutions/role/) - [Engineering](https://www.minitab.com/en-us/solutions/role/engineering/) - [Business Analysis](https://www.minitab.com/en-us/solutions/role/business-analysts/) - [Information Technology](https://www.minitab.com/en-us/solutions/role/information-technology/) - [Supply Chain](https://www.minitab.com/en-us/solutions/role/supply-chain/) - [Customer Service & Contact Center](https://www.minitab.com/en-us/solutions/role/customer-service-contact-center/) - [Human Resources](https://www.minitab.com/en-us/solutions/role/human-resources/) - [Marketing](https://www.minitab.com/en-us/solutions/role/marketing/) - [Research and Development](https://www.minitab.com/en-us/solutions/role/research-and-development/) - Resources & Services Back [Resources & Services](https://www.minitab.com/en-us/resources-services/) [All Resources & Services](https://www.minitab.com/en-us/resources-services/) - [Resources](https://www.minitab.com/en-us/resources-services/resources/) - [Case Studies](https://www.minitab.com/en-us/resources-services/resources/case-studies/) - [eBooks & White Papers](https://www.minitab.com/en-us/resources-services/resources/ebooks-and-white-papers/) - [Blog](https://blog.minitab.com/blog/?hsLang=en) - [Data Sets](https://www.minitab.com/en-us/resources-services/resources/data-set/) - [Webinars & Events](https://www.minitab.com/en-us/resources-services/resources/events/) - [Education Hub](https://www.minitab.com/en-us/resources-services/resources/education-hub/) - [Services](https://www.minitab.com/en-us/resources-services/services/) - [Training](https://www.minitab.com/en-us/resources-services/services/training/) - [Deployment](https://www.minitab.com/en-us/resources-services/services/deployment/) - [Consulting](https://www.minitab.com/en-us/resources-services/services/statistical-consulting/) - [Self-Paced Learning](https://www.minitab.com/en-us/resources-services/services/self-paced-learning/) - [Continuing Education](https://www.minitab.com/en-us/resources-services/services/continuing-education/) - Support Back [Support](https://www.minitab.com/en-us/support/) [Technical Support](https://www.minitab.com/en-us/support/) - [Subscriptions & Activation](https://www.minitab.com/en-us/support/subscriptions-and-activation/) - [Minitab Quick Start](https://www.minitab.com/en-us/support/quick-start/) - [Training](https://www.minitab.com/en-us/resources-services/services/training/) - [Installation Support](https://www.minitab.com/en-us/support/installation/) - [Support Videos](https://www.minitab.com/en-us/support/videos/) - [Support Documentation](https://www.minitab.com/en-us/support/documents/) - [Software Updates](https://www.minitab.com/en-us/support/software-updates/) - [Product Downloads](https://www.minitab.com/en-us/support/downloads/) - [Support Policy](https://www.minitab.com/en-us/support/policy/) - Company Back [Company](https://www.minitab.com/en-us/company/) [Company](https://www.minitab.com/en-us/company/) - [About Us](https://www.minitab.com/en-us/company/our-company/) - [Leadership Team](https://www.minitab.com/en-us/company/leadership-team/) - [Partners](https://www.minitab.com/en-us/company/partners/) - [Careers](https://www.minitab.com/en-us/company/careers/) - [Contact](https://www.minitab.com/en-us/company/contact-us/) - [News](https://www.minitab.com/en-us/company/press-releases/) [Try/Buy](https://www.minitab.com/en-us/try-buy/) - [Statistics](https://blog.minitab.com/en/blog/tag/statistics) - [Data Analysis](https://blog.minitab.com/en/blog/tag/data-analysis) - - [Quality Improvement](https://blog.minitab.com/en/blog/tag/quality-improvement) - [Subscribe](https://info.minitab.com/blog/subscribe?hsLang=en) ![Minitab](https://20853177.fs1.hubspotusercontent-na1.net/hubfs/20853177/minitab-corp-logo.svg?t=1755011311618) ## Notice You are now leaving minitab.com. Click Continue to proceed to: Continue Go Back # Creating a Custom Report using Minitab, part 1 Minitab Blog Editor | 4/21/2014 - [Share](https://www.linkedin.com/shareArticle?mini=true&url=https://blog.minitab.com/en/blog/customized-data-analysis/creating-a-custom-report-using-minitab-part-1) - [Share](https://www.facebook.com/sharer.php?u=https://blog.minitab.com/en/blog/customized-data-analysis/creating-a-custom-report-using-minitab-part-1) As a member of Minitab’s Consulting and Custom Development Services team, I get to help companies across a variety of industries create many different types of reports for management. These reports often need to be generated weekly or monthly. I prefer to automate tasks like this whenever possible, so that new or updated reports can be created without much effort. A little investment up front can save a lot of time by eliminating the need to recreate the wheel every time management wants a current report.  I’m going to tell you how to use Minitab [Statistical Software](http://www.minitab.com/products/minitab) to automatically generate a report based on information retrieved from an external data source. But there’s a lot to cover, so I’ll have to do it in two posts. In this post, I’ll discuss automating analyses inside Minitab. In the next post I’ll demonstrate how to get Minitab “talking” to Microsoft Word programmatically using Minitab’s API. The end result will be a very simple automated report that exhibits the power of customization in Minitab. ## Requirements for a Capability Report ![capability graph](https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/capability-3.png)We’re going to create a simple Capability report based on some commonly used tools in the quality realm. Let’s start by breaking down what we need to make it: 1. First, we need data! We can automatically pull in the current month’s data from an Access database. I created my own Table in Access for this example, which you can [download here](https://cdn2.content.compendiumblog.com/uploads/user/458939f4-fe08-4dbc-b271-efca0f5a2682/479b4fbd-f8c0-4011-9409-f4109cc4c745/File/f40e1458eab9e9a462b6062c0c54cb3a/blogpost.accdb).   2. Next, we need to analyze the data. We’ll run three analyses and store the following results: 1. Normality Test → Store the P-Value associated with the Test. 2. Control Chart → Store how many data points are out of control. 3. Process Capability → Store the Cpk statistic. ## Generating the Minitab Code Now that we have our strategy for Minitab, let’s pull the data into Minitab programmatically.  Here is the Minitab Command Language we’ll use to import the data:  `ODBC; Connect "DSN=MS Access Database;DBQ=C:blogpost.accdb"; SQLString "SELECT Date,Yield FROM Yield where MONTH(Date)=Month(NOW())" & "and YEAR(Date)=YEAR(NOW())".` This may look like another language to you, and it sort of is.  So let’s break down what it says. The section below is a Connection String that tells Minitab where your database is, and how to connect to it: `Connect "DSN=MS Access Database;DBQ=C:blogpost.accdb";` (If you’re following along, you’ll need to alter the database location C:blogpost.accdb to reflect the location of the file on your machine.) The next section is just an SQL Statement in command language: `SQLString "SELECT Date, Yield FROM Yield WHERE MONTH(Date)=Month(NOW())" & "and YEAR(Date)=YEAR(NOW())".` If you look closely at the SELECT statement, you will notice we are pulling two fields (Date and Yield) from a Database table named Yield.  We also include this condition:  `WHERE MONTH(Date)=Month(NOW()) and YEAR(Date)=YEAR(NOW()).` Can you guess what the condition is doing?  If you guessed that it pulls data corresponding to the current month, you are correct. Of course, SQL statements can be much more complicated that this example. Fortunately, Minitab lets you use the SQL statement that best fits your needs, no matter how complex it may be.  Now that we’ve pulled the data in using Minitab Command Language, we need Minitab to run a few tests and create some charts. To run the [Normality test](https://blog.minitab.com/blog/the-statistical-mentor/normality-tests-and-rounding?hsLang=en) on Yield and store the p-value in column 3, the command language is: `Normtest Yield; Spvalue C3.` Pretty straightforward. Now let’s run the I-Chart and count how many points are out of control: `IChart Yield;   Stamp Date; # this command puts the Date on the X-axis of the chart   TResults C4.` `Sum C4 K1` The constant *K1* will now reflect how many points were out of control. For this Capability Analysis, we will assume the data is Normal and that the Yield of the product has a Lower Spec of 7 and an Upper Spec of 13.  We will store Cpk in column 5: `Capa Yield 1; # the number 1 signifies the subgroup size   Lspec 7;   Uspec 13;   CPK C5.` There you have it! We just imported the current month’s data and ran three analyses with the following command language: `ODBC;   Connect "DSN=MS Access Database;DBQ=C:blogpost.accdb";   SQLString "SELECT Date,Yield FROM Yield where MONTH(Date)=Month(NOW())" &   "and YEAR(Date)=YEAR(NOW())".` `Normtest Yield;   Spvalue C3.` `IChart Yield;   Stamp Date; # this command puts the Date on the X-axis of the chart   TResults C4.` `Sum C4 K1` `Capa Yield 1; # the number 1 signifies the subgroup size   Lspec 7;   Uspec 13;   CPK C5.` If you save the above command language in Notepad using the file extension *.mtb*, you will have a Minitab Exec.  You can run this file in Minitab by navigating to **File > Other Files > Run an Exec**. In the next blog post, I will describe how to utilize Minitab’s API in Visual Basic for Applications to generate the Capability Report.   --- - [Careers](https://www.minitab.com/en-us/company/careers/) - [Trust Center](https://www.minitab.com/en-us/trust-center/) - [Suppliers](https://www.minitab.com/en-us/suppliers/) - [Site Map](https://www.minitab.com/en-us/site-map/) - [![linkedin](https://blog.minitab.com/hubfs/WCM/linkedin-1.png)](https://www.linkedin.com/company/minitab/) - [![facebook](https://blog.minitab.com/hubfs/WCM/facebook.png)](https://www.facebook.com/Minitab/) - [![youtube](https://blog.minitab.com/hubfs/WCM/youtube.png)](https://www.youtube.com/user/MinitabInc) - [![instagram](https://blog.minitab.com/hubfs/WCM/instagram.png)](https://www.instagram.com/minitab/) --- © 2025 Minitab, LLC. All Rights Reserved. - [Terms of Use](https://www.minitab.com/en-us/legal/terms-of-use/) - [Privacy Policy](https://www.minitab.com/en-us/legal/privacy-policy/) - [Legal](https://www.minitab.com/en-us/legal/) - Cookies Settings