If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Erroneous format pattern

Started by wyconian, 14 Jun 2010 03:31:40 AM

Previous topic - Next topic

wyconian

Hi all

I've inherited a report from a previous colleague who has now left.  It's a cross tab with just one measure.  The measure is being displayed on the report as (for example) 123,456k.  I'm trying to remove the K.

The problem is I can't find where the K is being applied.  I've checked the data item format in the report and the format in the FM model.  No formatting has been applied, everything is set to default apart from the scale which is set to -3.

The data in the database doesn't have the K.

To make it even more confusing if I bring the same data item into a list report the K doesn't appear.

Anyone have any idea why this is happening or where else I should look to find the formatting?

Any help very appreciated.

Thanks

Simon

MFGF

It it a crafty hack by the author where he/she unlocked the structure of the crosstab and dropped a text item set to the letter 'k' into the cell after the measure value?

Obviously, the -3 scale will set the measure to display thousands...

MF.
Meep!

wyconian

Thanks for the reply.  I thought of that as well but they didn't unlock the cell and add a 'k'.

I completely stummped on this one

MFGF

Can you post up the xml for the report?
Meep!

wyconian

MF

This is the xml for the report

- <report xmlns="http://developer.cognos.com/schemas/report/3.0/" expressionLocale="en-gb">
- <!-- RS:8.2
  -->
  <modelPath>/content/package[@name='FSA Supervision']/model[@name='model']</modelPath>
- <layouts>
- <layout>
- <reportPages>
- <page class="pg" name="Page1">
- <pageBody class="pb">
- <contents>
- <crosstab class="xt" refQuery="Query1">
- <crosstabCorner class="xm">
  <contents />
  </crosstabCorner>
- <crosstabRowNodeStyle>
- <style>
  <CSS value="background-color:silver;color:black;font-family:Arial;font-weight:bold" />
  </style>
  </crosstabRowNodeStyle>
- <crosstabColumnNodeStyle>
- <style>
  <CSS value="background-color:silver;color:black;font-family:Arial;font-weight:bold" />
  </style>
  </crosstabColumnNodeStyle>
- <style>
  <CSS value="border-collapse:collapse" />
  </style>
- <crosstabColumns>
- <crosstabNode>
- <crosstabNodeMembers>
- <crosstabNodeMember refDataItem="EORP" class="ml">
- <contents>
- <textItem>
- <dataSource>
  <memberCaption />
  </dataSource>
  </textItem>
  </contents>
  </crosstabNodeMember>
  </crosstabNodeMembers>
  </crosstabNode>
  </crosstabColumns>
- <crosstabFactCell class="mv">
- <contents>
- <textItem>
- <dataSource>
  <cellValue />
  </dataSource>
  </textItem>
  </contents>
  </crosstabFactCell>
- <crosstabRows>
- <crosstabNode>
- <crosstabNodeMembers>
- <crosstabNodeMember refDataItem="MLH058" class="ml">
- <contents>
- <textItem>
- <dataSource>
  <memberCaption />
  </dataSource>
  </textItem>
  </contents>
  </crosstabNodeMember>
  </crosstabNodeMembers>
  </crosstabNode>
  </crosstabRows>
  </crosstab>
- <list class="ls" refQuery="Query1">
- <style>
  <CSS value="border-collapse:collapse" />
  </style>
- <listColumns>
- <listColumn>
- <listColumnTitle class="lt">
- <contents>
- <textItem>
- <dataSource>
  <dataItemLabel refDataItem="EORP" />
  </dataSource>
  </textItem>
  </contents>
  </listColumnTitle>
- <listColumnBody class="lc">
- <contents>
- <textItem>
- <dataSource>
  <dataItemValue refDataItem="EORP" />
  </dataSource>
  </textItem>
  </contents>
  </listColumnBody>
  </listColumn>
- <listColumn>
- <listColumnTitle class="lt">
- <contents>
- <textItem>
- <dataSource>
  <dataItemLabel refDataItem="MLH058" />
  </dataSource>
  </textItem>
  </contents>
  </listColumnTitle>
