Dynamic Subfile naming

Chris Sharman Chris.Sharman@ccagroup.co.uk
Fri, 22 Oct 1999 10:18:15 +0100


>Can someone out there divulge the secret whereby I can dynamically create 
>and name the subfiles AT the User-ID break (subfile USER1 contains just 
>User-ID's=<USER1>, subfile USER2 bla bla bla y'all get the idea!)

Easiest is probably to write a quiz report to generate executable code in your
favourite scripting language (most efficient is probably Quiz, in this case).
I've not done it with subfiles myself, just reports. We generate up to 3000
reports for individual customers every night, and I use 'heading at customer
tab 1 "$ create" account-code', so that I can run the whole big 3000-customer
report as a DCL script to break it up.

For subfiles, try generating something like:

exec yourreport nogo
choose userid "userid1"
set subfile mysub-userid1
go
choose userid "userid2"
set subfile mysub-userid2
go
choose userid "userid3"
set subfile mysub-userid3
go

BY

init head tab 1 "exec yourreport nogo"
foot at userid tab 1 'choose userid "' tab 16 userid '"' skip &
	tab 1 "set subfile mysub-" tab 19 userid skip &
	tab 1 "go"
final foot tab 1 "exit"

or similar.

Chris
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.ccastat.demon.co.uk/
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.