Solved

How to configure VFP report to avoid "*****" ?

Posted on 2011-03-25
4
372 Views
Last Modified: 2012-05-11
Hi Experts

I'm facing an amazing problem when migrate a report from FPW2.6 to VFP
One and just one column of the report is desconfigured according with the pictures.
The data is quite similar - so the textbox properties.
How to workaround this ?
Thanks in advance.
 Img 001 img 002
0
Comment
Question by:Eduardo Fuerte
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35220943
There is no way to supress **** other than making your fields wider. If you moved to VFP9 recently, the render engine has changed to gdiplus and in general does noeed a tidbit of more space, so a report running fine for years in older VFP version seems broken.

It's simply VFP denies to print truncated values. So adjust your report and widen your reoprt controls.

Bye, Olaf.
0
 
LVL 41

Accepted Solution

by:
pcelba earned 167 total points
ID: 35221663
Yes, this is will help for sure. Fields can even overlap vertical lines sometimes.

I just don't agree the first sentence... You can also use smaller font. :-))
0
 
LVL 27

Assisted Solution

by:CaptainCyril
CaptainCyril earned 167 total points
ID: 35221675
I would use a smaller font. Tahoma is a good one for decreasing width and you can increase the number format to accomodate more digits in the same place.
0
 
LVL 29

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 166 total points
ID: 35223785
Yes, you're right. Sorry for mentioning "no way" in conjunction with foxpro ;).

A simple solution might be to print with SET REPORTBEHAVIOR 80.

There are indeed also some trim modes in the format section of a report control, but for character fields/expressions only.

For numeric values there also is this efect for a numeric overflow, eg ? 10^308, but in reports I suspect width first, you also get * instead of values if the width is too high, even though there is no numeric overflow.

Bye, Olaf.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now