{"id":149,"date":"2010-01-20T03:45:40","date_gmt":"2010-01-20T09:45:40","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=149"},"modified":"2017-06-12T11:59:21","modified_gmt":"2017-06-12T16:59:21","slug":"select-a-template","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/m-power-build-process\/select-a-template","title":{"rendered":"Select an Application Type and Template"},"content":{"rendered":"<p><!-- Begin Content --><\/p>\n<h1>Select an Application Type and Template<\/h1>\n<p>m-Power ships with over a dozen templates which gives you numerous options when deciding how an application should look and function. The first decision is what type of application to create. m-Power defines four general types: Retrievals, Reports, Summaries, and Maintenance Applications. Then, each of those application types has specific templates to select from. The templates define the general layout and functionality of the resulting application.<\/p>\n<p>To decide which type of application to create, ask this question: Will this application&#8230;<\/p>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td class=\"tablehead\">List multiple or single rows of data?<\/td>\n<td class=\"tablehead\">Show sub- or grand-total data levels?<\/td>\n<td class=\"tablehead\">Create a new data table?<\/td>\n<td class=\"tablehead\" style=\"border-right: none;\">Maintain data?<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata\">Build a <a href=\"#Retrievals\">Retrieval<\/a><br \/>\nApplication. Select one of these templates:<\/p>\n<ul>\n<li class=\"padleft\">Multiple Record Retrieval<\/li>\n<li class=\"padleft\">Single Record Retrieval<\/li>\n<li class=\"padleft\">Option List<\/li>\n<li class=\"padleft\">Row Level Security<\/li>\n<\/ul>\n<\/td>\n<td class=\"tabledata\">Build a <a href=\"#Reports\">Report<\/a><br \/>\nApplication. Select one of these templates:<\/p>\n<ul>\n<li class=\"padleft\">Report<\/li>\n<li class=\"padleft\">Report with Graph<\/li>\n<li class=\"padleft\">Ranking Report with Graph<\/li>\n<li class=\"padleft\">Interactive Report<\/li>\n<li class=\"padleft\">OLAP Pivot Table<\/li>\n<li class=\"padleft\">Cross Tab Report<\/li>\n<\/ul>\n<\/td>\n<td class=\"tabledata\" valign=\"top\">Build a <a href=\"#Summaries\">Summary<\/a><br \/>\nApplication. Select this template:<\/p>\n<ul>\n<li class=\"padleft\">Summary<\/li>\n<\/ul>\n<\/td>\n<td class=\"tabledata\" style=\"border-right: none;\">Build a <a href=\"#Maintenance\">Maintenance<\/a><br \/>\nApplication. Select one of these templates:<\/p>\n<ul>\n<li class=\"padleft\">Display and Maintain Row Maintenance<\/li>\n<li class=\"padleft\">Single Row Maintenance<\/li>\n<li class=\"padleft\">Grid Add Maintenance<\/li>\n<li class=\"padleft\">Grid Update Maintenance<\/li>\n<li class=\"padleft\">Re-order Maintenance<\/li>\n<li class=\"padleft\">Data Upload Maintenance<\/li>\n<li class=\"padleft\">Display and Maintain Calendar<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Once you know which type of application to create, then you need to choose which template to use.<\/p>\n<p class=\"titlebold\"><a class=\"anchor\" name=\"Retrievals\"><\/a>Retrieval Templates<\/p>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td class=\"tablehead\" colspan=\"3\">Retrieval Templates<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" width=\"150px\" height=\"149px\">Multiple Record Retrieval<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Multiple Record Retrieval\" alt=\"\" src=\"\/legacy\/images\/mri_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Provide a paginated list.<\/li>\n<li class=\"padleft\">Filter and sort rows.<\/li>\n<li class=\"padleft\">Create SmartLinks to drill-down into other apps for more detail.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Single Record Retrieval<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Single Record Retrieval\" alt=\"\" src=\"\/legacy\/images\/sri_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Show exactly one record at a time.<\/li>\n<li class=\"padleft\">Infinite layout options to show even the most complex data clearly.<\/li>\n<li class=\"padleft\">Import related info into other apps.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Option List Retrieval<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Option List Retrieval\" alt=\"\" src=\"\/legacy\/images\/opt_sky.png\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Build drop-down lists\/radio button objects that can be used in any other application.<\/li>\n<li class=\"padleft\">Control what values are shown to the user and which are submitted to the database.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Row Level Security<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Row Level Security\" alt=\"\" src=\"\/legacy\/images\/rowlvlsec_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Build a retrieval over data that can be used for validation in any other application.<\/li>\n<li class=\"padleft\">Allows different users to see different data in the same application.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"titlebold\"><a class=\"anchor\" name=\"Reports\"><\/a>Report Templates<\/p>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td class=\"tablehead\" colspan=\"3\">Report Templates<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" width=\"150px\" height=\"149px\">Prompted Report<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Prompted Report\" alt=\"\" src=\"\/legacy\/images\/report_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Display sub- and grand-total values.<\/li>\n<li class=\"padleft\">Numerous output types: HTML, Excel, PDF, email, and more.<\/li>\n<li class=\"padleft\">Separate prompt screen for user inputs.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Report with Graph<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Report with Graph\" alt=\"\" src=\"\/legacy\/images\/graph_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Same features as the Report Template, plus the ability to graph.<\/li>\n<li class=\"padleft\">Bar, pie, line or speedometer chart.<\/li>\n<li class=\"padleft\">Enable drill-down through the graphed values.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Ranking Report<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Ranking Report\" alt=\"\" src=\"\/legacy\/images\/rank_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Automatically list top results based on user-selected options like dimension and record selections.<\/li>\n<li class=\"padleft\">Report the results on the output screen.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Interactive Report<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Interactive Report\" alt=\"\" src=\"\/legacy\/images\/irt_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">AJAX-executed report provides a connected feel experience.<\/li>\n<li class=\"padleft\">Automatically drill-down into lower level of details within the same report.<\/li>\n<li class=\"padleft\">Smart selections show related\/unrelated data as selections are made.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">OLAP Pivot Table<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"OLAP Pivot Table\" alt=\"\" src=\"\/legacy\/images\/OLAP_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Allows users to control both the row and column for a report.<\/li>\n<li class=\"padleft\">Automatically totals all rows and columns to spot trends within data.<\/li>\n<li class=\"padleft\">Interactive graph where users can change graph types and values.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Cross Tab Report<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Cross Tab Report\" alt=\"\" src=\"\/legacy\/images\/crosstab_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Allows users to control both the row and column for a report.<\/li>\n<li class=\"padleft\">Allows custom painting in m-Painter.<\/li>\n<li class=\"padleft\">Can be generated to Excel\/PDF or run in batch.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"titlebold\"><a class=\"anchor\" name=\"Summaries\"><\/a>Summary Template<\/p>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td class=\"tablehead\" colspan=\"3\">Summary Template<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" width=\"150px\" height=\"149px\">Summary<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Summary\" alt=\"\" src=\"\/legacy\/images\/sum_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Produce data marts for Business Intelligence and Dashboard apps.<\/li>\n<li class=\"padleft\">Run batch-capable apps with built-in scripting and scheduling.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"titlebold\"><a class=\"anchor\" name=\"Maintenance\"><\/a>Maintenance Templates<\/p>\n<table class=\"datatable\">\n<tbody>\n<tr>\n<td class=\"tablehead\" colspan=\"3\">Maintenance Templates<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" width=\"150px\" height=\"149px\">Display and Maintain Row Maintenance<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Display and Maintain Row Maintenance\" alt=\"\" src=\"\/legacy\/images\/dmr_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Users can view, copy, update, delete, and create new records.<\/li>\n<li class=\"padleft\">Perfect for master-table maintenance.<\/li>\n<li class=\"padleft\">Developers control which functions are available.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Single Row Maintenance<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Single Row Maintenance\" alt=\"\" src=\"\/legacy\/images\/srm_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Enable update of one record at a time.<\/li>\n<li class=\"padleft\">Create a prompt screen to front other screens or server-side functions.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Grid Add Maintenance<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Grid Add Maintenance\" alt=\"\" src=\"\/legacy\/images\/gridadd_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Enable users to add multiple records at one time to a database table.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Grid Update Maintenance<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Grid Update Maintenance\" alt=\"\" src=\"\/legacy\/images\/gridupd_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Enable update and delete of multiple records at one time.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Re-order Maintenance<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Re-order Maintenance\" alt=\"\" src=\"\/legacy\/images\/reorder_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Users interact with an intuitive drag and drop interface to re-order rows within a table, resetting sequence values in the affected row.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Data Upload Maintenance<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Data Upload Maintenance\" alt=\"\" src=\"\/legacy\/images\/dataupload_sky.jpg\" \/><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">Allows users to upload spreadsheets and external data directly into the database.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"tabledata2\" height=\"149px\">Display and Maintain Calendar<\/td>\n<td class=\"tabledata2\"><img decoding=\"async\" class=\"alignimg\" title=\"Display and Maintain Calendar\" alt=\"\" src=\"\/legacy\/images\/cal_sky.jpg\"><\/td>\n<td class=\"tabledata2\">\n<ul>\n<li class=\"padleft\">View, add, edit, or delete any date-related data in a familiar calendar format.<\/li>\n<li class=\"padleft\">Filter records.<\/li>\n<li class=\"padleft\">Color code entries based on any criteria.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Click <a href=\"https:\/\/www.mrc-productivity.com\/legacy\/getting-started\/more-questions\">here<\/a> to read some common m-Power questions.<\/p>\n<p><!-- End Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select an Application Type and Template m-Power ships with over a dozen templates which gives you numerous options when deciding how an application should look and function. The first decision is what type of application to create. m-Power defines four general types: Retrievals, Reports, Summaries, and Maintenance Applications. Then, each of those application types has [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":5340,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-149","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=149"}],"version-history":[{"count":19,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/149\/revisions"}],"predecessor-version":[{"id":8259,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/149\/revisions\/8259"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/5340"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}