On the m-Power hotline, we sometimes field calls from developers who are trying to compute values based on subtotal or grand total values within their Reports. As you already know, m-Power Report templates, by default, will always add values vertically to compute sub-total and grand total values. As you can see here, m-Power is […]
Browse:
- Home
- Calculations
Working with Lengthy Fields
Working with Lengthy Fields m-Power has always easily handled fields of lengths less than 1000 characters. Beginning with the August 20th, 2012 update, fields of any length can be used within m-Power. When registering tables, simply add them as normal and the proper field lengths will be registered: Calculations also now support large field […]
Tags: Calculations, External Objects
Suppressing Calculation Error Messages
Suppressing Calculation Error Messages Click here to access legacy documentation for this feature When a developer creates a calculation, m-Power automatically takes the syntax of this calculation and attempts to run it directly on the database. If the database returns an error message, m-Power notifies the developer of the specific database error, and the developer […]
Tags: Calculations, Error Messages, Popular
Add/Subtract Dates using the Java Date Translator
Add/Subtract Dates using the Java Date Translator **Note: This Feature Has Been Deprecated. Please use this link to find alternative features: https://www.mrc-productivity.com/techblog/?p=522 The Java Date Translator is a very powerful tool, commonly used to determine the difference between two dates (Most date conversion can now be accomplished with a UDF). However, there is […]
Tags: Calculations, Dates, Java, Java Date Translator
Displaying System Variables at Run Time
Displaying System Variables within a Web Application There are numerous times when a developer needs to display System Variables within a Web Application. This can be done easily through the calculation screen. Simply create a System Variable Calculation. Simply select "System Value" from the "Calc Type" dropdown list. Next, specify a description for this […]
Tags: Calculations, System Variables
Parameter Calculations
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 […]
Runtime Calculations
Runtime Calculations Runtime Calculations are ideal for customers who wish to perform calculations like averages at the Subtotal Level, or finding a percent of a of Grand Total. For instance, let's say that we would like to pull up a list of Products and see their Month to Date units sold. I would also like […]
Tags: Calculations, m-Painter, Popular, Runtime Calculator
Copy Calculations within m-Power
Copy Calculations This feature allows you to copy preexisting calculations quickly within the same application. Whether you need to copy one or one hundred, this is an easy and effective way to mass produce similar calculations. Copying Calcs in Retrievals, Reports, and Maintenance Applications Enter the Calculations screen and create a calculation as you […]
Tags: Advanced, Calculations
Java Date Translator
Java Date Translator (External Object) **NOTE: This Functionality Has Been Deprecated. Please use this link to see alternative features: https://www.mrc-productivity.com/docs/external-objects-udf/mrc-date-conversion-udfs mrc supplies a date translator specifically for use with generated Web/Servlet applications. This Java class is named mrc.servlet.MrcDateTranslator and resides in mrcextobj.jar. The object definition is shown below. If this object definition is not […]
Tags: Calculations, Dates, Java, Java Date Translator
Search
Browse By Category
Build Process (14)Starting with m-Power (8)
Retrievals (10)
Reports (14)
Summaries (4)
Maintainers (18)
Graphs (8)
m-Power Data Explorer (4)
General (21)
Calculations (5)
Utilities (8)
m-Power Administration (20)
Security (11)
Freemarker (6)
m-Painter (27)
Form Validation (5)
External Objects & UDFs (11)
Deprecated Documentation (33)
Bootstrap Templates (7)