- <listColumnBody class="lm">
- <contents>
- <textItem>
- <dataSource>
  <dataItemValue refDataItem="MLH058" />
  </dataSource>
  </textItem>
  </contents>
  </listColumnBody>
  </listColumn>
  </listColumns>
  </list>
  </contents>
+ <style>
  <CSS value="text-align:center" />
  </style>
  </pageBody>
- <pageHeader class="ph">
- <contents>
- <HTMLItem>
- <dataSource>
  <staticValue><script language="JavaScript1.2"> top.window.moveTo(0,0); if (document.all) { top.window.resizeTo(screen.availWidth,screen.availHeight); } else if (document.layers || document.getElementById) { if (top.window.outerHeight < screen.availHeight || top.window.outerWidth < screen.availWidth) { top.window.outerHeight = top.screen.availHeight; top.window.outerWidth = top.screen.availWidth; } } </script></staticValue>
  </dataSource>
  </HTMLItem>
- <block class="ta">
- <contents>
- <table class="tb">
- <tableRows>
- <tableRow>
- <tableCells>
- <tableCell class="cls2">
- <contents>
- <textItem>
- <dataSource>
  <staticValue>FSA Restricted</staticValue>
  </dataSource>
- <style>
  <CSS value="font-style:italic;font-weight:bold;color:#330066" />
  </style>
  </textItem>
  </contents>
- <style>
  <CSS value="width:10%" />
  </style>
  </tableCell>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <staticValue />
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="width:10%" />
  </style>
  </tableCell>
- <tableCell class="SP_CLS1">
- <contents>
- <textItem class="SP_CLS1">
- <dataSource>
  <staticValue>Report Title</staticValue>
  </dataSource>
- <style>
  <CSS value="color:#330066" />
  </style>
  </textItem>
  </contents>
- <style>
  <CSS value="color:#330066;font-family:Arial;font-size:14pt;font-weight:bold;vertical-align:middle;text-align:center" />
  </style>
  </tableCell>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <staticValue />
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="width:10%" />
  </style>
  </tableCell>
- <tableCell>
- <contents>
- <layoutComponentRef refLayoutElement="Image-FSA_logo_46pix">
- <reportPath path="/content/folder[@name='BI Administration']/folder[@name='KM Content']/folder[@name='Templates']/report[@name='Images']">
- <XMLAttributes>
  <XMLAttribute name="ReportName" value="Images" render="false" />
  </XMLAttributes>
  </reportPath>
  </layoutComponentRef>
  </contents>
- <style>
  <CSS value="vertical-align:top;text-align:right;width:10%" />
  </style>
  </tableCell>
  </tableCells>
  </tableRow>
- <tableRow>
- <tableCells>
- <tableCell>
  <contents />
  </tableCell>
- <tableCell>
  <contents />
  </tableCell>
- <tableCell class="cls1">
- <contents>
- <textItem>
- <dataSource>
  <staticValue>Report Parameters</staticValue>
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="font-family:Arial;font-size:12pt;font-weight:bold;color:#330066;vertical-align:middle;text-align:center" />
  </style>
  </tableCell>
- <tableCell>
  <contents />
  </tableCell>
- <tableCell>
  <contents />
  </tableCell>
  </tableCells>
  </tableRow>
  </tableRows>
- <style>
  <CSS value="border-collapse:collapse;width:100%" />
  </style>
  </table>
  </contents>
  </block>
  </contents>
- <style>
  <CSS value="padding-bottom:10px" />
  </style>
  </pageHeader>
- <pageFooter class="pf">
- <contents>
- <table class="tb">
- <tableRows>
- <tableRow>
- <tableCells>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <staticValue>Report ran on:</staticValue>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <reportExpression>AsOfDate( )</reportExpression>
  </dataSource>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue />
  </dataSource>
  </textItem>
