Subject:Adaper question??? Author:Rick Bomar Date:26 Apr 2005 09:49 AM Originally Posted: 26 Apr 2005 09:48 AM
How do I add a Trailer Region which is a count of the total number of records? This row will vary at which line number it could be at each time a new file is created, depending on how many records are in the file. When I created a Trailer Region, it seemed to always end up on the row I created it on when it was created in the adapter. All records after that are messed up. ie- if the region was created on row 100 one time and I created a new file with 150 rows, the Trailer Region would still break on row 100. I need this region to be a floating region and always appear at the end of the file. Is this something I need to do in my Stylesheet?<br>
I tried that already but since it is not defined in the adapter, ie- no fields or region, it did not work. If this needs to be done in my xls, what would be the command? Thanks !<br>
Subject:Adaper question??? Author:Tony Lavinio Date:27 Apr 2005 11:07 AM
If you are using Convert-to-XML, you don't want to use Regions. What you want to do is use the regular-expression matching ability. You need to create a node and pattern that matches only the summary row. For example, if you summary row never contains a comma, you can select on that. If you post a copy of your input XML, we can demonstrate how for you. Or you can mail it to stylus-field-report (at) stylusstudio.com