[SOLVED] User Defined Output Types and Reporting Objects

November 13, 2019, 12:12 PM

Everyone,

I need to create multiple output types for a reporting object in order for them to be exported, printed, or viewed depending on a user selection. I have a filter panel, and I can see the format type show up in the filter panel, but I'm unsure as to what else needs to be done.

Here is some of my previous code using some of IBI's sample data from GGSTORES. I used this code for reports linked to HTML pages. Is the principle the same when using reporting objects and filter panels? Based upon the skimming of several 8.2.04 manuals I've done this morning, I'm not sure anymore.

 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_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ibisamp/ggstores
BY GGSTORES.STORES01.STORE_CODE
BY GGSTORES.STORES01.STORE_NAME
BY GGSTORES.STORES01.ADDRESS1
BY GGSTORES.STORES01.ADDRESS2
BY GGSTORES.STORES01.CITY
BY GGSTORES.STORES01.STATE
BY GGSTORES.STORES01.ZIP
ON TABLE PCHOLD FORMAT &FMT.(<HTML Web Document (HTML),HTML>,<Excel XLSX (XLSX),XLSX>).Output type.
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, $
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,

November 13, 2019, 01:06 PM

FP Mod Chuck

Julie

I don't think you can accomplish this inside the reporting object, you want the ON TABLE PCHOLD to be parameterized and filters and where statements use Fields. I even went as far as trying to have the Report inside the reporting object parameterize the output format but that is not available in a Reporting Object.

November 13, 2019, 02:17 PM

JulieA

Could I create a DM statement and then have two different reports in the reporting object based on user selection? Or, are you saying, it's just not possible?

November 13, 2019, 03:01 PM

FP Mod Chuck

Well I learn something new everyday.. In the reporting object I edited the report object in text and added
<code>
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML Web document_[HTML),HTML>,<Excel XLSX [XLSX),XLSX>

.Output type.
</code>

I changed your example to &WFFMT as that is a known parameter. Then in the Administration console under InfoAssist properties I checked the ones I wanted in your case html and excel and user selection. Then I created a report with the reporting object and the choice to choose my output option was displayed

November 13, 2019, 03:08 PM

JulieA

Thank you, Chuck. I'll try it right now. I was just about ready to try a different approach. So, your response was timely.

November 13, 2019, 03:29 PM

JulieA

Chuck,

I changed my AdminConsole setting as you mentioned in your solution. I created my reporting object.

Then, I created the filter panel in AppStudio. Finally, I connected the filter panel and the reporting object in the portal designer. Is there something else I need to do to enable the Excel functionality in the portal? Nothing happened for me when I selected the Excel choice. The HTML is fine, and I see the option in my control. I should mention I changed the control type from a radio button to a dropdown list. I don't know if that affects anything. It did not previously in my reports.

What am I missing?

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

November 13, 2019, 04:02 PM

FP Mod Chuck

Julie

I am not sure what went wrong, it will take me a little time to reproduce how you have tried this. It sounds like it should work.

November 13, 2019, 04:21 PM

FP Mod Chuck

I am having trouble figuring out how you did what you did.. Can you go back and just try to create a report using InfoAssist against the reporting object with the ON TABLE PCHOLD syntax in it and see if choosing Excel works. It does for me. I am on version 8.2.06 which could be the difference...

November 13, 2019, 04:22 PM

JulieA

Chuck,

That would be great. I created the filter panel according to the BI portal manual, pages 273-279.

I am trying to get this resolved in time for a meeting on Monday.

November 13, 2019, 04:29 PM

JulieA

Chuck:

I agree with your assessment of the reporting object and how it behaves relative to Excel. It seems to work just fine for me, too.

It's when I try to merge the filter panel and the reporting object together that Excel stops working for me. I'm going to try again in a brand new portal, just to make sure there is no issue on my end.

November 13, 2019, 04:55 PM

FP Mod Chuck

OK. I will get that manual and try it as well but won't have an update for you until tomorrow.

November 13, 2019, 05:01 PM

JulieA

Theoretically, I think it should work for me. I'd appreciate the assistance. Thank you.

November 14, 2019, 08:40 AM

JulieA

After I posted yesterday, I tried one more time. I was able to get things working relative to user selection and two different output types.

Again, use the manual as described in my last post. It should work for you. The key you provided me with was the setting in AdminConsole.

Thank you.

November 14, 2019, 11:08 AM

FP Mod Chuck

Julie

Glad to hear you have it working.