INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

VFP9 Report only displays uppercase text on a field when previewing.

VFP9 Report only displays uppercase text on a field when previewing.

VFP9 Report only displays uppercase text on a field when previewing.

(OP)
Hello,

I have designed a report in VFP9 where I grab the data from a table. The table stores a list of product and have a Character field named category which categorizes the product. Im using uppercase 'A', lowercase 'a', uppercase 'W' and lowercase 'w' on that category field. Anyways on my report I have the field category but when I preview it it only gives me the uppercase products. Im not sure how to fix this. Any help will be much appreciated.

Thank you

RE: VFP9 Report only displays uppercase text on a field when previewing.

I'd first open up the Report Form in VFP's Development mode and look at the Font which is being used.
There are some Fonts which are shown as UPPERCASE only (such as: Algerian, Castellar, and others).
If that is the case, change Fonts and try to run the report again.

Alternatively I'd put a SET STEP ON into the code immediately before you issue the REPORT FORM command.
When running the code in the Development mode, it will SUSPEND execution and automatically open the TRACE Window.
From there you can go to the Command Window and BROWSE the report's data table and see if the field values are all UPPERCASE.
If that is the case, then your code is causing the problem somewhere.

Good Luck,
JRB-Bldr

RE: VFP9 Report only displays uppercase text on a field when previewing.

It could be as simple as the format of the report control has the format option "To upper case" ticked, so all values are upper cased.

Bye, Olaf.

RE: VFP9 Report only displays uppercase text on a field when previewing.

(OP)
Thanks I actually found the data in the report, but im kinda confuse. Before running the report im sorting the data before and putting it in the table with order by category asc, but when I see the data on the report all the products with caterogy "A" and "W" show first and then on then on the bottom the products with category "a" and "w". Im not sure why? isnt it should order them first all the A's upper and lowercase then the rest? this is confusing.

RE: VFP9 Report only displays uppercase text on a field when previewing.

Ah, simply a sort order issue.

Either get used to VFP sorting by ASCII code, so uppercase comes before lowercase, or SET COLLATE TO "GENERAL" to sort case insensitive.

Just be warned your query optimization is lost, when your collation differs from index collation indexes are not used for Rushmore query optimization.

Before you reindex everything with general collation and make that the default collation of VFP for sorting, a better compromise is to keep collation at machine, keep all indexes as they are and ORDER BY UPPER(field) or LOWER(field), which also makes the sorting case insensitive by forcing one case. It doesn't matter whether upper or lower.

Bye, Olaf.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close