Focal Point
[SOLVED] Output format in WebFOCUS infoassist report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2467073276

August 26, 2014, 10:21 AM
Neelima
[SOLVED] Output format in WebFOCUS infoassist report
Hi all,

is there any way to put output format parameter in infoassist report. Same we can do in dev report with folowing command

ON TABLE PCHOLD FORMAT &WFFMT.(,,,,,,,,,).Select type of display output.

but, I am not able to perform in infoassist.

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


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
August 26, 2014, 02:05 PM
Tom Flynn
Right-click on the fex and select properties.
Make sure Prompt for Parameters is checked..
IBIMR_prompting has to be set to XMLRUN on the Admin Console...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
August 26, 2014, 05:04 PM
Neelima
its shwoing following exception

User Selection in this request is not allow with your configuration.


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
August 27, 2014, 05:19 AM
Neelima
Hi Tom,

thanks for replying...

Is it possible in Infoassist, to select output format for displaying the result


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
August 27, 2014, 08:29 AM
Shakila Subhan
Hi,

Open in texteditor and specify the output formats mentioned below:

-DEFAULT &COUNTRY='ENGLAND'
-DEFAULT &CAR='JAGUAR'
-DEFAULT &WFFMT='HTML'
TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
WHERE ( CAR.ORIGIN.COUNTRY EQ '&COUNTRY.(FIND CAR.ORIGIN.COUNTRY IN CAR).COUNTRY:.' )
AND ( CAR.COMP.CAR EQ '&CAR.(FIND CAR.COMP.CAR IN CAR).CAR:.' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(,,,,,,,,,,).Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
-RUN


WebFOCUS 8.0.08 - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
Windows, All Outputs
August 27, 2014, 08:40 AM
Neelima
Hi Shakila,

Thanks for the code. I have the done the same in InfoAssist Editor. its work for that time only. if open same infoassist report again in infoAssist its throw error:

User Selection in this request is not allowed with your configuration. Your report will we converted to..


Thanks


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
August 27, 2014, 12:09 PM
Shakila Subhan
Hi Neelima,

I am able to open without any error. we are using App Studio 8.0.0.8 version. Could you please check in admin console as per Tom comments.


WebFOCUS 8.0.08 - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
Windows, All Outputs
August 28, 2014, 05:45 AM
Neelima
quote:
Make sure Prompt for Parameters is checked..

Hi Shakila,

i have done the steps for infoAssist as per Tom's Guidences. still i m facing same issue.
One point in my case, i am using WF8.0.0.5. May be it is limitations for WebFOCUS 8.0.0.5.

Thanks,
Neelima


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
August 28, 2014, 05:50 AM
Neelima
quote:
Console

Thanks a lot Shakila and Tom,

I have found the solution for same.

Thank you so much


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies
June 18, 2015, 10:51 AM
BM
Hi Neelima,
Could you please share how you fixed the issue?

Thanks


WebFOCUS 8202M
June 22, 2015, 06:11 AM
Neelima
Hi,

Please go to configuration setting in Administration console and "select the User Selection check box" in following InfoAssist Setting.


Regards,
Neelima Gupta


WebFocus 8104,8204
Excel/PDF/HTML/HTMLTABLE/XML/ALPHA/GIF file/GRAPH/Active technologies