Part.Character01 won't show in StkStatus

Thanks.  

At least I now know that it wasn't me.

Calvin
I can't get Character01 to appear in the data for a custom version of the Stock Status Report.

Here's what I've done:
1. Duplicated the StkStatus Report Data Definition (RDD) to StkStat2
2. Edited RDD StkStat2 to include the Chartacter01 field in the Part table
3. Copied the Stock Status Report .rpt file to SSR2.rpt
4. Created a new StkStat report style ("SSR-By Char01"), setting data source to StkStat2, and report to SSR2.rpt
5. Launched Stock Status Report, selected style "SSR-By Char01", and selected print priview
6. Launched CR, opened SSR2.rpt, updated datasorce to the XML file created from step 5, verified DB
* The field Character01 now appears under table Part in field explorer
7. Added Part.Character01 to the report, and saved.

Ran the report again, and Character01 is blank in every instance (and I know there is data in Part.Character01).

I examined the XML file and found that the Character01 element is missing from the <Part> sections in the XML file.  Here is a sample:
<Part>
<RptLanguageID>ENU</RptLanguageID>
<ClassID>CABL</ClassID>
<Company>MC</Company>
<CostMethod>L</CostMethod>
<IUM>FT</IUM>
<Method>false</Method>
<MtlBurRate>0</MtlBurRate>
<NonStock>false</NonStock>
<PartDescription>1/4 Galvanized Cable  - MCM</PartDescription>
<PartNum>3450T43</PartNum>
<TypeCode>P</TypeCode>
</Part>


I went back and edited my RDD StkStat2, to include every field from Part - (this was a suggestion in a thread several years old).  After running the report again and viewing the new XML file, I see that the only user fields that appear in the <Part> sections are the CheckboxNN fields.  None of the CharacterNN, DateNN, etc appear.


Is there something special about the StkStatus RDD?  Is the "Part" table in the RDD the actual Part table or some derived version or view of it?


Please help as I've wasted so many hours trying to figure this out on my own.


Calvin

More info ....

First off - We're on Version 8.03.403

No matter which table in the StkStatus RDD I chose, including Character01 of that table, it never shows in the XML data.

The XML data does contain entries in the <RptLabelss> for Character01 and in the table structure element

<xs:element name="Part"><xs:complexType>
<xs:sequence>
<xs:element name="RptLanguageID" type="xs:string" msdata:Caption="Language ID" minOccurs="0" />
<xs:element name="Character01" type="xs:string" msdata:Caption="Character01" minOccurs="0" />
<xs:element name="CheckBox01" type="xs:boolean" msdata:Caption="CheckBox01" minOccurs="0" />
<xs:element name="ClassID" type="xs:string" msdata:Caption="Class" minOccurs="0" />
<xs:element name="Company" type="xs:string" msdata:Caption="Company" minOccurs="0" />
<xs:element name="CostMethod" type="xs:string" msdata:Caption="Costing Method" minOccurs="0" />
<xs:element name="IUM" type="xs:string" msdata:Caption="Invty U/M" minOccurs="0" />
<xs:element name="Method" type="xs:boolean" msdata:Caption="BOM" minOccurs="0" />
<xs:element name="MtlBurRate" type="xs:decimal" msdata:Caption="" minOccurs="0" />
<xs:element name="NonStock" type="xs:boolean" msdata:Caption="Non-Stock Item" minOccurs="0" />
<xs:element name="PartDescription" type="xs:string" msdata:Caption="Description" minOccurs="0" />
<xs:element name="PartNum" type="xs:string" msdata:Caption="Part Number" minOccurs="0" />
<xs:element name="TypeCode" type="xs:string" msdata:Caption="Typ" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>

But never in the <Part> sections

<Part>
<RptLanguageID>ENU</RptLanguageID>
<CheckBox01>false</CheckBox01>
<ClassID>CABL</ClassID>
<Company>MC</Company>
<CostMethod>L</CostMethod>
<IUM>FT</IUM>
<Method>false</Method>
<MtlBurRate>0</MtlBurRate>
<NonStock>false</NonStock>
<PartDescription>1/4 Galvanized Cable  - MCM</PartDescription>
<PartNum>3450T43</PartNum>
<TypeCode>P</TypeCode>
</Part>

CheckBox01 appears, but Character01 does not.

You  may be out of luck. Vantage had a bug where user defined fields added to the Stock Status RDD aren't displayed in the xml. It's SCR 79700 ("targeted to be fixed in 8.03.411"...ha ha ha!) I have no idea if they have a one-off available for that or not; we're on 9.05.701.

Sue

---In vantage@yahoogroups.com, <ckrusen1@...> wrote :

More info ....

First off - We're on Version 8.03.403

No matter which table in the StkStatus RDD I chose, including Character01 of that table, it never shows in the XML data.

The XML data does contain entries in the <RptLabelss> for Character01 and in the table structure element

<xs:element name="Part"><xs:complexType>
<xs:sequence>
<xs:element name="RptLanguageID" type="xs:string" msdata:Caption="Language ID" minOccurs="0" />
<xs:element name="Character01" type="xs:string" msdata:Caption="Character01" minOccurs="0" />
<xs:element name="CheckBox01" type="xs:boolean" msdata:Caption="CheckBox01" minOccurs="0" />
<xs:element name="ClassID" type="xs:string" msdata:Caption="Class" minOccurs="0" />
<xs:element name="Company" type="xs:string" msdata:Caption="Company" minOccurs="0" />
<xs:element name="CostMethod" type="xs:string" msdata:Caption="Costing Method" minOccurs="0" />
<xs:element name="IUM" type="xs:string" msdata:Caption="Invty U/M" minOccurs="0" />
<xs:element name="Method" type="xs:boolean" msdata:Caption="BOM" minOccurs="0" />
<xs:element name="MtlBurRate" type="xs:decimal" msdata:Caption="" minOccurs="0" />
<xs:element name="NonStock" type="xs:boolean" msdata:Caption="Non-Stock Item" minOccurs="0" />
<xs:element name="PartDescription" type="xs:string" msdata:Caption="Description" minOccurs="0" />
<xs:element name="PartNum" type="xs:string" msdata:Caption="Part Number" minOccurs="0" />
<xs:element name="TypeCode" type="xs:string" msdata:Caption="Typ" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>

But never in the <Part> sections

<Part>
<RptLanguageID>ENU</RptLanguageID>
<CheckBox01>false</CheckBox01>
<ClassID>CABL</ClassID>
<Company>MC</Company>
<CostMethod>L</CostMethod>
<IUM>FT</IUM>
<Method>false</Method>
<MtlBurRate>0</MtlBurRate>
<NonStock>false</NonStock>
<PartDescription>1/4 Galvanized Cable  - MCM</PartDescription>
<PartNum>3450T43</PartNum>
<TypeCode>P</TypeCode>
</Part>

CheckBox01 appears, but Character01 does not.