Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding variables by hacking
Message
From
14/09/2009 13:35:32
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01423992
Message ID:
01424241
Views:
55
Naomi:

Thanks!

Since it's a list of variables I was after, the fieldname is a little different. Here's the whole program I wrote to take care of this. Thanks again.
CLOSE ALL

USE GROWPERF.FRX

COPY STRUCTURE TO temp

LOCATE FOR AT('t_',NAME) > 0 AND objtype = 18  &&variable

DO WHILE .T.
	IF EOF()
		EXIT
	ELSE
		SCATTER MEMVAR MEMO
		m.Name = STRTRAN(m.Name, "t_","r_")
		m.Uniqueid = SYS(2015)
		INSERT INTO temp FROM MEMVAR
		CONTINUE
	ENDIF
ENDDO

APPEND FROM temp
Yossi


>>Hi All:
>>
>>What is the easiest way to add a bunch of variables to a report by hacking the FRX?
>>
>>I have ten variables, all beginning with c_. I want add another 10, prepending them with v_ and have the totalling break on a different group.
>>
>>I'm lazy to do this 'by hand'.
>>
>>Thanks,
>>
>>Yossi
>
>Yossi,
>
>Make a copy of the current report, browse the report as a table, find a record with one of the c_ variables, and then try
>
>scatter memvar memo
>m.Expr = strtran(m.Expr, "c_","v_")
>m.Uniqueid = SYS(2015)
>insert from memvar
>
>
>If the report will work after that, just repeat the same process for other variables.
>
>See also http://weblogs.foxite.com/cesarchalom/archive/2006/05/16/1531.aspx
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform