Skip to Content mrc logo mrc logo
  • What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the Web MS Access to the Web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs & Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Development Services Training Mentoring
  • Overview Partners Press Releases Careers Events Contact Blog
  • Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Calculations
  • Parameter Calculations
Back to Manual

Parameter Calculations

 

Parameter calculations are a great technique when you are trying to pass a value between multiple applications. For example, you would like to pass a value from the prompt page or URL to the output page to determine some conditional calculations. In our case, our calculation would accept a value, then a conditional calculation would determine what to print in our table data based on the parameter calc.

How to Work with Parameter Calculations

The key to parameter calculation fields is that when you create it, you are merely creating a holder that will hold a value for later. In our case, the "later" will be when the value is passed via the prompt page.

To create this place holder, go to the Calculations screen. At the calculation definition screen, enter your description field. For length and decimal, choose appropriate values (In our case, our output needs to be 2 alpha). Lastly, select "Parameter" from the Calc Type dropdown list.

Next, setup your conditional calculation to best fit your needs. For our example, we will say that if the value passed to CALCULA001 is "IL" then our Calculation will read "ILLINOIS", if not it will say "OTHER STATE".

To have enter your value at the prompt page, add a Record Selection and choose CALCULA001 from the Field dropdown list. Once selected, the page will automatically change to have your parameter calc as a Runtime value prompt. Here you may enter a default value as well.

Make any other needed changes to your application and then click build/compile.

If wanting to enter your value through the URL, when you run your application, simply add CALCULA001=IL&run=2 to the URL, and press enter. Based on the value you've passed in the URL, you can control your Conditional calculation.

Created: February 29, 2008 | Modified: June 12, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

m-Painter RPG Graph Properties Form Validation DB2 Bar Graphs SQL Summaries Video Excel Record Selections Retrieval Calculations mrc-Productivity Series Retrievals Security App Properties Prompt Screens Email Graphs Tomcat Dropdowns Getting Started External Objects Reports Compiling Performance Graphing Popular Maintainer Parameters Advanced Administration Data Dictionary Application Properties Database Bootstrap Templates Dates Production Java Report Admin Maintainers Freemarker Build Process

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© mrc. All rights reserved.