Reassigned to ES.

Please submit a sample document + dataabase explaining which condition
you used to make the "Any Record" work.

Created attachment 4649 [details]
a sxw and a text-database

The misbehaviour of "any record" is probably based on misfunctioning 
in StarOffice 5.2.  In our application in 5.2 we used "any record" as 
followed: In our database we select for instance 5 records
All the records contained the same name and adres information and 
every records contains different  price information about 5 different 
products. Now we used this information for making price proposals to 
our clients using mail merge fields. 
First we have the adress information of the client and beneath that 
we put a table with 5 rows containing the product information. Under 
the table we reuse some adress information of our client. For 
separating the product information on every row, we put on the end of 
every row a next record field. 
Under the table the letter continued and we used the name of the 
person to sign the letter in a "mail merge field". 
In StarOffice 5.2 the only way to get database information in a "mail 
merge field" under the table was the use of "any record" with leaving 
the record number information blank.
Now in OpenOffice643 "any record" with leaving the record number 
information blank after the last record results in an empty "mail 
merge" field.  
The only way to get information under the table is selecting the 
right record number for every record.
That need to be hard coded... but we resolvt the problem with making 
an extra record in the database so we use the extra record for the 
dat under the table.
So far so good. But things go wrong if you put an any record before 
the table. Than he can select no information at all in the table or 
wrong information. 
Just a question: How can we select any record out of the selected 
records without giving a hard record number.  We tried * without 
luck (we tried to reproduce the behaviour of 5.2).

Thank you for your time and cooperation.

Could you please step by step instructions on how to reproduce this
problem using your attached files?  I am having a hard time
understanding what you want to do from your last explaination.

Does this problem still exist in 1.1 Beta 2?

The situation with te 1.1 beta2 is even more confusing:
here while printing with the mail-merge funktion, 2 "next-records" on 
the same tabel-row produces BLANCO prints.
Idem dito when printing with your standard label-layouts its produced 
also blanco prints

Hello sos,

could you please provide a step by step description for reproducing your issue?
This would make it easier for you and us to understand what the problem is.

Since noone could add additional information to this issue for 9 months, i will 
close it for now.

Sos, you are free at anytime to reopen this issue, if you can
1) provide a step by step desciption describing your problem and
2) if you can also reproduce it with a recent build like 1.1.1rcX or, in the
future - because it has not been released yet - 1.1.1.

Thank you for using and supporting OpenOffice.Org!
Max Weber, OOo Volunteer

.

I'm finding the behavior of the "any record" and "next record" fields extremely
inconsistent and confusing.  But since I'm trying to use these features for the
first time, maybe I'm not understanding how it's supposed to work.

Here's a test with OOo 2.0.4 (SUSE Linux 10.1 RPM package):
1. Create a new Writer document
2. Select from menu: Insert > Fields > Other...
   a. Go to the Database tab
   b. Select "Any record" in the Type list
   c. Set Record Number to 1 (for first record)
   d. Click Insert button then Close button
3. Press Enter in the document to add a new line
4. Open Datasources (F4)
   a. Navigate to a table of a database (I'm using the biblio table of the
included Bibliography database)
   b. Click a heading in the table (e.g. Identifier)
   c. Drag the heading to the document on the second line (this should insert a
field for this record in the document)
   d. Press Enter to add a new line
5. Go back to Insert > Fields > Other... and add a field of type "record
number", put a new line after that, and add a field of type "next record" and
add a new line.
6. Copy and paste these last three lines a few times at the end of the document
to repeat them.
7. In the datasources area, click the upper-left of the table to select all
records, then click the Data to Fields button in the toolbar.
8. Make sure View > Field Names is *un*checked.

Actual result: No text in the document, other than the record number fields,
which all read "1"
Expected result: The first few records of the Identifier fields should be shown,
and the record number fields should read follow the sequence 1, 2, 3, etc.

9. Now double-click the Any Record field on the first line of the document. 
Change the record number to 2 and click OK.
10. Repeat steps 7-8.

Actual result: The "expected results" mentioned above occur.  Even though the
record number entered was 2, it's starting with the *first* record, and the
first Record Number field reads "1". (Likewise, if the "any record" field was
set to record number 3, it starts with the *second* record.) I can understand
numbering records starting with 0, but why would they begin numbering with 2?

11. Finally, add at the end of the document another Any Record field (on its own
line) and set the record number to 2 again.
12. Copy everything from the second line of the document to the line before this
new Any Record field and paste it below the new Any Record field.
13. Repeat steps 7-8.

Now, earlier when I tried this, it displayed the records in an order like the
following:
<any record,record#2> 1, 2, 3, 4 <any record,record#2> 1, 5, 6, 7
It was as if the Next Record fields were continuing from where they left off
instead of continuing from the last Any Record field

But this time (as I'm writing this) it's doing what I would have expected:
<any record,record#2> 1, 2, 3, 4 <any record,record#2> 1, 2, 3, 4

I cannot figure out why it would do this one way one time and a different way
the next.

Another issue I encountered is when there are more "Next Record" fields and
mail-merge fields than there are records in the database. The mail-merge fields
for the records beyond the end of the database show up blank, and in this
scenario all subsequent "Any record" fields seem to have no effect at all,
regardless of the record number they're set to.

It took me a long time to figure out that I had to set the record number for the
"any record" field one higher than what I actually wanted, and even longer to
figure out why the "any record" fields weren't working (I had inserted more
fields than records in the database earlier in the document). Searching the OOo
help documentation, OOo forum, or Issuezilla did not come up with *any* clues,
leaving me to figure all this out on my own. Therefore, I feel there is either a
bug in OOo regarding these fields and/or poor user documentation.

Created attachment 74008