- <textItem>
- <dataSource>
  <reportExpression>AsOfTime( )</reportExpression>
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="vertical-align:middle;text-align:left;width:40%;padding-bottom:5px" />
  </style>
  </tableCell>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <reportExpression>PageNumber( )</reportExpression>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue>of</staticValue>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <reportExpression>PageCount( )</reportExpression>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
  </contents>
- <style>
  <CSS value="vertical-align:middle;text-align:center;width:20%;padding-bottom:5px" />
  </style>
  </tableCell>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <staticValue>Business Owner:</staticValue>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue>DEPT</staticValue>
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="vertical-align:middle;text-align:right;width:40%;padding-bottom:5px" />
  </style>
  </tableCell>
  </tableCells>
  </tableRow>
- <tableRow>
- <tableCells>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <staticValue>Last Modified:</staticValue>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue>DAY-MONTH-YEAR</staticValue>
  </dataSource>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue>Report Version:</staticValue>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue>1.0</staticValue>
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="padding-top:5px;vertical-align:middle;text-align:left" />
  </style>
  </tableCell>
- <tableCell>
  <contents />
- <style>
  <CSS value="vertical-align:middle;text-align:center;padding-top:5px" />
  </style>
  </tableCell>
- <tableCell>
- <contents>
- <textItem>
- <dataSource>
  <staticValue>Report Author:</staticValue>
  </dataSource>
- <style>
  <CSS value="font-weight:bold" />
  </style>
  </textItem>
- <textItem>
- <dataSource>
  <staticValue>NAME</staticValue>
  </dataSource>
  </textItem>
  </contents>
- <style>
  <CSS value="vertical-align:middle;text-align:right;padding-top:5px" />
  </style>
  </tableCell>
  </tableCells>
  </tableRow>
  </tableRows>
- <style>
  <CSS value="border-collapse:collapse;font-family:Verdana;font-size:7pt;border-top-style:none;border-bottom-style:none;border-left-style:none;border-right-style:none;width:100%" />
  </style>
  </table>
  </contents>
- <style>
  <CSS value="padding-top:10px" />
  </style>
  </pageFooter>
  </page>
  </reportPages>
  </layout>
  </layouts>
- <classStyles>
- <classStyle name="SP_CLS1" label="FSA Report Header">
  <CSS value="font-family:Arial;font-size:14pt;font-weight:bold;color:#330066;text-align:center;vertical-align:middle" />
  </classStyle>
- <classStyle name="cls3" label="FSA Column Title">
  <CSS value="background-color:silver;font-family:Arial;font-weight:bold;color:black" />
  </classStyle>
- <classStyle name="cls1" label="FSA Sub Header">
  <CSS value="font-family:Arial;font-size:12pt;font-weight:bold;color:#330066" />
  </classStyle>
- <classStyle name="cls2" label="FSA Restricted">
  <CSS value="font-family:Arial;font-size:10pt;font-weight:bold;color:#330066;text-align:left;vertical-align:middle" />
  </classStyle>
  </classStyles>
- <queries>
- <query name="Query1">
- <source>
  <model />
  </source>
- <selection>
- <dataItem name="EORP" aggregate="none">
  <expression>[Returns].[FOL Return Header].[EORP]</expression>
  </dataItem>
- <dataItem name="MLH058" aggregate="total">
  <expression>[Returns].[Section H: Mortgage Administration: Arrears Analysis].[MLH058]</expression>
  </dataItem>
  </selection>
- <detailFilters>
- <detailFilter>
  <filterExpression>[Firm].[Firms].[FRN] = '121882'</filterExpression>
  </detailFilter>
  </detailFilters>
  </query>
  </queries>
  </report>

Looks pretty standard to me

CognosPaul

You should use Tools --> Copy Report to Clipboard instead of Show Specifications. All of those dashes prevent people from being able to open the report.

If you recreate the crosstab from scratch, does it still show the K?

wyconian

Sorry I asked someone to send that to me, should have known better.

