home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases
- Path: sparky!uunet!cis.ohio-state.edu!magnus.acs.ohio-state.edu!zaphod.mps.ohio-state.edu!usc!elroy.jpl.nasa.gov!sdd.hp.com!ux1.cso.uiuc.edu!news.cso.uiuc.edu!osiris.cso.uiuc.edu!weller
- From: weller@osiris.cso.uiuc.edu (Bonnie Weller)
- Subject: FoxPro2 problems
- Message-ID: <BuBMuK.B9K@news.cso.uiuc.edu>
- Sender: usenet@news.cso.uiuc.edu (Net Noise owner)
- Organization: University of Illinois at Urbana
- Date: Wed, 9 Sep 1992 17:20:42 GMT
- Lines: 54
-
-
- Hi,
-
- I am trying to help a friend who just got Foxpro2 to print out her data.
- (Her employer just got the program and she has had NO computer
- experience. I have had some dBASE IV experience)
-
- Anyway, here is the scenario. I hope it is not too convoluted.
-
- She has a very large dbf file, called say, A.dbf. Using this file I
- created a report called A.frx. I wanted it to print using a
- specific format. The format allows for 2 records to be printed per
- line. Since file A.dbf is over 5000 records long, I want to print
- out only those records which meet certain criteria. So, using A.dbf,
- I created a query file called A.qpr. It does the query fine, and when
- I look at it using the browse option in the query window, it shows the
- correct records. However (you knew there was a however), when I save
- the file to use the report A.frx, and then look at the results in
- preview, it shows the same record 10 times instead of showing me the 10
- different records as it did in browse. The format is correct though.
- When I go to print it out, it also prints the same record 10 times.
- (Also, the printing is all messed up, instead of getting lines and
- boxes I get weird symbols like @'s and a's. I suspect this is do to
- designating the wrong printer. I have suggested she ask the fellow who
- installed the program to check on this)
-
- So, question number 1 is, how do I get the results from the query to
- print out all the records selected using a pre-designed report form?
-
- Question 2, when I create a dbf file using the results of the
- query, say Q.dbf, why can't I print out this file using the report
- format? Whenever I evoke the run report option, it always goes back
- to using the A.dbf file even though I originally opened the Q.dbf
- file. I had hoped to be able to use the A.frx format using several
- different files (which have the same database structure of course,
- just different data entered in it) The only way I have found I can
- do this is to rename the A.dbf to something else, and then rename the
- Q.dbf to A.dbf. This seems inefficient to me. There must be a better
- way to do this.
-
- Question 3, is there a Foxpro2 book that addresses these types of
- questions? I looked in the documentation that came with the software,
- plus Chou's "Understanding FoxPro 2", but neither book seemed to
- address this. It seems to me this is a simple task, and one that
- most people would want to perform at some point, so surely Foxpro can
- do this. I just can't seem to figure out how. As usual, I know just
- enough to get me started but never enough to finish the job.
-
- Any help would be appreciated.
-
- Thanks
-
- Bonnie
- weller@osiris.cso.uiuc.edu
-