Wednesday, October 22, 2008

Report Formatting Wrong with FRx 6.7 SP 10

If you have FRx reports that have the currency symbol ($) on the first and last rows and percentage columns as well as amount columns, I recommend that FRx 6.7 SP10 not be installed. With this service pack, the CS Print Control on a row in a row format will over ride the formatting in the column layouts. Therefore, the percentages will be shown as amounts on the last row (or any other row with CS in the Print Control field). Also, any row with CS will show the amounts with 2 decimals, even if the report is set to round on the catalog. One fix is to take the CS off of the row format and put a special format mask on the amount columns in the column layout. However, this will cause the $ to be on every row of the report.

Microsoft has identified this as bug 212217. Their response to me regarding this problem if you have installed SP 10 is as follows:
Workarounds 1 and 2 that I have included below apply to this bug.

Workaround 1:
You can export the report to Excel and manually edit the numbers.

Workaround 2:
You can uninstall FRx using the attached 'How to Uninstall FRx.doc' and Reinstall FRx 6.7 SP 9 using the attached 'FRx67GPInstall.pdf'.

You can download the FRx 6.7 with SP 9 installer (file name: FRx674GP10FullInstall.zip) at the link below:

https://mbs.microsoft.com/fileexchange/?fileID=9360d805-b22b-4e28-907a-35c4a7c23ca0

I would advise you to make a backup of your SysData folder before this process as well as Export .TDB's of each of your production Specifications Sets.

0 Comments:

Post a Comment

<< Home