PC Review


Reply
Thread Tools Rate Thread

Advanced table generation

 
 
jim@jimchristine.com
Guest
Posts: n/a
 
      29th Dec 2003
Word Gurus,

A customer of mine requires that database reports are provided in Word
format. My database extract program successfully creates a HTML file
that is imported into Word. Tables look just fine; header lines are
repeated as expected. Here's the problem:

My extract program removes repeated cell values to enhance
readability. For example ...

ColumnA ColumnB ColumnC
-----------------------
A1 B1 C1
A2 B2 C2
B3 C3
C4
A3 B5 C5
B6 C6

As I approach the bottom of a page, a group may be split across two
pages. This acceptable, however, the repeating cell values from the
previous page are not displayed. For example ...

ColumnA ColumnB ColumnC
-----------------------
A1 B1 C1
A2 B2 C2
B3 C3
== page break ==
C4
A3 B5 C5
B6 C6

I need to have the repeating cell values displayed on the next page.

Stuff I've tried/tought of ...

* Thought of: Line counting in the extract program -- can't be used
because some of the values (key or non-key) may be multi-line because
of wrapping in Word.

* Thought of: Conditionally printing a key value. I tried using an IF
field to compare PAGE with a bookmark value. I'm probably doing
something wrong here.

Suggestions would be nice.
 
Reply With Quote
 
 
 
 
Jezebel
Guest
Posts: n/a
 
      29th Dec 2003
For each table in the document, check each cell in column 1: for each cell,
store the page number (use the Information() function) and the cell
contents. For each successive column 1 cell, if you're on a new page and the
cell is empty, insert the contents of the previous.


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Word Gurus,
>
> A customer of mine requires that database reports are provided in Word
> format. My database extract program successfully creates a HTML file
> that is imported into Word. Tables look just fine; header lines are
> repeated as expected. Here's the problem:
>
> My extract program removes repeated cell values to enhance
> readability. For example ...
>
> ColumnA ColumnB ColumnC
> -----------------------
> A1 B1 C1
> A2 B2 C2
> B3 C3
> C4
> A3 B5 C5
> B6 C6
>
> As I approach the bottom of a page, a group may be split across two
> pages. This acceptable, however, the repeating cell values from the
> previous page are not displayed. For example ...
>
> ColumnA ColumnB ColumnC
> -----------------------
> A1 B1 C1
> A2 B2 C2
> B3 C3
> == page break ==
> C4
> A3 B5 C5
> B6 C6
>
> I need to have the repeating cell values displayed on the next page.
>
> Stuff I've tried/tought of ...
>
> * Thought of: Line counting in the extract program -- can't be used
> because some of the values (key or non-key) may be multi-line because
> of wrapping in Word.
>
> * Thought of: Conditionally printing a key value. I tried using an IF
> field to compare PAGE with a bookmark value. I'm probably doing
> something wrong here.
>
> Suggestions would be nice.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic generation of a table K Viltersten Microsoft ASP .NET 6 4th Jul 2009 08:11 AM
Dynamic generation of a table Maracay Microsoft Access Database Table Design 3 23rd Jan 2009 10:41 PM
MS Access metadata repository generation query, matrix generationquery, table-generation query, array-generation query. Roy Roebuck Microsoft Access Database Table Design 1 20th Dec 2008 07:23 PM
Advanced SQL Generation Options dimmed Monty Microsoft Dot NET 1 3rd Apr 2006 05:11 AM
Table Script Generation Jean Microsoft Access 1 17th Dec 2003 10:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:48 AM.