Hi Folks,

Is it possible to have a map appear on a compound report?

I've got a map that shows locations of a few people in our data warehouse. It is used by several dashboards. The map is authored in HTML canvas, so its extension is htm.

On this page it says that compound reports "enables you to concatenate reports with styled formats (such as PDF, DHTML, PS, EXL2K, or EXL07)". Well htm is not mentioned there, so I'm thinking its not possible. So... um... how do I get a map into a compound report?

I've tried searching "compound" and "map", but all I get is stuff about heat maps.

Thank you!

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

Shingles

I created a map and then a document with dhtml and it allowed me to reference my map chart no problem.

Ok, but I need to get this done in a compound report.

One solution would be to save the map as an image and then add the image in the compound report. But I'm not having success there. Still working on it...

I did create a compound report using dhtml as the output and referencing the map chart.

Document and compound report are synonymous

I did not know that.

And how did you create the map? What is the file extension?

Thank you...

In App Studio I created a chart and chose the map chart type. When it is saved the extension is .fex

Would you mind posting the fex code so that I could use it as a reference?

Here you go...

 
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_ARVERSION=1;
SET ARVERSION=&WF_ARVERSION

-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE wfretail82/wf_retail
-* Created by Info Assist for Graph
BY WF_RETAIL.WF_RETAIL_SALES.QUANTITY_SOLD
BY WF_RETAIL.WF_RETAIL_GEOGRAPHY_CUSTOMER.COUNTRY_NAME
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BUBBLEMAP
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
INCLUDE=IBFS:/WFC/Global/Themes/Standard/Default/theme.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, CHART-LOOK=com.esri.map, $
TYPE=DATA, COLUMN=N1, BUCKET=color, $
*GRAPH_SCRIPT

*GRAPH_JS_FINAL
"extensions": {
    "com.esri.map": {
        "overlayLayers":             [
                {
                    "ibiDataLayer": {
                        "map-metadata": {
                            "map_by_field": "WF_RETAIL.WF_RETAIL_GEOGRAPHY_CUSTOMER.COUNTRY_NAME"
                        }
                    }
                }
            ],
        "baseMapInfo": {
            "customBaseMaps":                 [
                    {
                        "ibiBaseLayer": "gray"
                    }
                ]
        }
    }
},
"pieProperties": {
    "holeSize": "0%"
},
"agnosticSettings": {
    "chartTypeFullName": "Bubblemap"
}

*END
ENDSTYLE
END

-RUN

Ya... thanks for the reply, but this approach won't help me, I don't think. That would mean I have to completely redo the map. Too much work was put into it.

Essentially I need to find a way to get the contents of an htm file (a file created in html canvass) into a compound report. And that htm has a map.

Shingles

The htm file is just a driver for displaying that map. The underlying map code should be able to be re-used. If the map code is embedded in the htm file you should be able to cut and paste it into a .fex file and reference it in the document.

Hmmm... I tried to open the htm file in a text editor, but I didn't see anything in there that resembled a fex file.

Shingles

Post the htm file contents please.

Ok... here it is...

EDIT: Removing what was showing here... just a bit of tmi...

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

Shingles

I was expecting to see a reference to a .fex file but it does not exist. I'm sorry but I have no idea how your map code is being generated. Hopefully someone else can debug this issue. If not you should open a case with techsupport

Alright... well thanks anyhow. I appreciate the time you put into this topic.

Thanks!

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