I've just written a section of the report myself and the K still appears.

This is the report

<report xmlns="http://developer.cognos.com/schemas/report/3.0/" expressionLocale="en-gb"><!--RS:8.2-->
   <modelPath>/content/package[@name='FSA Supervision']/model[@name='model']</modelPath>
   <layouts>
      <layout>
         <reportPages>
            <page class="pg" name="Page1">
               <pageBody class="pb">
                  <contents>
                     <crosstab class="xt" refQuery="Query1">
                        <crosstabCorner class="xm"><contents><textItem><dataSource><dataItemLabel refDataItem="MLH058"/></dataSource></textItem></contents></crosstabCorner>
                        <crosstabRowNodeStyle><style><CSS value="background-color:silver;color:black;font-family:Arial;font-weight:bold"/></style></crosstabRowNodeStyle>
                        <crosstabColumnNodeStyle><style><CSS value="background-color:silver;color:black;font-family:Arial;font-weight:bold"/></style></crosstabColumnNodeStyle>
                        <style>
                           <CSS value="border-collapse:collapse"/>
                        </style>
                     <crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="FRN" class="ml"><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="EORP" class="ml"><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><defaultMeasure refDataItem="MLH058"/><crosstabFactCell class="mv"><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents></crosstabFactCell></crosstab>
                  </contents>
                  <style><CSS value="text-align:center"/></style></pageBody>
               <pageHeader class="ph">
                  <contents>
                     <HTMLItem>
                        <dataSource>
                           <staticValue>&lt;script language="JavaScript1.2"&gt;
top.window.moveTo(0,0);
if (document.all)
   { top.window.resizeTo(screen.availWidth,screen.availHeight); }
else if
   (document.layers || document.getElementById)
   {
   if
    (top.window.outerHeight &lt; screen.availHeight || top.window.outerWidth &lt;
screen.availWidth)
     { top.window.outerHeight = top.screen.availHeight;
       top.window.outerWidth = top.screen.availWidth; }
   }
&lt;/script&gt;</staticValue>
                        </dataSource>
                     </HTMLItem>
                     <block class="ta">
                        <contents>
                           <table class="tb"><tableRows><tableRow><tableCells><tableCell class="cls2"><contents><textItem><dataSource><staticValue>FSA Restricted</staticValue></dataSource><style><CSS value="font-style:italic;font-weight:bold;color:#330066"/></style></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>
                                                   </staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell class="SP_CLS1"><contents><textItem class="SP_CLS1">
                                                <dataSource>
                                                   <staticValue>Report Title</staticValue>
                                                </dataSource>
                                                <style><CSS value="color:#330066"/></style></textItem></contents><style><CSS value="color:#330066;font-family:Arial;font-size:14pt;font-weight:bold;vertical-align:middle;text-align:center"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>
                                                   </staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><layoutComponentRef refLayoutElement="Image-FSA_logo_46pix"><reportPath path="/content/folder[@name='BI Administration']/folder[@name='KM Content']/folder[@name='Templates']/report[@name='Images']"><XMLAttributes><XMLAttribute name="ReportName" value="Images" render="false"/></XMLAttributes></reportPath></layoutComponentRef></contents><style><CSS value="vertical-align:top;text-align:right;width:10%"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell><tableCell class="cls1"><contents><textItem><dataSource><staticValue>Report Parameters</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12pt;font-weight:bold;color:#330066;vertical-align:middle;text-align:center"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;width:100%"/></style></table>
                        </contents>
                     </block>
                  </contents>
                  <style>
                     <CSS value="padding-bottom:10px"/>
                  </style>
               </pageHeader>
               <pageFooter class="pf">
                  <contents>
                     <table class="tb"><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Report ran on: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><reportExpression>AsOfDate( ) </reportExpression></dataSource></textItem><textItem><dataSource><staticValue>
                                             </staticValue></dataSource></textItem><textItem><dataSource><reportExpression>AsOfTime( ) </reportExpression></dataSource></textItem></contents><style><CSS value="vertical-align:middle;text-align:left;width:40%;padding-bottom:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><reportExpression>PageNumber( ) </reportExpression></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><staticValue> of </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><reportExpression>PageCount( ) </reportExpression></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents><style><CSS value="vertical-align:middle;text-align:center;width:20%;padding-bottom:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Business Owner: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><staticValue>DEPT</staticValue></dataSource></textItem></contents><style><CSS value="vertical-align:middle;text-align:right;width:40%;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Last Modified: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><staticValue>DAY-MONTH-YEAR </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Report Version: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><staticValue>1.0</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;vertical-align:middle;text-align:left"/></style></tableCell><tableCell><contents/><style><CSS value="vertical-align:middle;text-align:center;padding-top:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Report Author: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem><textItem><dataSource><staticValue>NAME</staticValue></dataSource></textItem></contents><style><CSS value="vertical-align:middle;text-align:right;padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;font-family:Verdana;font-size:7pt;border-top-style:none;border-bottom-style:none;border-left-style:none;border-right-style:none;width:100%"/></style></table></contents>
                  <style>
                     <CSS value="padding-top:10px"/>
                  </style>
               </pageFooter>
            </page>
         </reportPages>
         <promptPages><page class="pp" name="Prompt Page1">
               <pageHeader class="hp">
                  <contents>
                     <HTMLItem>
                        <dataSource>
                           <staticValue>&lt;script language="JavaScript1.2"&gt;
