Nearo

Here's another approach. 1.)Add a number field to the database. Call it "Selected". 2.)Add a global number field. Call it gRandom Add a summary field. Call it Total Selected. Sum(Selected) 3.)Write the following script: Loop Set field ["gRandom", "Round(Random * 1000 +1, 0)"] Go to Record/Request/Page "gRandom" Set Field ["Selected", 1] End Loop If(Total Selected = 100) End Loop Run this script. It will find 100 random records, mark each one with a "1". The summary field will keep count and cause the script to exit after 100 entries (no duplicates this way). Next, just export these records to a text file or import from your other database.

Here's one way to do this. Create the following calculations: CountA - Calculation - Number: If(Priority = "a", 1, 0) CountB - Calculation - Number: If(Priority = "b", 1, 0) CountC - Calculation - Number: If(Priority = "c", 1, 0) CountD - Calculation - Number: If(Priority = "d", 1, 0) Now, create summary fields to count these. TotalA - Summary - Total of: Count A TotalB - Summary - Total of: Count B TotalC - Summary - Total of: Count C TotalD - Summary - Total of: Count D

Check the margins in your page setup. If the margins are too large, it will drop off a row of records and try to print them on the next page. If you don't want to change the margins, you can adjust the size of the header and footer until all the labels print on the page.