Erin Trotter Posted November 20 Posted November 20 (edited) I'm using webfocus 9.3.1. In the past, I have been able to create a report and set the format as a parameter and get prompted for a value when it is run. Now, for some reason (and maybe it's this version), it just throws an error on the report saying that the value for the parameter called &FORMAT is not valid. Here is a sample report with the CAR file. TABLE FILE car BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR BY CAR.BODY.SEATS BY CAR.BODY.DEALER_COST BY CAR.BODY.RETAIL_COST BY CAR.BODY.SALES BY CAR.SPECS.LENGTH ON TABLE PCHOLD FORMAT &FORMAT ON TABLE NOTOTAL ON TABLE SET CACHELINES 100 ON TABLE SET STYLE * TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ ENDSTYLE END -RUN Here are my parameter prompting settings in the Admin console: The setting for the parameters is the same in my other environments (test and prod) but those are both 9.1.1 right now. Is there some different way to get these parameters to show up in the new version? Edited November 20 by Erin Trotter
Solution David Beagan Posted November 20 Solution Posted November 20 I think &FORMAT is a system variable. Try using &WFFMT instead. 1
Erin Trotter Posted November 21 Author Posted November 21 @David Beagan wow! I guess this must be a recent change. The crazy thing is that if you DO pass something using an HTML page, it will accept it and use it, but it just will never prompt. This fixed my issue. Thank you!
David Beagan Posted November 21 Posted November 21 Yea, I see that the Creating Reports manual shows examples using &FORMAT. They should use some other name.
Erin Trotter Posted November 21 Author Posted November 21 Yes and I have been using &FORMAT for years without issue. At least I know which reports to look out for now when I eventually upgrade the other environments. 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now