Hi Naomi.

>I believe the first error in two errors we got was related with the fact that I tried to define a relationship on a field already engaged in relationship and the other error we got was related with the fact I didn't specify JOIN condition properly (I only added AND clause since I thought the main join condition is already defined).

OK, thanks.

>The other little problem we found is that even after I added captions to the fields, since the fields were already added to report, the captions in the report didn't change - we had to remove the fields and re-add them.

The heading for a field is assigned at the time you create the report. Since it's possible to change the heading for a particular field in a particular report, we can't go back and change the headings in the report after you change them in the data dictionary, as that would potentially overwrite your custom changes.

>Finally, the Quick report option is somethat limited and doesn't really create professional looking report (or it didn't for us). Say, page was too close to the right margin and was only printing Page (and no actual page), etc.

It sounds like the text was cut off at the right edge for some reason. The only time I've seen that is with a weird printer driver.

>In order to get the report look right, I needed to edit the layout. But once edited, I could not change it (add/remove fields). And if I unclicked Advanced Layout, I went back to the original problem with misaligned fields.

Once you've turned it into an advanced layout report, you can't use Step 2 to add or remove fields, because you've "fixed" the layout of the report in the Advanced Report Designer. However, you can easily add and remove fields in the Advanced Report Designer or make any other changes you wish.

Doug