top.window.moveTo(0,0);
if (document.all)
   { top.window.resizeTo(screen.availWidth,screen.availHeight); }
else if
   (document.layers || document.getElementById)
   {
   if
    (top.window.outerHeight &lt; screen.availHeight || top.window.outerWidth &lt;
screen.availWidth)
     { top.window.outerHeight = top.screen.availHeight;
       top.window.outerWidth = top.screen.availWidth; }
   }
&lt;/script&gt;</staticValue>
                        </dataSource>
                     </HTMLItem><block class="ta">
                        <contents>
                           <table class="tb"><tableRows><tableRow><tableCells><tableCell class="cls2"><contents><textItem><dataSource><staticValue>FSA Restricted</staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>
                                                   </staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell class="SP_CLS1"><contents><textItem class="SP_CLS1">
                                                <dataSource>
                                                   <staticValue>Report Title</staticValue>
                                                </dataSource>
                                             </textItem>
                                          </contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>
                                                   </staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><layoutComponentRef refLayoutElement="Image-FSA_logo_46pix"><reportPath path="/content/folder[@name='BI Administration']/folder[@name='KM Content']/folder[@name='Templates']/report[@name='Images']"><XMLAttributes><XMLAttribute name="ReportName" value="Images" render="false"/></XMLAttributes></reportPath></layoutComponentRef></contents><style><CSS value="vertical-align:top;text-align:right;width:10%"/></style></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;width:100%"/></style></table></contents>
                     </block>
                  </contents>
               </pageHeader>
               <pageBody class="py">
                  <contents><HTMLItem>
                        <dataSource>
                           <staticValue>&lt;span title = " "&gt;</staticValue>
                        </dataSource>
                     </HTMLItem>
                     <layoutComponentRef refLayoutElement="Image-QuestionMarkSmall"><reportPath path="/content/folder[@name='BI Administration']/folder[@name='KM Content']/folder[@name='Templates']/report[@name='Images']"><XMLAttributes><XMLAttribute name="ReportName" value="Images" render="false"/></XMLAttributes></reportPath></layoutComponentRef><HTMLItem>
                        <dataSource>
                           <staticValue>&lt;/span&gt;</staticValue>
                        </dataSource>
                     </HTMLItem>
                     <table class="tb"><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>
                                             </staticValue></dataSource></textItem></contents><style><CSS value="width:5%"/></style></tableCell><tableCell><contents><table class="tb"><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;width:100%"/></style></table></contents><style><CSS value="width:40%;border:1.5pt solid black"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>
                                             </staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><table class="tb"><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;width:100%"/></style></table></contents><style><CSS value="width:40%;border:1.5pt solid black"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>
                                             </staticValue></dataSource></textItem></contents><style><CSS value="width:5%"/></style></tableCell></tableCells></tableRow></tableRows><style><CSS value="border-collapse:collapse;width:100%"/></style></table></contents>
               </pageBody>
               <pageFooter class="fp">
                  <contents>
                     <promptButton type="cancel" class="bp">
                        <contents/>
                        <style><CSS value="background-color:silver;border:1.5pt solid black"/></style></promptButton>
                     <promptButton type="next" class="bp">
                        <contents/>
                        <style><CSS value="background-color:silver;border:1.5pt solid black"/></style></promptButton>
                  </contents>
               </pageFooter>
            </page>
         </promptPages></layout>
   </layouts>
   <classStyles><classStyle name="SP_CLS1" label="FSA Report Header"><CSS value="font-family:Arial;font-size:14pt;font-weight:bold;color:#330066;text-align:center;vertical-align:middle"/></classStyle>
      <classStyle name="cls3" label="FSA Column Title"><CSS value="background-color:silver;font-family:Arial;font-weight:bold;color:black"/></classStyle>
      <classStyle name="cls1" label="FSA Sub Header"><CSS value="font-family:Arial;font-size:12pt;font-weight:bold;color:#330066"/></classStyle>
      <classStyle name="cls2" label="FSA Restricted"><CSS value="font-family:Arial;font-size:10pt;font-weight:bold;color:#330066;text-align:left;vertical-align:middle"/></classStyle>
   </classStyles>
   <queries><query name="Query1"><source><model/></source><selection><dataItem name="FRN" aggregate="none"><expression>[Firm].[Firms].[FRN]</expression></dataItem><dataItem name="EORP" aggregate="none"><expression>[Returns].[FOL Return Header].[EORP]</expression></dataItem><dataItem name="MLH058" aggregate="total"><expression>[Returns].[Section H: Mortgage Administration: Arrears Analysis].[MLH058]</expression></dataItem></selection><detailFilters><detailFilter use="required" postAutoAggregation="false"><filterExpression>[FRN] = '121882'</filterExpression></detailFilter></detailFilters></query></queries></report>


