Rowset XML PDF input using BIP

Cb1956M

Summary

Rowset XML PDF input using BIP

Content

Hello,

I am using a rowset XML File as source input to a PDF. When I used BI Publisher to generate the output using the PDF and source file. I only get the last record in the file as output for the header records. I have detail records under each header and am using a repeating field grouping which produces the correct detail for each row(header) but the header is only generated for the last row?

If I remove the detail references in the PDF, I only get the last row reported. The layout for the XML input must not be correct for the rowset file. I have other XML files that are generated from query manager and they work fine. Attached is a sample file that was used for input:

Does anyone have any ideas why I am only getting the last record as output?

<?xml version="1.0"?>

-<rs_W_TRAV_VOUCH_RP xsi:noNamespaceSchemaLocation="/XXX/drive/Test/w_travel_vchr_rs.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
rowsetname="W_TRAV_VOUCH_RP" numrows="2">

-<row_W_TRAV_VOUCH_RP rownumber="1">

<hdr_EMPLID>0214501</hdr_EMPLID>

<hdr_W_FISCAL_YEAR>2016</hdr_W_FISCAL_YEAR>

<hdr_W_TRN_TYPE>FT</hdr_W_TRN_TYPE>

<hdr_W_SEQUENCE_NBR>1</hdr_W_SEQUENCE_NBR>

<hdr_W_ORD_SEQNO>1</hdr_W_ORD_SEQNO>

<hdr_W_ORDER_NUM>TB0642</hdr_W_ORDER_NUM>

<hdr_W_BEGIN_DATE>2016-05-16</hdr_W_BEGIN_DATE>

<hdr_W_END_DATE>2016-06-05</hdr_W_END_DATE>

<hdr_W_MILEAGE_COST>24.84</hdr_W_MILEAGE_COST>

<hdr_W_AMOUNT>1412.62</hdr_W_AMOUNT>

<hdr_W_PERSON_NAME>Jones, Gregory B.</hdr_W_PERSON_NAME>

-<rs_W_TRAV_VC_LN_RP rowsetname="W_TRAV_VC_LN_RP"
numrows="2">

-<row_W_TRAV_VC_LN_RP rownumber="1">

<fld_EMPLID>0214501</fld_EMPLID>

<fld_W_FISCAL_YEAR>2016</fld_W_FISCAL_YEAR>

<fld_W_TRN_TYPE>FT</fld_W_TRN_TYPE>

<fld_W_SEQUENCE_NBR>1</fld_W_SEQUENCE_NBR>

<fld_W_ORD_SEQNO>1</fld_W_ORD_SEQNO>

<fld_W_TRAVEL_LEG>1</fld_W_TRAVEL_LEG>

<fld_W_MODE_OF_TRAVEL>PA</fld_W_MODE_OF_TRAVEL>

<fld_W_REASON_FOR_STOP>AT</fld_W_REASON_FOR_STOP>

<fld_W_MILEAGE>23</fld_W_MILEAGE>

<fld_W_ARRIVE_DATE>2016-05-16</fld_W_ARRIVE_DATE>

<fld_W_ARRIVE_TIME>11:30:00</fld_W_ARRIVE_TIME>

<fld_W_TRN_LOCATION>MAX - ATL</fld_W_TRN_LOCATION>

<fld_RANGE_FROM_05>05-16</fld_RANGE_FROM_05>

<fld_RANGE_TO_05>05-16</fld_RANGE_TO_05>

<fld_DISTANCE> </fld_DISTANCE>

</row_W_TRAV_VC_LN_RP>

-<row_W_TRAV_VC_LN_RP rownumber="2">

<fld_EMPLID>0214501</fld_EMPLID>

<fld_W_FISCAL_YEAR>2016</fld_W_FISCAL_YEAR>

<fld_W_TRN_TYPE>FT</fld_W_TRN_TYPE>

<fld_W_SEQUENCE_NBR>1</fld_W_SEQUENCE_NBR>

<fld_W_ORD_SEQNO>1</fld_W_ORD_SEQNO>

<fld_W_TRAVEL_LEG>1</fld_W_TRAVEL_LEG>

<fld_W_MODE_OF_TRAVEL>TP</fld_W_MODE_OF_TRAVEL>

<fld_W_REASON_FOR_STOP>AT</fld_W_REASON_FOR_STOP>

<fld_W_MILEAGE>0</fld_W_MILEAGE>

<fld_W_ARRIVE_DATE>2016-05-16</fld_W_ARRIVE_DATE>

<fld_W_ARRIVE_TIME>11:30:00</fld_W_ARRIVE_TIME>

<fld_W_TRN_LOCATION>MAX - ATL</fld_W_TRN_LOCATION>

