I'm generating a report of our items for a catalog-type print out. Each page has an alphabetical listing of items and all the information comes from the Item card. What I want to do is display a footer for each page that shows the first item on the page and the last item on the page (kind of like in a dictionary). So that when flipping through it, a person can easily see where they are in the catalog. I can get the first item, no problem. But the last item eludes me. Whether I try displaying it directly on a transfooter or a footer, it ALWAYS shows the value for the first listing on the NEXT page. Even if I try using a variable and setting the value to display in the body of the report, I always get the first value from the NEXT page.
Has anyone else run into an issue like this? I did search for similar problems but most of the results I found had to do with summing totals on a page; not what I need to accomplish.
Thanks in advance!
Scott
0
Comments
RIS Plus, LLC
I was thinking doing a count on a second item dataitem that just shows the output every x amount of lines. Just brainstorming, nothing solid.
I would be surprised if the Transfooter is what you need to use. It's purpose I thought was to show the first line of the next page :shock:
http://www.BiloBeauty.com
http://www.autismspeaks.org
1. Create a table (type record) variable for the same data item used in the report, just with a different name.
2. In the OnPreSection() trigger of the footer, setup this table with an identical query as in the report, point to the current record for the report, then point to the previous record and assign author to a variable to display in the footer. Something like this.
If there are other conditions elsewhere in the report which hide records thus adding filters, you may need to repeat conditions or actually run a parallel data item to keep track of the previous record.
Hope this makes sense.
Bob
NY
The report is not guaranteed to have the same number of lines per page, so a simple counter will not work, unfortunately.
Maybe I am mistaken but I was under the impression that a Transfooter was a "transitional" footer and the purpose was to show bottom of the current page info, like current page number, subtotals and the like. Out of curiousity, why would you need a special section to see the data you are about to see in the next body?
I understand the concept and why it should work, but that seems like a lot of overhead to get a single piece of uncalculated data that I just had my hands on. We have almost 1.5 million distinct items and of those between 40,000 and 50,000 will be in the catalog. That seems like a lot of records to put into a temp table, especially given the data I want to access.
What about keeping track of the last and the second to last. Add two variables 'LastName' and 'SecondToLastName'. Set SecondToLast to Last, and set Last to the name in the current record. I don't know how else to capture it.
RIS Plus, LLC
RIS Plus, LLC
Is it me or does that seem odd? That when the footer of page 1 is being processed, the header & body of page 2 has already been processed.