CognosPaul

I tried running the report here (replacing the fields of course). I didn't see the K. Judging on that, and the fact that you still see it even after you recreate it, it must not be on the report.

A few questions. Does the K manifest in other measures if you change the scale? Does it still appear if you set the scale back to 0? If you put the measure in the columns or rows, does it still have the K? If you export the report to excel do you see the K in the output? If you click on the cell, is it a full number 1234.5678, or is it a string 1,234.56?

A few things to try:
1. Instead of using the field directly from the model, in the report create a query item that's [MLH058]*1 (the idea being to avoid using anything inherited from the model)
2. Try setting the pattern to #,##0.00
3. Create the data item in the model from scratch.

wyconian

This is very strange.  It happens for other data items (that come from the same source) when I drag them into a crosstab.  If I use the same items in a list there's no problem.  Which would suggest to me it's not anything to do with the model

The items are coming into the model as numbers.  I tried *1 and that gets rid of the issue.

Have just found out that my users actually want to be able to do is add the K not remove it.  We're upgrading from 8.2 to 8.4.  The K appears on the 8.2 report (which is the one I sent you) but not on the 8.4 report.  I know we could manually change the patterns on the reports but there are lots.  Any idea if there is a setting in the config files to set this up for crosstabs?

Thanks for your help and apologies for leading you up the wrong path (apparently you have to love your users!!)

MFGF

Is it possible that someone has hacked the crosstab template used for new crosstab reports in 8.2?

What happens if you create a new blank report and drag in a crosstab from the toolbox, then populate it?  Do you still see the k?

MF.
Meep!