https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&action=history&feed=atom
Inserting Data from the Data Source View into a Writer Document - Revision history
2024-03-29T09:17:54Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12867&oldid=prev
Jgd: /* Quickly Inserting Fields */ typo
2007-12-02T20:25:46Z
<p><span class="autocomment">Quickly Inserting Fields -</span> typo</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 20:25, 2 December 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 53:</strong></td>
<td colspan="2" align="left"><strong>Line 53:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click and hold on the cell in the upper left hand corner of the data table; drag it into your Writer document. The {{Window|Insert Database Columns}} window appears.</td><td> </td><td style="background: #eee; font-size: smaller;">#Click and hold on the cell in the upper left hand corner of the data table; drag it into your Writer document. The {{Window|Insert Database Columns}} window appears.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Choose whether you want to add data as a {{prefName|Table}}, {{prefName|Fields}}, or {{prefName|Text}} and click on the appropriate radio button.</td><td> </td><td style="background: #eee; font-size: smaller;">#Choose whether you want to add data as a {{prefName|Table}}, {{prefName|Fields}}, or {{prefName|Text}} and click on the appropriate radio button.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#*If you choose {{prefName|Fields}} or {{prefName|Text}}, you can include carriage returns and/or additional text between the various <del style="color: red; font-weight: bold; text-decoration: none;">vields</del>. </td><td>+</td><td style="background: #cfc; font-size: smaller;">#*If you choose {{prefName|Fields}} or {{prefName|Text}}, you can include carriage returns and/or additional text between the various <ins style="color: red; font-weight: bold; text-decoration: none;">fields</ins>. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:''Note that I got an "Expression is Faulty" error with some fields when using the {{prefName|Fields}} setting in the {{Window|Insert Database Columns}} window. I did not see such an error with the {{prefName|Text}} setting using the same layout.''</td><td> </td><td style="background: #eee; font-size: smaller;">#:''Note that I got an "Expression is Faulty" error with some fields when using the {{prefName|Fields}} setting in the {{Window|Insert Database Columns}} window. I did not see such an error with the {{prefName|Text}} setting using the same layout.''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#**You can also specify a {{prefName|Paragraph Style}}.</td><td> </td><td style="background: #eee; font-size: smaller;">#**You can also specify a {{prefName|Paragraph Style}}.</td></tr>
</table>
Jgd
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12863&oldid=prev
Lorinda: /* Creating Forms in Writer Documents */ add wiki and externa links sections
2007-12-02T05:33:47Z
<p><span class="autocomment">Creating Forms in Writer Documents -</span> add wiki and externa links sections</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:33, 2 December 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 80:</strong></td>
<td colspan="2" align="left"><strong>Line 80:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">'''Note''': Once a control has been drawn, you can also access the {{Window|Form Properties}} window by clicking on a control to select it, and then clicking on the {{Button|Form}} button on the Form Controls Toolbar.</td><td> </td><td style="background: #eee; font-size: smaller;">'''Note''': Once a control has been drawn, you can also access the {{Window|Form Properties}} window by clicking on a control to select it, and then clicking on the {{Button|Form}} button on the Form Controls Toolbar.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">==Related Wiki Articles==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[[Intro to the Data Source View]]<br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[[Filtering in the Data Source View]]<br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[[Sorting in the Data Source View]]<br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">==Related External Links==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://www.freesoftwaremagazine.com/articles/triggering_next_record_in_ooo_mail_merges How to print more than one record on a sheet of paper in OpenOffice] an article by Solveig Haugland</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Insérer des Données dans un Document Writer depuis la Fenêtre de Sources de Données|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Insérer des Données dans un Document Writer depuis la Fenêtre de Sources de Données|Français]]}}</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12862&oldid=prev
Lorinda: /* Issues with Image Fields */ write section
2007-12-02T05:31:22Z
<p><span class="autocomment">Issues with Image Fields -</span> write section</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:31, 2 December 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 64:</strong></td>
<td colspan="2" align="left"><strong>Line 64:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Issues with Image Fields===</td><td> </td><td style="background: #eee; font-size: smaller;">===Issues with Image Fields===</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">Unfortunately, none of the approaches above will let you insert images from a database into your Writer documents. In order to use images from your database in Writer documents, you must use an image control in a form. Using forms in a Writer document is discussed below.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Creating Forms in Writer Documents==</td><td> </td><td style="background: #eee; font-size: smaller;">==Creating Forms in Writer Documents==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Forms are not limited to those stored within an odb file. You can also create a form in an "independent" or "external" Writer document. When working with forms, you do not use the Data Source View.</td><td> </td><td style="background: #eee; font-size: smaller;">Forms are not limited to those stored within an odb file. You can also create a form in an "independent" or "external" Writer document. When working with forms, you do not use the Data Source View.</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12861&oldid=prev
Lorinda: /* Quickly Creating a Writer Table */ rename section and write this section
2007-12-02T05:19:02Z
<p><span class="autocomment">Quickly Creating a Writer Table -</span> rename section and write this section</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:19, 2 December 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 46:</strong></td>
<td colspan="2" align="left"><strong>Line 46:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#You can now select a range of records and click on the {{Button|Data to Fields}} button as above, or choose {{Menu|File}} and {{Menu|Print}} to print your document, as above.</td><td> </td><td style="background: #eee; font-size: smaller;">#You can now select a range of records and click on the {{Button|Data to Fields}} button as above, or choose {{Menu|File}} and {{Menu|Print}} to print your document, as above.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">===Quickly <del style="color: red; font-weight: bold; text-decoration: none;">Creating a Writer Table</del>===</td><td>+</td><td style="background: #cfc; font-size: smaller;">===Quickly <ins style="color: red; font-weight: bold; text-decoration: none;">Inserting Fields</ins>===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><br></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">The downside of using the Next Record field is that you have to copy and paste the group of fields as many times as you have records. Here's an easier way.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Open the Data Source View, select the database and then the query or table you want to use, as explained in the [[Intro to the Data Source View]]</ins><br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#[[Filtering in the Data Source View|Filter]] and/or [[Sorting in the Data Source View|Sort]] your data as desired.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Click and hold on the cell in the upper left hand corner of the data table; drag it into your Writer document. The {{Window|Insert Database Columns}} window appears.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Choose whether you want to add data as a {{prefName|Table}}, {{prefName|Fields}}, or {{prefName|Text}} and click on the appropriate radio button.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#*If you choose {{prefName|Fields}} or {{prefName|Text}}, you can include carriage returns and/or additional text between the various vields. </ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:''Note that I got an "Expression is Faulty" error with some fields when using the {{prefName|Fields}} setting in the {{Window|Insert Database Columns}} window. I did not see such an error with the {{prefName|Text}} setting using the same layout.''</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#**You can also specify a {{prefName|Paragraph Style}}.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#*If you choose {{prefName|Table}}, you can move all the fields over by clicking on the {{Button|>>}} button. </ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#**To include column headings, check the {{prefName|Insert table heading}} checkbox. {{prefName|Apply column name}} will use the field names for the column headings. {{prefName|Create row only}} will create an empty first row in the table. Once the table is created, you can enter the column headings you desire.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#**You can select backgrounds and layouts by clicking on the {{Button|Autoformat}} button and making your desired choices in the window that opens</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#**You can specify table properties by clicking on the {{Button|Properties}} button and adjusting settings in the {{Window|Table Format}} window that opens.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Once you have all the settings the way you want them, click {{Button|OK}}</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Your table or text appears in the document.</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Issues with Image Fields===</td><td> </td><td style="background: #eee; font-size: smaller;">===Issues with Image Fields===</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12860&oldid=prev
Lorinda: /* Using the Next Record Field */ write this section
2007-12-02T04:39:05Z
<p><span class="autocomment">Using the Next Record Field -</span> write this section</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 04:39, 2 December 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 30:</strong></td>
<td colspan="2" align="left"><strong>Line 30:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Using the Next Record Field===</td><td> </td><td style="background: #eee; font-size: smaller;">===Using the Next Record Field===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><br></td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">The instructions above will result in one document per record. If you want to see data from more than one record in a single document, you need to use the Next Record Field, as follows. (These instructions assume you have the Data Source View open and your desired query or table selected.)</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Go to the {{Menu|View}} menu. If {{Menu|Field Shadings}} is not checked, select it to turn it on. (This makes it easier to see the Next Record field)</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"># Drag the field name from the column headers in the table area of the Data Source View to the location in your document where you want it to appear. A field name encased in < > will appear in you document.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#* If you have FIeld Names checked in the View Menu you will not see < or >, instead you will see a field name like BirdDatabase.FieldTrips.Location where the pattern is DatabaseFileName.TableOrQueryName.FieldName.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#* If you have Field Shadings turned on the the View menu, the field names will appear with grey highlighting. </ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"># Repeat as often as needed until you have the fields you need in your document. </ins><br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#When you have set all the desired fields in the document, click after the last field you have added. Press the space bar once. (This makes it easier to see the Next Record field when {{Menu|Field Shadings}} is turned on.)</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Go to the {{Menu|Insert}} menu and choose {{Menu|Fields}} and then {{Menu|Other}}. The {{Window|Fields}} window will open.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Click on the {{Section|Database}} tab</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Select {{prefName|Next Record}} in the {{Section|Type}} section and click {{Button|Insert}} You should now see a narrow grey field marker.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Copy all the fields, including the Next Record field and any text you want to repeat for each record.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Click after the Next Record field and paste. (Hit {{Key|Return}} first if you want the next record to appear on a new line.)</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Repeat until you have as many sets of fields as you have records you want to appear.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#You can now select a range of records and click on the {{Button|Data to Fields}} button as above, or choose {{Menu|File}} and {{Menu|Print}} to print your document, as above.</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Quickly Creating a Writer Table===</td><td> </td><td style="background: #eee; font-size: smaller;">===Quickly Creating a Writer Table===</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12833&oldid=prev
Lorinda: /* Adding Fields in the flow of your document */ clarify selected records radio button issue
2007-11-26T18:43:48Z
<p><span class="autocomment">Adding Fields in the flow of your document -</span> clarify selected records radio button issue</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 18:43, 26 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 21:</strong></td>
<td colspan="2" align="left"><strong>Line 21:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Window|Mail Merge}} window that opens, choose your desired settings. Options include:</td><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Window|Mail Merge}} window that opens, choose your desired settings. Options include:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:*You can [[Filtering in the Data Source View|filter]] or [[Sorting in the Data Source View|sort]] using the Table Data Bar in in {{Window|Mail Merge}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#:*You can [[Filtering in the Data Source View|filter]] or [[Sorting in the Data Source View|sort]] using the Table Data Bar in in {{Window|Mail Merge}} window.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#:*You can specify which records you want to print by selecting the desired records. <del style="color: red; font-weight: bold; text-decoration: none;">The </del>{{prefName|Selected records}} radio button <del style="color: red; font-weight: bold; text-decoration: none;">will be automatically </del>selected. <del style="color: red; font-weight: bold; text-decoration: none;">Or</del>, <del style="color: red; font-weight: bold; text-decoration: none;">you </del>can specify a range of records by number.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#:*You can specify which records you want to print by selecting the desired records. <ins style="color: red; font-weight: bold; text-decoration: none;">After selecting the desired records, check to make sure that the </ins>{{prefName|Selected records}} radio button <ins style="color: red; font-weight: bold; text-decoration: none;">has been </ins>selected. <ins style="color: red; font-weight: bold; text-decoration: none;">Sometimes Neo does so automatically</ins>, <ins style="color: red; font-weight: bold; text-decoration: none;">sometimes it does not.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:*You </ins>can specify a range of records by number.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:*You can send the resulting files to the {{prefName|printer}} or to a new {{prefName|File}}. </td><td> </td><td style="background: #eee; font-size: smaller;">#:*You can send the resulting files to the {{prefName|printer}} or to a new {{prefName|File}}. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:**If you choose {{prefName|File}} you can also specify the folder you want to save the file to by clickin on the {{Button|...}} button next to the {{prefName|Path}} field. You have file name autogenerated based on a field, or click on {{prefName|Manual Setting}} and type the name you want. (Note, however, that you will still see the usual Mac {{Window|Save}} dialog when you click {{Button|OK}} button, and you will need to respecify the path and the name).</td><td> </td><td style="background: #eee; font-size: smaller;">#:**If you choose {{prefName|File}} you can also specify the folder you want to save the file to by clickin on the {{Button|...}} button next to the {{prefName|Path}} field. You have file name autogenerated based on a field, or click on {{prefName|Manual Setting}} and type the name you want. (Note, however, that you will still see the usual Mac {{Window|Save}} dialog when you click {{Button|OK}} button, and you will need to respecify the path and the name).</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12832&oldid=prev
Lorinda: /* Creating Forms in Writer Documents */ correct process of accessing Form Properties
2007-11-26T14:05:59Z
<p><span class="autocomment">Creating Forms in Writer Documents -</span> correct process of accessing Form Properties</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:05, 26 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 37:</strong></td>
<td colspan="2" align="left"><strong>Line 37:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Creating Forms in Writer Documents==</td><td> </td><td style="background: #eee; font-size: smaller;">==Creating Forms in Writer Documents==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Forms are not limited to those stored within an odb file. You can also create a form in an "independent" or "external" Writer document. When working with forms, you do not use the Data Source View.</td><td> </td><td style="background: #eee; font-size: smaller;">Forms are not limited to those stored within an odb file. You can also create a form in an "independent" or "external" Writer document. When working with forms, you do not use the Data Source View.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Make <del style="color: red; font-weight: bold; text-decoration: none;">Sure </del>that the Form Controls and Form Design toolbars are visible. If they are not, go to the {{Menu|View}} menu, choose {{Menu|Toolbars}} and select the needed toolbars.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Make <ins style="color: red; font-weight: bold; text-decoration: none;">sure </ins>that the Form Controls and Form Design toolbars are visible. If they are not, go to the {{Menu|View}} menu, choose {{Menu|Toolbars}} and select the needed toolbars.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Click on the {{Button|Form}} button. <del style="color: red; font-weight: bold; text-decoration: none;"> The </del>{{<del style="color: red; font-weight: bold; text-decoration: none;">Window</del>|<del style="color: red; font-weight: bold; text-decoration: none;">Form Properties</del>}} <del style="color: red; font-weight: bold; text-decoration: none;">window should appear.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">#Click on the {{Button|Form <ins style="color: red; font-weight: bold; text-decoration: none;">Navigator</ins>}} button <ins style="color: red; font-weight: bold; text-decoration: none;">on the Form Design toolbar</ins>.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#:You can also reach the </del>{{<del style="color: red; font-weight: bold; text-decoration: none;">Window</del>|<del style="color: red; font-weight: bold; text-decoration: none;">Form Properties</del>}} <del style="color: red; font-weight: bold; text-decoration: none;">window by clicking on the </del>{{<del style="color: red; font-weight: bold; text-decoration: none;">Button</del>|Form <del style="color: red; font-weight: bold; text-decoration: none;">Navigator</del>}} <del style="color: red; font-weight: bold; text-decoration: none;">button, control</del>-<del style="color: red; font-weight: bold; text-decoration: none;">clicking </del>on the <del style="color: red; font-weight: bold; text-decoration: none;">name of the </del>form (most likely Standard), and <del style="color: red; font-weight: bold; text-decoration: none;">choosiing </del>{{Menu|Properties}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Control-click or right click on the folder named </ins>{{<ins style="color: red; font-weight: bold; text-decoration: none;">Section</ins>|<ins style="color: red; font-weight: bold; text-decoration: none;">Forms</ins>}} <ins style="color: red; font-weight: bold; text-decoration: none;">and choose </ins>{{<ins style="color: red; font-weight: bold; text-decoration: none;">Menu</ins>|<ins style="color: red; font-weight: bold; text-decoration: none;">New</ins>}} <ins style="color: red; font-weight: bold; text-decoration: none;">and then </ins>{{<ins style="color: red; font-weight: bold; text-decoration: none;">Menu</ins>|Form}} <ins style="color: red; font-weight: bold; text-decoration: none;">from the contextual menu.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Control</ins>-<ins style="color: red; font-weight: bold; text-decoration: none;">click or right click </ins>on the <ins style="color: red; font-weight: bold; text-decoration: none;">newly created </ins>form (most likely Standard), and <ins style="color: red; font-weight: bold; text-decoration: none;">choose </ins>{{Menu|Properties}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Section|Data}} tab.</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Section|Data}} tab.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|...}} next to {{prefName|Data Sources}} and browse to locate the desired data source</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|...}} next to {{prefName|Data Sources}} and browse to locate the desired data source</td></tr>
<tr><td colspan="2" align="left"><strong>Line 45:</strong></td>
<td colspan="2" align="left"><strong>Line 46:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Select the desired Query or Table from the {{prefName|Content}} drop-down</td><td> </td><td style="background: #eee; font-size: smaller;">#Select the desired Query or Table from the {{prefName|Content}} drop-down</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Adjust other settings as desired, and close the {{Window|Form Properties}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#Adjust other settings as desired, and close the {{Window|Form Properties}} window.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">From this point on, editing forms in an independent Writer document should work the same way editing forms stored in <del style="color: red; font-weight: bold; text-decoration: none;">he </del>odb file do.</td><td>+</td><td style="background: #cfc; font-size: smaller;">From this point on, editing forms in an independent Writer document should work the same way editing forms stored in <ins style="color: red; font-weight: bold; text-decoration: none;">the </ins>odb file do<ins style="color: red; font-weight: bold; text-decoration: none;">.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">'''Note''': Once a control has been drawn, you can also access the {{Window|Form Properties}} window by clicking on a control to select it, and then clicking on the {{Button|Form}} button on the Form Controls Toolbar</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Insérer des Données dans un Document Writer depuis la Fenêtre de Sources de Données|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Insérer des Données dans un Document Writer depuis la Fenêtre de Sources de Données|Français]]}}</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12831&oldid=prev
Lorinda: /* Adding Fields in the flow of your document */ fix link problem
2007-11-26T13:52:08Z
<p><span class="autocomment">Adding Fields in the flow of your document -</span> fix link problem</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:52, 26 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 25:</strong></td>
<td colspan="2" align="left"><strong>Line 25:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:**If you choose {{prefName|File}} you can also specify the folder you want to save the file to by clickin on the {{Button|...}} button next to the {{prefName|Path}} field. You have file name autogenerated based on a field, or click on {{prefName|Manual Setting}} and type the name you want. (Note, however, that you will still see the usual Mac {{Window|Save}} dialog when you click {{Button|OK}} button, and you will need to respecify the path and the name).</td><td> </td><td style="background: #eee; font-size: smaller;">#:**If you choose {{prefName|File}} you can also specify the folder you want to save the file to by clickin on the {{Button|...}} button next to the {{prefName|Path}} field. You have file name autogenerated based on a field, or click on {{prefName|Manual Setting}} and type the name you want. (Note, however, that you will still see the usual Mac {{Window|Save}} dialog when you click {{Button|OK}} button, and you will need to respecify the path and the name).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:**If you choose to send the results to the printer, you can specify {{prefName|Single print jobs}}, where each record will generate a separate print job.</td><td> </td><td style="background: #eee; font-size: smaller;">#:**If you choose to send the results to the printer, you can specify {{prefName|Single print jobs}}, where each record will generate a separate print job.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">'''Note''' That this method creates one copy of the document for each record. If you want all the records to appear in one document, you need to use the [[#Next Record Field|Next Record field] or [[#Quickly Creating a Writer Table|create a table.]</td><td>+</td><td style="background: #cfc; font-size: smaller;">'''Note''' That this method creates one copy of the document for each record. If you want all the records to appear in one document, you need to use the [[#<ins style="color: red; font-weight: bold; text-decoration: none;">Using the </ins>Next Record Field|Next Record field<ins style="color: red; font-weight: bold; text-decoration: none;">]</ins>] or [[#Quickly Creating a Writer Table|create a table.<ins style="color: red; font-weight: bold; text-decoration: none;">]</ins>]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><br></td><td> </td><td style="background: #eee; font-size: smaller;"><br></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Using the Next Record Field===</td><td> </td><td style="background: #eee; font-size: smaller;">===Using the Next Record Field===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><br></td><td> </td><td style="background: #eee; font-size: smaller;"><br></td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12829&oldid=prev
Jgd: botlangbar --> Fr page
2007-11-26T13:45:32Z
<p>botlangbar --> Fr page</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:45, 26 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 45:</strong></td>
<td colspan="2" align="left"><strong>Line 45:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Adjust other settings as desired, and close the {{Window|Form Properties}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#Adjust other settings as desired, and close the {{Window|Form Properties}} window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">From this point on, editing forms in an independent Writer document should work the same way editing forms stored in he odb file do.</td><td> </td><td style="background: #eee; font-size: smaller;">From this point on, editing forms in an independent Writer document should work the same way editing forms stored in he odb file do.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">{{botlangbarEN|[[Fr:Insérer des Données dans un Document Writer depuis la Fenêtre de Sources de Données|Français]]}}</td></tr>
</table>
Jgd
https://neowiki.neooffice.org/index.php?title=Inserting_Data_from_the_Data_Source_View_into_a_Writer_Document&diff=12687&oldid=prev
Lorinda: continue to write the article
2007-11-14T01:51:59Z
<p>continue to write the article</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:51, 14 November 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 19:</strong></td>
<td colspan="2" align="left"><strong>Line 19:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#A box will appear asking if you want to print form letter. Click on {{Button|Yes}}.</td><td> </td><td style="background: #eee; font-size: smaller;">#A box will appear asking if you want to print form letter. Click on {{Button|Yes}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:'''Do not,''' under any circumstances, check the "Do not show warning again" box. If you do, you will only be able to print documents with field names any time you try to print a document with fields in it. The only way to undo this is to [[Troubleshooting_Tips#Remove existing preferences|move or rename your preferences file]].</td><td> </td><td style="background: #eee; font-size: smaller;">#:'''Do not,''' under any circumstances, check the "Do not show warning again" box. If you do, you will only be able to print documents with field names any time you try to print a document with fields in it. The only way to undo this is to [[Troubleshooting_Tips#Remove existing preferences|move or rename your preferences file]].</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#In the {{Window|Mail Merge}} window that opens, choose your desired settings. Options include:</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:*You can [[Filtering in the Data Source View|filter]] or [[Sorting in the Data Source View|sort]] using the Table Data Bar in in {{Window|Mail Merge}} window.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:*You can specify which records you want to print by selecting the desired records. The {{prefName|Selected records}} radio button will be automatically selected. Or, you can specify a range of records by number.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:*You can send the resulting files to the {{prefName|printer}} or to a new {{prefName|File}}. </ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:**If you choose {{prefName|File}} you can also specify the folder you want to save the file to by clickin on the {{Button|...}} button next to the {{prefName|Path}} field. You have file name autogenerated based on a field, or click on {{prefName|Manual Setting}} and type the name you want. (Note, however, that you will still see the usual Mac {{Window|Save}} dialog when you click {{Button|OK}} button, and you will need to respecify the path and the name).</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:**If you choose to send the results to the printer, you can specify {{prefName|Single print jobs}}, where each record will generate a separate print job.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">'''Note''' That this method creates one copy of the document for each record. If you want all the records to appear in one document, you need to use the [[#Next Record Field|Next Record field] or [[#Quickly Creating a Writer Table|create a table.]</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"><br></ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">===Using the Next Record Field===</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><br></td><td> </td><td style="background: #eee; font-size: smaller;"><br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Quickly Creating a Writer Table===</td><td> </td><td style="background: #eee; font-size: smaller;">===Quickly Creating a Writer Table===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><br></td><td> </td><td style="background: #eee; font-size: smaller;"><br></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">===Using the Next Record Field===</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;"><br></del></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Issues with Image Fields===</td><td> </td><td style="background: #eee; font-size: smaller;">===Issues with Image Fields===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Creating Forms in Writer Documents==</td><td> </td><td style="background: #eee; font-size: smaller;">==Creating Forms in Writer Documents==</td></tr>
</table>
Lorinda