Paradox v8 or v9 reports for producing Letters
John Wright
I frequently use a report to produce a letter rather than using WordPerfect
to import from the Paradox data, because the Report provides much better
selection via field 'iif' calculations etc., based on the content of other
Paradox fields. The letter content is editable through a form which works
fine and the general presentation is fine but although the text can be made
Bold or can be Underlined in or through the form, this does not get 'picked
up' when the text is used in the report (letter).
Is there a way that this can be achieved?
Bertil Isberg
John
<<
The letter content is editable through a form which works
fine and the general presentation is fine but although the text can be made
Bold or can be Underlined in or through the form, this does not get 'picked
up' when the text is used in the report (letter).
>>
How is it sent from the form to the report?
--
Bertil Isberg - CTECH
Paradox buglist:
online: http://w1.826.comhem.se/~u82608896/
FAQ newsgroup: corel.wpoffice.paradox-faq
Michael Israel
If you are using a memo field for the body of the letter, change it to a
formatted memo field. Formatted memo fields and their desired results can
be quirky but may be just fine for your needs.
John Wright
Bertil,
The Form relates directly to the Table holding the required data (wording),
with each field generally representing say a paragraph in the eventual
letter (Report). So that part is fine - in other words I can change the
wording using the form.
Then the wording is extracted by fields in the Report which either 'look'
directly at the appropriate field in the Table or select the field relative
to the 'iif' statements set in those fields in the Report.
As I say, the layout and content of the resulting letter is absolutely fine.
It is just that where I would like to underline or emphasise (bold) a word
or phrase I cannot achieve this in the final product.
Thanks for responding thus far.
"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:419f4a59$1_2@cnews...
Michael Israel
> As I say, the layout and content of the resulting letter is absolutely
fine.
> It is just that where I would like to underline or emphasise (bold) a word
> or phrase I cannot achieve this in the final product.
The only way to do AFAIK is to use formatted memo fields. If you can
restructure your table and change the field type to formatted memo without
losing data, you should be able to do what you want.
John Wright
Thanks Michael,
I have already set these fields to Formatted Text. I can set the text as
Bold or Underline using the form but when the text is recovered via the
Report to produce the final letter the text formatting does not 'come
through'.
Thanks for responding though.
"Michael Israel" <mb...@spamlessoptonline.net> wrote in message
news:419f9174$1_1@cnews...
Michael Israel
> I have already set these fields to Formatted Text
I assume you meant formatted memo (F) in the field type.
Bertil Isberg
John
<<
or select the field relative to the 'iif' statements set in those fields in
the Report.
>>
Formatted memos may loose thier formatting if handled by string methods.
Michael Israel
Bertil,
I just re-visited an old from with a formatted memo field. It doesn't
retain any changes in font style that I make. At one time I remember that
it did. Here is the code on the arrive method of the field:
doDefault
;// Enter memo view
;//
If Not isedit() Then
patient.action(databeginedit)
endIf
self.postaction(EditEnterMemoView)
self.font.typeface = "Times New Roman"
self.font.size = 12
Bertil Isberg
Michael
<<
self.postaction(EditEnterMemoView)
self.font.typeface = "Times New Roman"
self.font.size = 12
>>
your EditEntermemoview is a postaction, so it hasn't occurred when you
change the typeface. postaction() means the action will be placed at the end
of the event queue after chaging typeface and size.
dodefault
self.postaction(EditEnterMemoView)
self.postaction(UserAction+1)
method action(var eventInfo ActionEvent)
if eventinfo.id()=useraction+1 then
self.action(SelectSelectAll)
self.font.typeface = "Times New Roman"
self.font.size = 12
endif
endMethod
John Wright
Yes that is correct, the respective fields are set to Formatted Memo (F).
"Michael Israel" <mb...@spamlessoptonline.net> wrote in message
news:419fa961_2@cnews...
John Wright
Well, an example is copied below...
========================================
iif([MASTER.Country Member]= "C" or [MASTER.Country Member]= "H"
,[MASTER.AddedText1],iif([MASTER.Non Dining] = "ND","As a Non Dining Member
I will assume YOU ARE NOT DINING unless you advise otherwise and
"+[MASTER.MainText],[MASTER.MainText]))
========================================
"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:419fb89b_3@cnews...
Anders Jonsson
> ========================================
> iif([MASTER.Country Member]= "C" or [MASTER.Country Member]= "H"
> ,[MASTER.AddedText1],iif([MASTER.Non Dining] = "ND","As a Non Dining
> Member
> I will assume YOU ARE NOT DINING unless you advise otherwise and
> "+[MASTER.MainText],[MASTER.MainText]))
>
> ========================================
I think what is happening here is than when you add the string to the
formated memo field, the formating gets lost.
You might be able to achieve what you want by using a text object and a
combinations of calculated fields and your formated memo fields _inside_ the
text object. The important thing is to not add anything to the formated memo
fields.
Anders Jonsson
Michael Israel
To get this to work, I resorted to the "field expert" and set up the field
as an enhanced memo field.
Michael Israel
Bertil,
Your method doesn't work for me. I get an error message "Not in Edit Mode
press F9". OK do that and font style formatting does not remain if I depart
and arrive again.
"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:41a055b0$1_3@cnews...
Bertil Isberg
My code worked for me when tested in Paradox 11.302
I didn't have any other code in my form.
Of course the form has to be in edit mode, otherwise you can't change the
properties of a formatted memo.
Bertil Isberg
Anders
<<
I think what is happening here is than when you add the string to the
formated memo field, the formating gets lost.
>>
I agree.