Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Map in a Compound Report
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Map in a Compound Report
 Login/Join
 
Platinum Member
posted
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,


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Shingles

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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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...


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I did create a compound report using dhtml as the output and referencing the map chart.

Document and compound report are synonymous


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I did not know that.

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

Thank you...


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
In App Studio I created a chart and chose the map chart type. When it is saved the extension is .fex


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Would you mind posting the fex code so that I could use it as a reference?


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Shingles

Post the htm file contents please.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Ok... here it is...

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

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


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1666 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Alright... well thanks anyhow. I appreciate the time you put into this topic.

Thanks!

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


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 165 | Registered: May 19, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Map in a Compound Report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.