mrc logo mrc logo
  • m-Power m-Power
    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
  • Solutions Solutions
    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 and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    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

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

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


© 2024 mrc. All rights reserved.