PDA

View Full Version : Returning Multiple Records


hardwired
March 30th, 2010, 07:01 AM
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

tsghost
March 30th, 2010, 07:13 AM
If you mean on the actual page for the footer just make a variable text box and add the ID field.

hardwired
March 30th, 2010, 08:18 AM
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.

tsghost
March 30th, 2010, 08:29 AM
Refer to this link on External data bases

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