Hi Pablo,
Have you considered pre-processing your data into a report cursor? You could
use StrTran() in the SQL or do a Replace All on the cursor if it's writable.
To me this is much easier to work with and debug.
You can have all the same field names in your report. Just remove the source
table's name - i.e. use MyField and not MyTable.MyField. If you need to you
can open the FRX as a table and use Replace to change these for you.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden (at) mvps .D.O.T org
-----Original Message-----
From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces (at) leafe .D.O.T com] On
Behalf Of Pablo Sebastian Velazco
Sent: Wednesday, March 31, 2004 3:05 PM
To: profoxtech@leafe.com
Subject: STRTRAN & Reports
Hello,
I have a nice report, in some fields shown in the report I need to transform
what it's shown.
Example:
I have name_customer in the report.
need to replace all "C" characters with "X", and "D" characters with "Y",
then show the report.
Can I do this without touching the source cursor, I mean, only modifying the
report. I am trying with strtrans(). Is it possible? where should I have to
put strtrans()?
©2004 Cindy Winegarden |
