PARADOX COMMON QUESTIONS AND ANSWERS

REPORTS

   1.  Why are my Page headers floating around on the page?

       Floating headers are caused by page length inconsistencies
       or end of page problems.  Make sure  your  default printer
       page length is the same as the set page length in Paradox.
       ie.  HP LaserJet Portrait mode should be set to  60 lines.
       Also, set the  end  of page action:  <M>ainmenu, <R>eport,
       <S>etprinter, <O>verride, <E>ndOfPage, <F>ormfeed.


   2.  How can I  get  my  report  so  that not all of the fields
       print?

       To remove Fields from a report, do the  following.   While
       in report change mode, choose <M>enu, <F>ield, <E>rase and
       move your cursor to  the  field  to  be removed, and press
       <Enter>.  Save the report with <F2> and print.


   3.  How do I delete a blank line?

       While in the report design or change mode, move the cursor
       to  the  beginning  of  the  line to be deleted and  press
       <Ctrl><Y>


   4.  I sorted my table, but when I print my  report,  the  sort
       order changes.  What is going on?

       You have a group in your report.  Remove the group band or
       add a group band based on  the  same field as you did your
       sort.  Groups are reports' way of sorting.


   5.  Can I use PAL functions in my report?

       PAL functions are not allowed in the report generator.  If
       you need to do calculations  that  use  PAL  functions, do
       them ahead of time and place the values in fields.   Then,
       print your report.


   6.  How do I do three labels across?

       Be sure to select labels from the menu, then set  the page
       width to the width of each label.  Insert or  delete pages
       so  that  the  number of pages equals the number of labels
       across.














   7.  How can I do labels on an HP LaserJet?

       Press <Ctrl><V> to toggle on line numbers to  the  left of
       the screen.  Delete blank lines in the report header, page
       header, page footer, and report  footer.    The  number of
       lines between the form  bands  should  match the number of
       lines that can be printed on a label.  Set the page length
       to  60  lines.   Select the setup string for "HP LaserJet"
       through <S>etting, <S>etup, <P>redefined.


   8.  How do I put variables on my report?

       Two methods are possible.  Create a new table with an "A1"
       key field and any number  of additional fields.  Link this
       table to the table you are designing the report to through
       <F>ield, <P>lace, <L>ookup.  Place the  other  fields from
       the linked table.  Now, you can add values  into  the  one
       record table before you print the report.

       The other option is to have your script go into the report
       design   by   using   <R>eport,   <C>hange,   <Tablename>,
       <ReportNumber>, <Enter>.  Then, move to  the  position for
       the variable and place  the  variable  by using the TYPEIN
       command.  (ie.  TYPEIN variablename.)


   9.  Is there any way to print a different font?

       To  use different fonts in a report,  you  must  know  the
       control code (setup string) your  printer  used  to invoke
       the font  (usually in the printer manual appendix).  Then,
       for  a  whole  report,  from   the   Report   menu  choose
       <S>ettings, <S>etup, <C>ustom, <LPT1> (or appropriate) and
       type in the appropriate string.  ie.   \015  for condensed
       on an IBM printer.


  10.  Why won't my fields wordwrap?

       If you already selected Wordwrap from the menu, be sure to
       reformat  the  field  width of the field you are trying to
       wrap.  You  must  shrink  the  field so it fits within one
       page.   Select from the menu, <F>ield, <R>eformat and move
       to the appropriate field and  press <Enter>.  Use the left
       arrow to resize the field.


  11.  In a 1 to Many report,  when  I  try to link in the detail
       table, the menu lists the wrong keys to link by.  Why?

       You must design the  report  from  the  "Many" side of the
       relationship.  Start the  report  design  from  the detail
       table and link in the master table.



                              - 2 -








  12.  All of my records from my master are not printing?

       Only records that have matching links in all lookup tables
       will be included in the report.


  13.  How  can  I  link two detail tables to a master table in a
       report?

       As long as the two detail tables have a  common  field,  a
       query can be used  to  merge the tables together.  Add the
       appropriate keys to the answer table and design the report
       linking in the master.


  14.  How can I do percent in my report?

       You must first  do  a  query  using a calc sum placing the
       total  in each field.  You can  then  place  a  calculated
       field in your report that uses this summary field.


  15.  Why  is  my  report printing a blank page at the end of my
       report?

       Look  in the upper right corner and  make  sure  it  reads
       "1/1".  If it reads 1/n (where n is any number  other that
       1),  you   have  extra  pages  in  your  report.    Select
       <S>ettings,  <P>ageLayout,  <D>elete,  <OK> until it reads
       1/1.


  16.  How do I get an overall total in my report?

       Place the overall  summary  field  in  the  report footer.
       Placing the  field in any other band will cause inaccurate
       results.


  17.  On my LaserJet, why am I  getting  a left arrow at the end
       of the report?

       Paradox uses a Control-Z character  to mark the end of the
       report.  The font you are using accepts this  as  a  valid
       character.  Either use the default font or use a font that
       does not use this character as a printable character.


  18.  Some  of my values seem inaccurate when  I  print.    What
       could be causing this?

       Use the Custom  Configuration  program  to  set  blanks to
       Zero.   From the menu in the Custom Configuration program,
       select <D>efaults, <B>lanks=0, <Yes>.



                              - 3 -








  19.  How do I do a field squeeze outside of my form band?

       Use <F>ield, <P>lace, <C>alculated and enter [Field1]  + "
       " + [Field2].





















































                              - 4 -