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

[NYCBabak .]

Not sure if you can choose a name for a PCHOLD FORMAT XLSX from InfoAssist. However, you can Edit With Text Editor and add AS filename to the syntax and InfoAssist will respect that.

[Douglas Lee 2]

Sounds like a NFR to me Advanced Users do not have TEXT Edit privileges.

So, IA Needs enhancements ~ imho

[NYCBabak .]

I doubt there will be any new features in InfoAssist since the Designer is where IBs efforts are focused. But it doesnt hurt to ask for it. Maybe itll be added to the Designer.

[Douglas Lee 2]

Thanks again, Theres a few other things that weve found that just dont work. Such as using <MIN.DateField and <MAX.DateField on a report thats sorted by DateField, in the report heading.

Ill provide the code from GGsales later unless someone else wants to try it to prove me wrong

[Douglas Lee 2]

How about Accordion from within IA

[NYCBabak .]

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

[Douglas Lee 2]

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.

[Douglas Lee 2]

Where is it possible to rename that file name so it isnt 5 random characters Example that last report file name is zqykl.xlsx.

[NYCBabak .]

Sounds like a multverb request which isnt available in IA.