This brings a super cool new feature, allowing you to add some basic HTML texts to your fields. This means that you can from now on determine how EACH WORD in your field should be formatted!
See the image below, all the text is in ONE SINGLE FIELD !
How to do it ?
Very very simple:
- Open your report, in Edit mode
- Double-click the field that you want to add the tagged formatting. This will open the field properties dialog
- Click on the "Other" tab
- Click on the "Edit user data..." button
- Add the string "<TF>" as shown in the picture below:
And just add the HTML code below to that field:
The search capabilities are kept, and exporting to PDF returns an excellent output as well.
Here is the list of the available TAGS that you can use:
Feature | Opening Tag | Closing Tag |
bold | <b> | </b> |
italic | <i> | </i> |
underline | <u> | </u> |
strikethru | <s> | </s> |
text color | <color=rgb/ncolor > <c= > | </color> </c> |
text backcolor | <highlight=rgb/ncolor> <h=rgb/ncolor> <backcolor=rgb/ncolor> | </highlight> </h> </backcolor> && in FP v3 |
font name | <fontname=”name”> <fname=”name”> | </fontname> </fname> |
font size | <fontsize=n> <fsize=n> | </fontsize> </fsize> |
whole font style | <fontstyle=”BIUS”> <fstyle=”BIUS”> | </fontstyle> </fstyle> |
force new line (CRLF) | <br> CHR(13) CHR(10) CHR(13) + CHR(10) |
NB: could prevent transform if '</' not in string
Special thanks to Eduard Alexandru, from Bucarest, Romania, for his essential help in this feature, help in discussions and for providing some procedures to deal with the tagged texts.
This feature still needs some tests. It is possible that you find some tags that are not being considered, please me!
Check the sample SAMPLE_TF.FRX in the latest FoxyPreviewer release to play with the new features.
Do not get tired of saying: Thanks Cesar
ReplyDeleteCesar!
ReplyDeleteThis is indeed a very cool feature. Thanks for sharing.
Koen
Thanks Cesar, It would be nice if you can add a click to open new report/form functionality in foxypreviewer reports.
ReplyDeleteThanks Zaheer,
ReplyDeleteBut this will not be possible, since VFP does not allow one report to open another.
Thanks Koen !
ReplyDeleteYour support, evaluations and help are always very welcome!
Amazing Cesar thanks!
ReplyDeleteHi,
ReplyDeleteVery exciting development ! There is a problem when a report is running without the preview argument, like:
REPORT FORM Myreport NEXT 1 TO PRINTER
No problem with PREVIEW
Thank's very much
Hi Vincent.
ReplyDeleteYou only said "There is a problem"...
But what problem? Please provide as much details as you can, so that I can understand what is going wrong, what feature has probles at your side.
I am testing it, but When I export/ save with foxyPreviewer the fields don´t appear at excel files, and no color or anything for the objects: example:
ReplyDeleteadd to report a field with this
[TradeTerms]+[-my terms-]
Preview report: I got 2 colors. purple and black.
Save as XLS: I got a empty excel with nothing where the report field is.
IF I put colors for the label via ¨style¨ tab in properties of field, in preview I got the colors, but in export XLS font is always black
When I export the report to PDF I only getting some format where no report data on it. This is occurs when a executable file is run in a different computer (Not the computer where the report is design)
ReplyDeleteThanks for reporting!
ReplyDeleteThis issue was solved in v2.99
excellent work here....well done.
ReplyDeleteDo the HTML Tags support superscript and subscript tags i.e. HTML and Tags ?
Hi, has anyone been able to combine this function with the full justified field? When I test it, Foxy only does the formatting text, but not the justification.
ReplyDelete