“In my Servlet Report, I want to change some of my subtotal values. For example, let's say I want my subtotal level to reflect averages rather than totals.

After editing my HTML Skeleton, my output in the HTML format is consistent with my changes. But, when I run the report in the CSV format none of my changes are present.

What am I doing wrong?”

As you'll see on the IFS there are multiple objects for one mrc Servlet Report. When you changed the Rxxxxx.html (where xxxxx is your application number) it only controlled the formatting for the HTML output. The Rxxxxx.xml controls the formatting for the XML and CSV files.

For this example, in the subtotal level of your CSV Report, you want to change the MTD Sales Units (MTDUD) to do an average instead of a total, so you'll need to do the following.

1. Locate your Rxxxxx.xml file in one of the following IFS locations, which is based on Application Server.

Tomcat:
/mrcjava/WEB-INF/classes/your-dictionary

WAS 5.0:
\QIBM\UserData\WebASE\ASE5\your-instance\installedApps\your-host-name_your-instance\mrcjava.ear\mrcjava.war\WEB-INF\classes\your-dictionary

WAS 5.1:
\QIBM\UserData\WebASE51\ASE\your-instance\installedApps\your-host-name_your-instance\mrcjava.ear\mrcjava.war\WEB-INF\classes\your-dictionary

2. In the subtotal level, change the substitution parameter for the MTD Sales Unit field (MTDUD). Our default in the subtotals is to total the fields so you'd find F_S_TI_MTDUD for this field, change this value to F_S_AN_MTDUD and it will average the field.

Have a hotline question of your own? Send an e-mail to support@mrc-productivity.com and let our product specialists help you!