Support Section / Tech Blog / Rick
Page 4 of 7« First23456Last »

Rick

Author's details

Name: Rick Hurckes
Date registered: September 30, 2011

Latest posts

  1. Tomcat 7 Special Server Config — October 3, 2012
  2. Install Tomcat 7 on the iSeries — June 22, 2012
  3. Install Tomcat 7 on Linux — June 20, 2012
  4. Installing Tomcat 7 on Windows (Manually) — June 19, 2012
  5. Logging Signon/Signoff Activity — June 8, 2012

Most commented posts

  1. How to Refresh Page when called via the Back Button — 6 comments
  2. Removing AS400 Journals and Journal Receivers — 1 comment
  3. Google Geochart Visualization Template — 1 comment
  4. Determining % Change in a Cross-Tab Report — 1 comment
  5. How to: Create a Fixed Header Report — 1 comment

Author's posts listings

Removing AS400 Journals and Journal Receivers

by

When a new data dictionary is created via m-Power, we utilize SQL to create a new database schema (sometimes called a data library) and populate it with the necessary tables to make a working data dictionary. If you are using m-Power to connect to an iSeries (AS400) database, most likely you will notice that along… Continue reading »

Tags: , ,

Create Drop-down List that includes Item Count (SQL Override)

by

I was recently building a demo for our website and I needed to create a drop-down list of products for my user to select from a report. I couldn’t use the built-in drop-down list feature as my list was not optimized (The table has over 70K records!). Additionally, I wanted to create the drop-down list… Continue reading »

This post has no tag

Record Selections in Excel Output

by

I noticed that a handful of users have been asking through our Hotline that they would like to be able to output to Excel, but also include the Record Selection Summary box at the top of the report. In their cases, it is quite helpful for them to be able to not only see the… Continue reading »

Tags: ,

Batch E-mail Dynamic Users

by

As you are already familiar, you can utilize batch job streams to fire off summaries, reports, and e-mails in the overnight hours, completely automated. If not, you can check out this documentation which explains the topic in great detail. The default batch job stream process requires that you hard-code a list of users to be… Continue reading »

Tags: , , ,

Determining % Change in a Cross-Tab Report

by

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 »

Tags: , , ,

Page 4 of 7« First23456Last »