Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modify report in run time
Message
From
28/08/2000 11:50:00
Scott Butts
Ims Specialty Services
Twin Falls, Idaho, United States
 
 
To
28/08/2000 05:14:18
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00409711
Message ID:
00409836
Views:
25
Here is some code I found here a while back, Hope it helps.
************************************************
* turn on the toolbar for reports
LOCAL coalias, lok,ccurrentrfile,lcoldonerror

* if retrun if this is the standard or professinal version
* ie this is the development environment so that the
* resource file isn't changes
IF VERSION(2) = 2 OR VERSION(2) = 1
	RETURN
ENDIF

coalias=ALIAS()
ccurrentrfile = SYS(2005)
SET RESOURCE OFF
lok = .T.
lcoldonerror = ON("error")
ON ERROR lok = .F.
USE &ccurrentrfile EXCLUSIVE IN 0

IF lok
	SELECT foxuser
	GO TOP
	LOCATE FOR TYPE = "PREFW" AND ID = "REPORTTOOLS"
	IF FOUND()
		REPLACE ckval WITH 60721,UPDATED WITH DATE()
	ELSE
		INSERT INTO foxuser (TYPE,ID,NAME,READONLY,ckval,DATA,UPDATED) ;
			VALUES ("PREFW","REPORTTOOLS","",.F.,60721,"",DATE())
	ENDIF
	USE IN foxuser
ENDIF

SET RESOURCE ON
SET RESOURCE TO &ccurrentrfile
IF NOT EMPTY(coalias)
	SELECT (coalias)
ENDIF
ON ERROR &lcoldonerror
RETURN
Previous
Reply
Map
View

Click here to load this message in the networking platform