Date parameter not working in designer WF 8.2.07.28

[Erin Trotter]

I have created a report in a designer page and want to add filters to the top bar. The date filter displays (no values)... even though there are plenty of values in the report.

I also tried to assembe visuals with a report I already created that is exactly the same as the one I created in designer and when I do, the date parameter will not give me a calendar control, it only will give me a drop-down. Not sure how to get around this. I've recreated these reports a bunch of times and still get the same result.

SET KEEPDEFINES=ON  -*COMPONENT=Define_fin_fact_vendor_payments_deptDEFINE FILE financials/fin_fact_vendor_payments_dept COUNTER/D12=COUNTER + 1 ; CaseNumber/A10V=' ' ;ENDENGINE INT CACHE SET ONSET PAGE-NUM=NOLEADSET SQUEEZE=ON-DEFAULTH &WF_HTMLENCODE=ON;SET HTMLENCODE=&WF_HTMLENCODE SET HTMLCSS=ON-DEFAULTH &WF_EMPTYREPORT=ON;SET EMPTYREPORT=&WF_EMPTYREPORT -DEFAULTH &WF_ARVERSION=2;SET ARVERSION=&WF_ARVERSION -DEFAULTH &WF_SUMMARY='Summary';-DEFAULTH &WF_TITLE='WebFOCUS Report';TABLE FILE financials/fin_fact_vendor_payments_deptSUM FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.SUPPLIER_ID AS 'Supplier ID'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.NAME AS 'Supplier Name'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.VOUCHER_ID AS 'Voucher'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.INVOICE_ID AS 'Invoice Number'CaseNumber AS 'Case,Number'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PO_ID AS 'PO No.'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.INVOICE_DT AS 'Invoice Date'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.MERCHANDISE_AMT AS 'Sum,Merchandise,Amt'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.BANK_ACCT_KEY AS 'Check,ID'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PYMNT_ID_REF AS 'Check No'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PYMNT_STATUS AS 'Check Status'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PYMNT_DT AS 'Check Date'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PAID_AMT AS 'Amount'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.DEPTID AS 'Dept'FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.ORIGIN AS 'Origin'BY COUNTER AS 'Row'BY FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.SUPPLIER_ID NOPRINTWHERE FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.SUPPLIERIDNAME EQ &SUPPLIERIDNAME.(OR(FIND FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.SUPPLIERIDNAME IN FINANCIALS/FIN_FACT_VENDOR_PAYMENTS_DEPT |FORMAT=A55V,SORT=ASCENDING)).SUPPLIERIDNAME:.;WHERE FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.SUPPLIER_ID EQ &SUPPLIER_ID.(OR(FIND FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.SUPPLIER_ID IN FINANCIALS/FIN_FACT_VENDOR_PAYMENTS_DEPT |FORMAT=A10V,SORT=ASCENDING)).SUPPLIER_ID:.;WHERE FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PO_ID EQ &PO_ID.(OR(FIND FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.PO_ID IN FINANCIALS/FIN_FACT_VENDOR_PAYMENTS_DEPT |FORMAT=A10V,SORT=ASCENDING)).PO Number:.;WHERE FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.DEPTID EQ &DEPTID.(OR(FIND FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.DEPTID IN FINANCIALS/FIN_FACT_VENDOR_PAYMENTS_DEPT |FORMAT=A10V,SORT=ASCENDING)).Department:.;WHERE FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.INVOICEDATE GE &INVOICEDATE1.(FIND FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.INVOICEDATE IN FINANCIALS/FIN_FACT_VENDOR_PAYMENTS_DEPT |FORMAT=MDYY,SORT=ASCENDING).INVOICEDATE:.QUOTEDSTRINGANDFIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.INVOICEDATE LE &INVOICEDATE2.(FIND FIN_FACT_VENDOR_PAYMENTS_DEPT.FIN_FACT_VENDOR_PAYMENTS_DEPT.INVOICEDATE IN FINANCIALS/FIN_FACT_VENDOR_PAYMENTS_DEPT |FORMAT=MDYY,SORT=ASCENDING).INVOICEDATE:.QUOTEDSTRING;ON TABLE PCHOLD FORMAT AHTMLON TABLE NOTOTALON TABLE SET CACHELINES 100ON TABLE SET GRWIDTH 1ON TABLE SET AUTOFIT OFFON TABLE SET KEEPDEFINES ONON TABLE SET STYLE *INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, ALLOW-ACCORDION=OFF, ALLOW-CALC=OFF, ALLOW-CHART=OFF, ALLOW-COMMENTS=OFF, ALLOW-EXPORT=ON, ALLOW-FILTER=ON, ALLOW-FREEZE=ON, ALLOW-GRID=OFF, ALLOW-HIDE=ON, ALLOW-PAGINATION=ON, ALLOW-PIVOT=OFF, ALLOW-PRINT=ON, ALLOW-RESTORE=ON, ALLOW-ROLLUP=OFF, ALLOW-SAVECHANGE=OFF, ALLOW-SENDEMAIL=ON, ALLOW-SORT=ON, ALLOW-TOOLS=OFF, ALLOW-VISUALIZE=OFF, ALLOW-WINDOW=OFF, ARGRAPHENGINE=JSCHART, $TYPE=DATA, COLUMN=N4, JUSTIFY=CENTER, $TYPE=TITLE, COLUMN=N7, JUSTIFY=CENTER, $TYPE=TITLE, COLUMN=N10, JUSTIFY=CENTER, $ENDSTYLEEND -RUN

[David Beagan]

How did you verify that there are plenty of date values in the report (from the financials/fin_fact_vendor_payments_dept data source)?

[David Beagan]

In order to get the calendar control, when you create the report in InfoAssist, make the Parameter for IINVOICEDATE a Sinple one. You don't want Static or Dynamic.

[Erin Trotter]

I have access to the source database and can see the values there and I created a regular report with Infoassist that allowed me to see dates

[Erin Trotter]

I will try this