>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
Thanks again. Perhaps the problem is indeed in the Printer Driver. Do you know how to check the problem and correct if necessary? The computer doesn't have VFP installed, only VFP based Exceed program with which I have a hard time trying to figure out the meaning of tables, fields and relations between them.
I guess I need to completely work out DataDictionary first.
I have another question - is there a way to design a custom template using SQuery? Say, I would like certain fonts, general page layout, may be specific Header and Footer and I would like to be able to change the template and have the changes reflected in all reports - is it possible?
Also for the filter condition - is there a way to be able to change wording on it without going to Advanced Layout?
Thanks again for your help.
If it's not broken, fix it until it is.
My Blog