Returning Multiple Records

Hi, first post here...

 

Found the topic in RulesSystemGuide on "How to return multiple records in

the same output file"

 

Needed to group the list by RetailerID separates them into new pages.

 

Works like a charm so far.

 

However, there is a twist, other than concatenating the results into a variable for writing out the pages during composition, I'd also like to add the RetailerID field to each grouped page on the footer.

 

e.g.

RecID  RetailerID  Names
1        R1            A
2        R1            B
3        R1            C
4        R1            D
5        R2            E
6        R2            F
7        R2            G
8        R3            H
9        R3            I

 

Should produce :

-------------------------

Page 1

A

B

C

D

 

Footer : RetailerID R1

-------------------------

Page 2

E

F

G

 

Footer : RetailerID R2

-------------------------

Page 3

H

I

 

Footer : RetailerID R3

-------------------------

 

I can't figure out how I can extract that RetailerID to land on the footer on it's own.

 

Ideas?

 

Hardwired

If you mean on the actual page for the footer just make a variable text box and add the ID field.

If you mean on the actual page for the footer just make a variable text box and add the ID field.

 

I wish it was that simple, since the data is not being pull in as a data source, but rather through ExternalDataFile, there is no RetailerID Field available for the text box.

Refer to this link on External data bases

 

http://forums.printable.com/showthread.php?t=392&highlight=external