When using Access to Generate Reports Double lines 
Author Message
 When using Access to Generate Reports Double lines

I use Access to generate some reports.  They look great in Access however when converting them to Word (.RTF) some of the lines will generate twice.  This is very hit and miss in the repeated lines..  Has anyone any idea why it is doing this.  (Office 97 on NT system, running NetWare)

--
Nick Kruse



Tue, 15 Oct 2002 03:00:00 GMT
 When using Access to Generate Reports Double lines

Sorry, there is no way around this problem, it is just errors in the
"OutputTo" code for reports. Most of the problems of that sort were fixed in
the Access 2000 code, but they were never backported to 97. The A2000 verion
is far from perfect, through, there are lots of problems in that code,
still.

Your solution is to make your reports less complex, or download the unlocked
version of utility.mda for Access 97 and try to fix the bug yourself (I have
had to do just that for customers, but you cannot redistribute the modified
version, unfortunately.

--
MichKa
"Cause it's a bittersweet symphony, thats life..."  -- The Verve

random junk of dubious value, at the multilingual,
no scripts required, http://www.trigeminal.com/


I use Access to generate some reports.  They look great in Access however
when converting them to Word (.RTF) some of the lines will generate twice.
This is very hit and miss in the repeated lines..  Has anyone any idea why
it is doing this.  (Office 97 on NT system, running NetWare)

--
Nick Kruse



Wed, 16 Oct 2002 03:00:00 GMT
 When using Access to Generate Reports Double lines
Instead of creating the reports in Access 97 then converting to RTF, why
don't you create the relevant recordset(s) then creating/writing the reports
in MS Word.  This will require a fair bit of coding & knowledge of Word
objects (especially Word Table object) and Word VBA.  The reports, however,
will be exactly what you want.

For example, I was recently asked to set up a database to keep track of
printer usage (we have about 50 printers at work).  Readings of total pages
(from the beginning) printed on each printer are entered fortnightly.  The
required report lists each printer, readings for each printer sorted by
date, the number of pages printed for each printer in the period (i.e. the
difference between one reading and the previous reading) and the printer's
average usage to date.  I could not work out the difference as Access 97
Reports and Crystal Reports concentrate on the "current" record only, i.e.
only the current reading while I need current reading minus previous
reading.  Also, the report requires more or less 2 recordsets: "list" of
printers and the a "sub-list" of readings for each printer.  I decided to
use Word, coded the report in Access 97 VBA calling Word objects and Word
VBA (the database was Access 97 but if your application in VB, you can do
exactly the same) and the report came out exactly as I want.

I also use MS Word in my apps to print personalised standard letter(s)
including details extracted from the database and they come out quite nice.

Contact me (or better, post it to newsgroup if you want further info. or
sample codes).

Cheers


I use Access to generate some reports.  They look great in Access however
when converting them to Word (.RTF) some of the lines will generate twice.
This is very hit and miss in the repeated lines..  Has anyone any idea why
it is doing this.  (Office 97 on NT system, running NetWare)

--
Nick Kruse



Fri, 18 Oct 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ??? Generating reports in Access 97 using VB5 ???

2. Generate MS-ACCESS table using SQL Script generated by SQL Server

3. Generate an oracle report from command line (oracle 9ias)

4. Printing Access reports or using Access to print/preview reports

5. Generating Reports on screen using 4gl

6. Generating PDF (Adobe) reports using SQL Database

7. Problem with TEXT data types when generating report using Informix 4GL

8. Generate reports using java and SQL

9. Problem with TEXT data types when generating report using Informix

10. Report which only uses last line table

11. Report Using Report from Access

12. 4gl report line height/lines per inch


 
Powered by phpBB® Forum Software