m-Power Reports and Retrievals allow users to export their data to Excel, a very popular feature of our platform. Occasionally, some developers desire to have the ability to control what formatting options their data has within Excel. For example, some users want their numeric data to be formatted as text when outputted to Excel. Developers … Continue reading Formatting Cells in Excel Output
Tag Archives: Report
Pivot Table Expand All
You can now give your users the option to expand all subtotal levels in your Pivot reports with one click. By setting the ‘display_subtotal_options’ property to ‘Display subtotal options’ within the Application Properties menu, your users will see this option at runtime. Enabling Feature on apps created before the August 2015 Update Open m-Painter and … Continue reading Pivot Table Expand All
How to: Create a Fixed Header Report
A few years ago, we published this Custom Template in our Project Exchange, allowing users the ability to have Fixed Column Headings in a standard report template. The power of this Custom Template is that it allows the column headings of a table to remain in the browser’s viewport no matter how far down the … Continue reading How to: Create a Fixed Header Report
Determining % Change in a Cross-Tab Report
Recently, I was using the Cross-Tab Template (If you haven’t already, I highly recommend you check it out at the Project Exchange). I had built my Cross-Tab template over my baseball statistics table. I was interested in examining the last 20 years of data for homeruns. Specifically, I wanted to know, at the team level, … Continue reading Determining % Change in a Cross-Tab Report