EXCEL Template

2795332

Summary

EXCEL Template

Content

Hi,

Could you suggest on below.

Below is the data structure in my .xml, I m building Excel output report.

<dataStructure>

   <group name="SUMMARY_MODE_GRP" source="Q_RUN_SUMMARY_MODE">

   <element name="L_RUN_SUMMARY_MODE" value="L_RUN_SUMMARY_MODE"/>

        <group name = "CCID" source = "Q_SUMMARY_MODE">

        <element name="ACCT_CCID"      value="ACCOUNTING_CODE_COMBINATION"/>

        <element name="CCID_DESC"      value="CODE_COMBINATION_DESCRIPTION"/>

            <group name = "ENTRD_CURR_GRP" source = "Q_SUMMARY_MODE">

                <element name="ENTRD_CURR"                  value="ENTERED_CURRENCY"/>

                  <group name="JE_LINE" source="Q_SUMMARY_MODE">

                        <element name="ENTRD_DR"                            value="ENTERED_DR"/>

                        <element name="ENTRD_CR"                            value="ENTERED_CR"/>

                        <element name="ACCTD_DR"                            value="ACCOUNTED_DR"/>

                        <element name="ACCTD_CR"                            value="ACCOUNTED_CR"/>

                   </group>

            </group>

        </group>

   </group>

</dataStructure>

In EXCEL Template:-

Columns:-

ACCT_CCID

CCID_DESC

ENTRD_CURR

ENTRD_DR

ENTRD_CR

ACCTD_DR

ACCTD_CR

XDO_?ACCT_CCID? XDO_?CCID_DESC? XDO_?ENTRD_CURR?  XDO_?ENTRD_DR?  XDO_?ENTRD_CR?  XDO_?ACCTD_DR?  XDO_?ACCTD_CR?

    GROUPING all above columns by XDO_GROUP_?CCID?

But it is not giving all the records, as shown below there are 6 distinct ACCT_CCID but there have to be more records for each ACCT_CCID (there should be more CR & DR columns)

ENTRD_CURR

ENTRD_DR

ENTRD_CR

ACCTD_DR

ACCTD_CR

.

ACCT_CCID	CCID_DESC	ENTRD_CURR	ENTRD_DR	ENTRD_CR	ACCTD_DR	ACCTD_CR
110.16001.000.00000.412001.000.0000.000	IBM Inc.Direct Segment Admin.Default.Default.AP Product.Default.Default.Default	USD	3.06	112.5	3.06	112.5
110.16001.000.00000.413001.000.0000.000	IBM Inc.Direct Segment Admin.Default.Default.AP General.Default.Default.Default	USD	367.79	725.05	367.79	725.05
199.16001.000.00000.552001.000.0000.000	IBM Direct Merchant.Direct Segment Admin.Default.Default.AP Product.Default.Default.Default	USD	9.8	321.5	9.8	321.5
199.16001.000.00000.413001.000.0000.000	IBM Direct Merchant.Direct Segment Admin.Default.Default.AP General.Default.Default.Default	USD		73.29		73.29
144.16001.000.00000.552001.000.0000.000	IBM Publishing, LLC.Direct Segment Admin.Default.Default.AP Product.Default.Default.Default	USD	3320.49	341.51	3320.49	341.51
144.16001.000.00000.213001.000.0000.000	IBM Publishing, LLC.Direct Segment Admin.Default.Default.AP General.Default.Default.Default	USD	11995.97	3844.44	11995.97	3844.44

Any suggestions please.

Thanks.

Brajesh Shukla-95078

You are not using group by properly in excel. Please go though some sample Excel report this may solve the problem