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     (Resolved)HTML COMPOSER Calendar
Go
New
Search
Notify
Tools
Reply
  
(Resolved)HTML COMPOSER Calendar
 Login/Join
 
Platinum Member
posted
I have been working with HTML composer and having some success. However I had previuosly written a couple reports with a propt for a dat and used the calendar without issue.. I had some modification requested to the report and made these without issue except that now the calndar is propting me to enter a value where previously it did not. the fex code is below

Unlike the other prompts I cannot find a "Selection required" setting for the calendar in the properties and settings.


I had it working before but now its not I did not want to post the html code as its quite extensive. im sure its something simple like im looking in the wrong place.


E_DATE_1/YYMD='&E_DATE';
B_DATE_1/YYMD='&B_DATE';
END
TABLE FILE AS_ADMISSIONS_APPLICANT
PRINT
&MEASURES.(AND(,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,)).Measures.
BY &SORTA.(BY(,,,,,,,,,,)).Sort1.
BY &SORTB.(BY(,,,,,,,,,,,)).Sort1.
BY &SORTC.(BY(,,,,,,,,,,,)).Sort1.
HEADING
"&TOD"
"&DATE "
"&HEADING1"
"&HEADING2"
"Undergraduate Admissions Profile Report"
"For Term FOOTING
" "
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.TERM_CODE_KEY EQ &TERM_CODE_KEY.(OR(FIND SUBTERM.SEG01.STVTERM_CODE,SUBTERM.SEG01.STVTERM_DESC IN subterm)).TERM_CODE_KEY.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.STYP_CODE EQ &STYP_CODE.(OR(FIND STVSTYP.STVSTYP.STVSTYP_CODE,STVSTYP.STVSTYP.STVSTYP_DESC IN stvstyp)).STYP_CODE.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.ADMT_CODE EQ &ADMT_CODE.(OR(FIND STVADMT.STVADMT.STVADMT_CODE,STVADMT.STVADMT.STVADMT_DESC IN stvadmt)).ADMT_CODE.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.DECEASED_IND EQ MISSING;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.APST_CODE EQ &APST_CODE.(OR(FIND STVAPST.STVAPST.STVAPST_CODE,STVAPST.STVAPST.STVAPST_DESC IN stvapst)).APST_CODE.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.COLL_CODE1 EQ &COLL_CODE1.(OR(FIND STVCOLL.STVCOLL.STVCOLL_CODE,STVCOLL.STVCOLL.STVCOLL_DESC IN stvcoll)).COLL_CODE1.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.MAJR_CODE1 EQ &MAJR_CODE1.(OR(FIND STVMAJR.STVMAJR.STVMAJR_CODE,STVMAJR.STVMAJR.STVMAJR_DESC IN stvmajr)).MAJR_CODE1.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.STATE1 EQ &STATE1.(OR(FIND STVSTAT.STVSTAT.STVSTAT_CODE,STVSTAT.STVSTAT.STVSTAT_DESC IN stvstat)).STATE1.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.APDC_CODE1 EQ &STVAPDC_CODE.(OR(FIND STVAPDC.STVAPDC.STVAPDC_CODE,STVAPDC.STVAPDC.STVAPDC_DESC IN stvapdc)).STVAPDC_CODE.;
WHERE AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.LEVL_CODE NE 'G';
-IF &B_DATE EQ '' GOTO NODATE
WHERE ( AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.APPLICATION_STATUS_DATE GE '&B_DATE' );
-IF &E_DATE EQ '' GOTO NODATE
WHERE ( AS_ADMISSIONS_APPLICANT.AS_ADMISSIONS_APPLICANT.APPLICATION_STATUS_DATE LE '&E_DATE' );
-NODATE

This message has been edited. Last edited by: Geoff Fish,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Geoff,

This looks quite confusing: is this issue resolved or not? If not resolved, can you please update the subject line to remove the RESOLVED tag? It will be more outstanding to others who may be able to help. If resolved, would you please share the final solution with all?

Cheers,

Keryr


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (Resolved)HTML COMPOSER Calendar

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