<fld_RANGE_FROM_05>05-16</fld_RANGE_FROM_05>

<fld_RANGE_TO_05>05-16</fld_RANGE_TO_05>

<fld_DISTANCE> </fld_DISTANCE>

</row_W_TRAV_VC_LN_RP>

</rs_W_TRAV_VC_LN_RP>

</row_W_TRAV_VOUCH_RP>

-<row_W_TRAV_VOUCH_RP rownumber="2">

<hdr_EMPLID>0201420</hdr_EMPLID>

<hdr_W_FISCAL_YEAR>2016</hdr_W_FISCAL_YEAR>

<hdr_W_TRN_TYPE>FT</hdr_W_TRN_TYPE>

<hdr_W_SEQUENCE_NBR>1</hdr_W_SEQUENCE_NBR>

<hdr_W_ORD_SEQNO>1</hdr_W_ORD_SEQNO>

<hdr_W_ORDER_NUM>TB0138</hdr_W_ORDER_NUM>

<hdr_W_BEGIN_DATE>2016-05-16</hdr_W_BEGIN_DATE>

<hdr_W_END_DATE>2016-06-05</hdr_W_END_DATE>

<hdr_W_MILEAGE_COST>24.84</hdr_W_MILEAGE_COST>

<hdr_W_AMOUNT>464.12</hdr_W_AMOUNT>

<hdr_W_PERSON_NAME>Cole, Susan O.</hdr_W_PERSON_NAME>

-<rs_W_TRAV_VC_LN_RP rowsetname="W_TRAV_VC_LN_RP"
numrows="2">

-<row_W_TRAV_VC_LN_RP rownumber="1">

<fld_EMPLID>0201420</fld_EMPLID>

<fld_W_FISCAL_YEAR>2016</fld_W_FISCAL_YEAR>

<fld_W_TRN_TYPE>FT</fld_W_TRN_TYPE>

<fld_W_SEQUENCE_NBR>1</fld_W_SEQUENCE_NBR>

<fld_W_ORD_SEQNO>1</fld_W_ORD_SEQNO>

<fld_W_TRAVEL_LEG>1</fld_W_TRAVEL_LEG>

<fld_W_MODE_OF_TRAVEL>PA</fld_W_MODE_OF_TRAVEL>

<fld_W_REASON_FOR_STOP>AT</fld_W_REASON_FOR_STOP>

<fld_W_MILEAGE>23</fld_W_MILEAGE>

<fld_W_ARRIVE_DATE>2016-05-16</fld_W_ARRIVE_DATE>

<fld_W_ARRIVE_TIME>11:10:00</fld_W_ARRIVE_TIME>

<fld_W_TRN_LOCATION>MAX - ATL</fld_W_TRN_LOCATION>

<fld_RANGE_FROM_05>05-16</fld_RANGE_FROM_05>

<fld_RANGE_TO_05>05-16</fld_RANGE_TO_05>

<fld_DISTANCE> </fld_DISTANCE>

</row_W_TRAV_VC_LN_RP>

-<row_W_TRAV_VC_LN_RP rownumber="2">

<fld_EMPLID>0201420</fld_EMPLID>

<fld_W_FISCAL_YEAR>2016</fld_W_FISCAL_YEAR>

<fld_W_TRN_TYPE>FT</fld_W_TRN_TYPE>

<fld_W_SEQUENCE_NBR>1</fld_W_SEQUENCE_NBR>

<fld_W_ORD_SEQNO>1</fld_W_ORD_SEQNO>

<fld_W_TRAVEL_LEG>1</fld_W_TRAVEL_LEG>

<fld_W_MODE_OF_TRAVEL>TP</fld_W_MODE_OF_TRAVEL>

<fld_W_REASON_FOR_STOP>AT</fld_W_REASON_FOR_STOP>

<fld_W_MILEAGE>0</fld_W_MILEAGE>

<fld_W_ARRIVE_DATE>2016-05-16</fld_W_ARRIVE_DATE>

<fld_W_ARRIVE_TIME>11:10:00</fld_W_ARRIVE_TIME>

<fld_W_TRN_LOCATION>MAX - ATL</fld_W_TRN_LOCATION>

<fld_RANGE_FROM_05>05-16</fld_RANGE_FROM_05>

<fld_RANGE_TO_05>05-16</fld_RANGE_TO_05>

<fld_DISTANCE> 0</fld_DISTANCE>

</row_W_TRAV_VC_LN_RP>

</rs_W_TRAV_VC_LN_RP>

</row_W_TRAV_VOUCH_RP>

</rs_W_TRAV_VOUCH_RP>