Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Set Default Calendar date
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Set Default Calendar date
 Login/Join
 
Platinum Member
posted
Is it possible to set previous day as the default for that calendar function on the HTML form. CODE below

 ENGINE SQLMSS SET DEFAULT_CONNECTION IVB
SQL SQLMSS
EX dbo.mPulse18 '&dte'
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END

SET NODATA = ' '

-Web;
DEFINE FILE SQLOUT
-*QDATE/MDYY=QTDATE;
NEWDATE/MDYY=HDATE(QTDATE, 'MDYY');
END


TABLE FILE SQLOUT
PRINT 
 
     EmpID AS 'Employee ID'
     FName AS 'First Name'
     LName AS 'Last Name'
     Division
     Team
     TeamID AS 'Team ID'
     Role
     TotPts AS 'MTD Points'
     TotRnk AS 'MTD Rank'
     COMPUTE Rnk/D6.1% = PctRnk * 100;
 AS 'MTD   %Rank                           '
     TmPts AS 'MTD Team Points'
     COMPUTE TmRnk/D6.1% = TmPctRnk * 100; AS 'Team %Rank'
     RCpH AS 'RevCred per Hour'
     RCpHRnk AS 'RCpH Rank'
     COMPUTE AHTRnk/D6.1% = RCpHPctRnk * 100; AS 'RCpH %Rank'
     RCpHPts AS 'RCpH Points'
     UpH AS 'Units per Hour'
     UpHRnk AS 'UpH Rank'
     COMPUTE UpHRnk/D6.1% = UpHPctRnk * 100; AS 'UpH %Rank'
     UpHPts AS 'UpH Points'
     Prod AS 'Productive Time'
     ProdRnk AS 'Prod Rank'
     COMPUTE PRODRnk/D6.1% = ProdPctRnk * 100; AS 'Prod %Rank'
     ProdPts AS 'Prod Points'
     CIQ
     CIQRnk AS 'CIQ Rank'
     COMPUTE CIQRnk/D6.1% = CIQPctRnk * 100; AS 'CIQ %Rank'
     CIQPts AS 'CIQ Points'
     Qual AS 'Quality Monitoring'
     QualRnk AS 'Quality Rank'
     COMPUTE QualRnk/D6.1% = QualPctRnk * 100; AS 'Quality %Rank'
     QualPts AS 'Quality Points'
     M1TotPts AS 'Month1 Points'
     COMPUTE M1Rnk/D6.1% = M1PctRnk * 100; AS 'Month1 %Rank'
     M1TmPts AS 'Month1 Team Points'
     COMPUTE M1TmRnk/D6.1% = M1TmPctRnk * 100; AS 'Month1 Team %Rank'
     M2TotPts AS 'Month2 Points'
     COMPUTE M2Rnk/D6.1% = M2PctRnk * 100; AS 'Month2 %Rank'
     M2TmPts AS 'Month2 Team Points'
     COMPUTE M2TmRnk/D6.1% = M2TmPctRnk * 100; AS 'Month2 Team %Rank'
     M3TotPts AS 'Month3 Points'
     COMPUTE M3Rnk/D6.1% = M3PctRnk * 100; AS 'Month3 %Rank'
     M3TmPts AS 'Month3 Team Points'
     COMPUTE M3TmRnk/D6.1% = M3TmPctRnk * 100; AS 'Month3 Team %Rank'
     QAvgPts AS 'Quarterly Points'
     COMPUTE QRnk/D6.1% = QPctRnk * 100; AS 'Quarterly % Rank'
     QTmPts AS 'Quarterly Team Points'
     COMPUTE QTmRnk/D6.1% = QTmPctRnk * 100; AS 'Quarterly Team %Rank'
HEADING
"Sales IB Core"
"Date:<NEWDATE"
" "
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE * 

This message has been edited. Last edited by: Kerry,


WebFocus 7.7.02 WinXP
 
Posts: 236 | Registered: May 12, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Are you wanting a default date for the amper variable or are you wanting a default date to display in a calendar control? If it's just the variable, just take &YYMD and subtract a day (using the DATECVT function.) If it's for display in a control, there are many examples on the web of Javascript code to handle this.

You mention an HTML form, but there is nothing here to indicate that one has been prepared, so I'm assuming that you're relying on autoprompting. Is that correct? If so, I'll just say that (in my opinion) autoprompting should ONLY be used for the simplest procedures (basically fill in some text or combo boxes.)

If you're wanting to control the display values or have any additional processing that should happen or manipulation of variables, you probably should create your own HTML form where you have complete control over everything, instead of trying to find ways to make autoprompting do what you want and then hoping it works consistently. I know autoprompting can handle a lot of those things, but it's sometimes amazing the lengths that are taken to make it work properly when an HTML page can be laid out just as quickly and allows for much greater control.

(Sorry for the soapbox speech - (especially if you weren't even trying to use autopromting. My misunderstanding, in that case.)


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Set Default Calendar date

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.