Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you change the expression in multiple records....
Message
De
05/10/2000 14:28:44
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
05/10/2000 12:40:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00424294
Message ID:
00425463
Vues:
16
>>>>Robert,
>>>>
>>>>Yes, absolutely, but not in the manner you were thinking of.
>>>>
>>>>USE MyReport.FRX
>>>>REPLACE ALL Expr WITH MyNewExpression FOR ...
>>>>
>>>>To get an idea of what goes in the FOR expression you can read the docs in the FileSpec directory within VFP98\Tools\
>>>>
>>>>
>>>>
>>>>>Can you change the expression in multiple records at one the same time in the report writer in vfp60.
>>>Also, for REPLACE ALL Expr WITH MyNewExpression FOR ...
>>>is Expr the property name I use to identify the property I want to change?
>>
>>Rob, EXPR is the field in myReport.FRX which contains the expression you specify for the report control you place onto report.
>>
>>REPLACE ALL EXPR WITH MyNewExpression FOR objtype = 8
>>will replace the expression for all report fields with myNewExpression
>>
>>REPLACE ALL EXPR WITH '"'+'My new text for all labels'+'"' FOR objtype = 5
>>will change all labels text.
>>
>>The first record of the report file contains the report options in EXPR field like:
>>ORIENTATION=1
>>PAPERSIZE=1
>>PAPERLENGTH=2794
>>PAPERWIDTH=2159
>>COPIES=1
>>etc.
>Hi Nick: The EXPR I want to change is the "Expression for a Field on Report"
>in the Expression Builder. I would like to run a REPLACE ALL. Do I need to
>know the OBJTYPE?

Robert,

I strongly suggest you read the article by Markus Egger I mentioned earlier and open a FRX table and browse the contents and relate what you see there to the article. There is also an article which John Koziol published in FoxTalk which has similar content. Read both - one may make things clearer than the other for you.

You may need to define the field(s) you are after by ObjType, their horizontal or vertical position, or any number of other criteria.

Make a trash copy and experiment with making changes so you can see the results of each change that you make and relate it to how you change things through the GUI interface in the report writer.

These same "hacking" techniques can be used for class libraries, but it's important to really understand what you're doing.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform