hardwired Posted March 30, 2010 Share Posted March 30, 2010 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 Link to comment Share on other sites More sharing options...
tsghost Posted March 30, 2010 Share Posted March 30, 2010 If you mean on the actual page for the footer just make a variable text box and add the ID field. Link to comment Share on other sites More sharing options...
hardwired Posted March 30, 2010 Author Share Posted March 30, 2010 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. Link to comment Share on other sites More sharing options...
tsghost Posted March 30, 2010 Share Posted March 30, 2010 Refer to this link on External data bases http://forums.printable.com/showthread.php?t=392&highlight=external Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.