Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XSL-FO Accounting Check Run

Status
Not open for further replies.

Are8Jay

Programmer
Sep 22, 2002
17
0
0
US
I'm a web developer using ASP.NET/VB with XML and XSL to generate Accounting reports. Am currently writing a check run process and need to use XSL-FO to style the OUTPUT XML into printable checks. I have a 3rd party .dll to produce the PDF. I've designed a number of Reports, so my experance has been limited, based on those reports only.

The issue at hand is as follows;

XML:

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Details Detail_ID="1" TP_ID="8" TP_Name="CFI" Address_ID="29" TP_Address="101" TP_City=" Main Street" TP_State=" MO" TP_Zip=" 65803" TP_Country=" USA" Amount="$2,004.00" VerbalAmount="two thousand, four dollars and zero cents" CheckNumber="12" />
<Details Detail_ID="2" TP_ID="6" TP_Name="FedEx Freight East" Address_ID="11" TP_Address="805 W American Blvd" TP_City=" Harrison" TP_State=" AR" TP_Zip=" 63210" TP_Country=" USA" Amount="$5,574.82" VerbalAmount="five thousand, five hundred seventy four dollars and eighty two cents" CheckNumber="15" />
<Details Detail_ID="3" TP_ID="10" TP_Name="JB Hunt" Address_ID="22" TP_Address="38736 Hunt Avenue" TP_City=" Rogers" TP_State=" AR" TP_Zip=" 64873" TP_Country=" USA" Amount="$1,937.20" VerbalAmount="one thousand, nine hundred thirty seven dollars and twenty cents" CheckNumber="14" />
<Details Detail_ID="4" TP_ID="7" TP_Name="Overnite Transportation Company" Address_ID="30" TP_Address="101" TP_City=" Main" TP_State=" Mo" TP_Zip=" 65806" TP_Country=" USA" Amount="$1,320.04" VerbalAmount="one thousand, three hundred twenty dollars and four cents" CheckNumber="19" />
</NewDataSet>


XSL:

<?xml version='1.0' encoding='utf-8'?>
<xsl:stylesheet version="1.0"
xmlns:fo=" xmlns:xsl=" xmlns:ibex="
<xsl:strip-space elements='*'/>

<xsl:template match="NewDataSet">
<fo:root>

<fo:layout-master-set>
<fo:simple-page-master master-name="page"
page-height="11in"
page-width="8.5in"
margin-left=".25in"
margin-right=".25in"
margin-bottom="1in"
margin-top="1in">
<fo:region-body region-name="body"/>
</fo:simple-page-master>
</fo:layout-master-set>

<fo:page-sequence master-reference="page">
<fo:flow flow-name="body">
<!-- this is the stub portion of the check stock -->
<fo:block-container absolute-position="absolute" left="0pt" top="0pt" background-color="silver">
<fo:block font="8.5pt arial">
Stub
</fo:block>
</fo:block-container>
<!-- this is the physical check portion of the check stock -->
<fo:block-container absolute-position="absolute" left="1.5cm" top="6.5in" width="7.5in" background-color="gray" >
<fo:block font="8.5pt arial">
<!-- To the Order of -->
<fo:block-container absolute-position="absolute" left="5pt" top="5cm" width="9cm" font="10pt arial" >
<fo:block >
<xsl:value-of select="Details/@TP_Name"/>
</fo:block>
<fo:block >
<xsl:value-of select="Details/@TP_Address"/>
</fo:block>
<fo:block >
<xsl:value-of select="Details/@TP_City"/>&#44;&#x00a0;
<xsl:value-of select="Details/@TP_State"/>&#x00a0;
<xsl:value-of select="Details/@TP_Zip"/>&#x00a0;
<xsl:value-of select="Details/@TP_Country"/>
</fo:block>
</fo:block-container>

<!-- Verbal Amount to pay -->
<fo:block-container absolute-position="absolute" left="0pt" top="3cm" width="11cm" font="10pt arial" >
<fo:block >
<xsl:value-of select="Details/@VerbalAmount"/>
</fo:block>
</fo:block-container>

<!-- Numeric Amount to pay -->
<fo:block-container absolute-position="absolute" left="15.25cm" top="4cm" width="3cm" font="10pt arial" >
<fo:block >
<xsl:value-of select="Details/@Amount"/>
</fo:block>
</fo:block-container>

<!-- Date of Check -->
<fo:block-container absolute-position="absolute" left="11cm" top="4cm" width="3cm" font="10pt arial" >
<fo:block >
<xsl:value-of select="Details/@Amount"/>
</fo:block>
</fo:block-container>
</fo:block>
</fo:block-container>
</fo:flow>
</fo:page-sequence>
</fo:root>

</xsl:template>

</xsl:stylesheet>

I need each check to print on its own page (check stock paper). Current results is a single page only that is willing the first Details node. The stub portion of the check will be nested XML base on the Parent check.

Any help debugging this issue will be helpful.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top