Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Where is it possible to rename that file name so it isnt 5 ...


Douglas Lee 2

Recommended Posts

You need to compute the date field and then put it in the heading. MIN and MAX arent necessary. The sort order determines what goes into the heading. If its BY HIGHEST then you get the MAX otherwise you get the MIN date. See below:

ENGINE INT CACHE SET ON

SET PAGE-NUM=NOLEAD

SET SQUEEZE=ON

-DEFAULTH &WF_HTMLENCODE=ON;

SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON

-DEFAULTH &WF_EMPTYREPORT=ON;

SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_ARVERSION=1;

SET ARVERSION=&WF_ARVERSION

-DEFAULTH &WF_SUMMARY=Summary;

-DEFAULTH &WF_TITLE=WebFOCUS Report;

TABLE FILE retail_samples/wf_retail

SUM WF_RETAIL.WF_RETAIL_SALES.REVENUE_US

COMPUTE COMP_DATE/YYMD=WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE ; NOPRINT

BY HIGHEST WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE

ON TABLE SUBHEAD

COMP_DATE: <COMP_DATE

ON TABLE PCHOLD FORMAT HTML

ON TABLE NOTOTAL

ON TABLE SET CACHELINES 100

ON TABLE SET GRWIDTH 1

ON 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, $

TYPE=TABHEADING, LINE=1, JUSTIFY=LEFT, $

TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=14, STYLE=BOLD, $

TYPE=TABHEADING, LINE=1, ITEM=1, OBJECT=FIELD, SIZE=14, STYLE=BOLD, $

TYPE=TABHEADING, LINE=2, JUSTIFY=LEFT, $

TYPE=TABHEADING, LINE=2, ITEM=1, OBJECT=TEXT, SIZE=14, STYLE=BOLD, $

TYPE=TABHEADING, LINE=2, ITEM=1, OBJECT=FIELD, SIZE=14, STYLE=BOLD, $

TYPE=TABHEADING, LINE=2, ITEM=2, OBJECT=TEXT, SIZE=14, STYLE=BOLD, $

ENDSTYLE

END

-RUN

Link to comment
Share on other sites

Thanks, But Not close enough as thats for a single date

What I need to show in the heading is the MIN and MAX dates of a Date Range. Ex: Date Range (From-To = Sep 1 2020 to Sep 30 2020) I want the report heading to be:

This is a Great Report for whatever you want

This report contains data from Sep 1 2020 to Sep 30 2020

The actual format of the date can vary but needs to be User Friendly, not something like yyyymmdd.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...