cc@xroads.UUCP (12/02/87)
Hello. I have a database in AppleWorks which consists of about 1800 records. They are arranged by number, from 1-45000. Obviously, not every number is used. I am trying to get AppleWorks to start every new page with a new thousand numbers. For example, I want to have page 1 (or page 1 and 2, however many it takes) be 1-999, and page 2 be 1000-1999, etc..so each page starts with a new thousand. The way I am currently doing this is by writing the database to a disk as a text file, and then inserting the page breaks by hand in the word processor. As you can tell, this gets quite tedious when I have to insert 50+ page breaks. Does anyone have any suggestions about how I could get AppleWorks to print this way, or another program I could transfer the file over that would do it? Dan McGuirk @ Crossroads Communications ihnp4!mot!nud!xroads!cc -- \ / C r o s s r o a d s C o m m u n i c a t i o n s \/ (602) 971-2240 /\ (602) 992-5007 300|1200 Baud 24 hrs/day / \ ihnp4!mot!nud!xroads!*
mackay@dalcsug.UUCP (12/04/87)
In article <346@xroads.UUCP>, cc@xroads.UUCP (Dan McGuirk) writes: > > Hello. I have a database in AppleWorks which consists of about 1800 > records. They are arranged by number, from 1-45000. Obviously, not every > number is used. I am trying to get AppleWorks to start every new page > with a new thousand numbers. For example, I want to have page 1 I'll call the number 1-45000 the "catalog number" in my description. This may not be the best way, but it worked for me. What you CAN'T do is define a category in the report, = catalog#/1000, make it an integer, and break on that- Appleworks won't break on a calculated field. This is what I did. 1. Move the DB into the spreadsheet by writing out a dif file and making a new SS file from the DIF file. You'll have to have an extended (like Applied Engineering) version of the SS for this as I don't think the vanilla SS can eat 1800 records from a DIF file. 2. Define a new column in the SS as @INT(Cat_Number_Column/1000). This'll give you 0 for cat #s 0-999, 1 for 1000-1999, 2 for 2000-2999 and so forth. 3. Print the scratch spreadsheet out to a scratch disk, as a DIF file, in COLUMN order (important!!). 4. Make a new scratch DB file, from the scratch SS DIF file. It will have an extra column, the thousands portion of the catalog number. 5. Define a new report, and using delete and insert, move the new column out to the right hand side of the report. This is so we won't have to print it on paper. 6. Move to on top of the new column, and hit open-apple-G, group totals. Answer no, you don't want group totals only, and yes, you do want a new page for each group (our whole purpose here). 7. Fix up the rest of the report so it looks like what you want. Make sure that the new column is off the edge of the paper (PW), so you won't get it on paper (but you can't delete it or it won't group total on it). 8. Print the report. This sounds incredibly convoluted, but I do it all the time, and the example above took me about 10 minutes with a RAM disk for the scratch files (which is useful since it gets erased on every power failure in this berg!) Dan: good luck! Hope this helps. Anyone: if you know an easier way, let us know!! -- +---------+ Dalhousie University | _ | From the Halifax, Nova Scotia | (_)===| Disk of ... Canada | | Daniel mackay@dalcs.UUCP +---------+ ...{utai,uunet}!dalcs!dalcsug!mackay
GZT.EWW@OZ.AI.MIT.EDU (Wes Williams) (12/05/87)
Dan McGuirk Writes
>How can I get Appleworks to do.......
I suggest Beagle Bros. Ultra Macros. This utility will build a programmed
macro of your design to do all the drudgery of multiple key input steps.
I have used some powerfull other WPs and am highly impressed with personal
macros within Appleworks (and an accel card).
-------
cc@xroads.UUCP (Dan McGuirk) (12/09/87)
In article <218@dalcsug.UUCP>, <mackay@dalcsug.UUCP> (Daniel MacKay) writes: > [change the file to a DIF file, then load it into the spreadsheet] I have an Applied Engineering GS-Ram with 1 megabyte of memory, and I've used the "Appleworks Upgrade" disk that came with it to upgrade the space limits of AppleWorks, and it still won't let me load in the file. It says it is too large for Apple // standards, or something. I had over 700k available when I tried to load it, and it's only about 200k long.. Anyone else: Help? Dan McGuirk ihnp4!mod!nud!xroads!cc -- \ / C r o s s r o a d s C o m m u n i c a t i o n s \/ (602) 971-2240 /\ (602) 992-5007 300|1200 Baud 24 hrs/day / \ ihnp4!mot!nud!xroads!*