Sub-Summary list print on a label?????

[ZzingG]

I hope I can explain this so that it makes sense..........

I am trying to get a Avery label 5663 to print with a list of records printed on it. I have Client_Name, Client_Number and Volume that need to be on the top of each label. The rest of the label then needs to be the list of files that are in that volume. I can create this report with a sub-summary section sorted by Volume and then add the Client_Name and Client_Number to this part and it list the records with the body just fine. The problem I have is getting this to print accros a sheet of labels so that it can be afixed to file folders.

I have tired to colum print and it cuts the fields up or is just not formated cleanly. Any ideas? I think I need to combine a sorted-list view along with a label format I am just not sure how to do this.

Thanks for the help.

[BobWeaver]

The problem with Filemaker and labels is that Filemaker likes to print one record per label. To do anything else can get messy. If there is some way that you can get the data for each label all into one record, then you may solve the problem.

One possibility is to create a related file containing one record per client and related by client number. Then create a related valuelist of the file names. You can use the valuelistitems function to get a list of all the files into one record and then print from the related file.

[ZzingG]

Not really what I wanted to hear, but you also gave me something to think about as well. Thanks for the help Bob.

ZzingG

[BobWeaver]

After thinking about this a bit, I see that I gave a more complicated solution than necessary.

Use the layout wizard to create a layout for the label that you want to use. Then in layout mode, change the body part to a sub-summary part sorted by Client Number

- Set up a self join relationship on the client number field.

- Create a related valuelist "FileNames" based on this relationship using values from the files field

- Create an unstored calculated field "FileList" with the formula:

ValueListItems(Status(CurrentFileName),"FileNames")

Put the Client name, Client Number and Volume on the label layout at the top of the subsummary part, and the FileList field immediately below it.

Now sort by Client Number and print.

I'm assuming here that you want to create one label for each client number. If each client can have several volumes and you want a label for each volume, then substitute the Volume field for the Client Number field in the above discussion.