Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cesar
  Where is Cesar?
 
 Brazil
 Cesar
 To: tom knauf
  Where is tom knauf?
 
 Germany
 tom knauf
 Tags
Subject: RE: FoxyPreviwer/DE-FoxyPreviewer ??
Thread ID: 395595 Message ID: 396034 # Views: 42 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Reports and Printers
Date: Wednesday, January 22, 2014 12:07:55 PM         
   


> Hello Cesar,
>
> yes, hotfixes are important.
> The "I see *****" appears in our programs on systems which all on 7423.
> With "reportbehaviour 80" or by making the fields a little bit wider or (not always) by using foxy with lexpandfields :-) it disappears.
>
> When I find some time I try to extract data and reports to make a sample.
>
> regards
> tom


Hello Tom,

The "*****" issue has been much more than discussed here and all over the web. This is an old issue, and there is nothing more that I can or will do regarding it.



Text extracted from the FAQS

When I run my reports with FoxyPreviewer sometimes asterisks symbols ********************* appear instead of the field. This was originally working, before using FoxyPreviewer

That happens because FoxyPreviewer uses the SET REPORTBEHAVIOR 90 mode, that uses GDI+ to render the texts. Unfortunately there is a slight difference of the size of the strings between these modes. To fix it, just edit your report and enlarge that field !

With FoxyPreviewer, you can set the new property - lExpandFields to make the report engine show the field numeric value ignoring the field size.
Using "lExpandFields", FoxyPreviewer retrieves the value that overflowed and resends it to the report engine with an enlarged field width.

This is a known issue, and Lisa Slater Nicholls wrote a short blog post regarding it:
Why do report layouts in VFP9 need wider field/expression controls than in VFP8 and earlier?
http://spacefold.com/colin/posts/2005/08-18GDIplusinreports.html

And here's another interesting text from Lisa, that explains the reason for that:

With REPORTBEHAVIOR=90, the new report engine uses GDI+ to render output, and text string rendering requires more space than plain old GDI.
The Report Desiginer uses GDI - not GDI+ - to render the report layout components, including all the text strings that you see. So if you visually right-align a label report element, the report designer records the leftmost co-ordinates of the element (the text start position) in the layout.
The length of the string under GDI+ rendering will most likely be greater than what you would think, based on what you see in the Designer.





Now my personal opinion:
In my main application, we have 300 reports running.
To avoid this issue, all I did was to create a small PRG that opened all the FRXs in the folder, and expanded the widths in 10%.
After that, I needed to edit manually not more than 5 reports, everything was fine.

You have the possibility of using the "lExpandFields" property, but I prefer not.
I only created it because of people complaining... This makes the report run slower.



Regards,

m.Cesar
My Blog

ENTIRE THREAD

FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Binod Binani @ 1/16/2014 7:11:23 AM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Stefan Wuebbe @ 1/16/2014 7:34:42 AM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Binod Binani @ 1/16/2014 9:33:03 AM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Nadeem Shah @ 1/16/2014 5:40:29 PM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Paul Gibson @ 1/17/2014 2:14:07 PM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by tom knauf @ 1/21/2014 10:31:16 AM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Cesar @ 1/21/2014 12:45:52 PM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by tom knauf @ 1/22/2014 11:00:52 AM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Cesar @ 1/22/2014 12:07:55 PM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Koen Piller @ 1/22/2014 12:42:19 PM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Paul Gibson @ 1/23/2014 11:47:05 AM
RE: FoxyPreviwer/DE-FoxyPreviewer ?? Posted by Koen Piller @ 1/16/2014 9:26:48 AM