mrc logo mrc logo
  • Explore m-Power Explore m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    What does m-Power build?
    Overview Data Exploration Reporting Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow
  • Services Services
    Overview Training Project Consulting Staff Consulting Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Resources Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Graphs
  • Hyperlinking within a Graph
Back to Manual

Linking within Graphed Images

 

The ability to provide hyperlinks within graphs too often goes unnoticed. To see a working example, see our Crazy Bikes demo site (Sales By Year — Business Intelligence). As you can see by following the hyperlink, we have a Ship Year, Units Shipped, $ Revenue, and $ Profit field. I compiled the application, sequencing the Ship Year field with subtotals, using the Report with Graph template.

As you can see, we have a few things to do within m-Painter.

    1. The first thing that needs to be modified is that the Year field is being subtotaled/totaled on my report. m-Power does this automatically because Ship Year is numeric. I need to delete my subtotal and grand total Ship Year.

Click inside the Subtotal level within the Ship Year column. Next, click the "Insert Date Field" icon from the m-Painter toolbar. Select the Ship Year from the Last row of Detail. Click "OK".

    1. On Crazy Bikes, we are not graphing the Grand Total; rather, we are graphing the subtotal. To make our example do this, we need to make one simple modification. Right-click on the graph and select "Graph Properties". In the "Graph Properties" window, select the "Levels" tab and then choose the radio button next to the "Subtotal" level. Click "OK".
    2. The final step of this process is to activate the ability to link and to specify the proper URL. Right-click on the graph and select "Graph Properties". Navigate to the "Options" tab and then select the "Drilldown" button. Within this view, you can activate graph linking and modify it appropriately. In the example below, graph smartlinking is active, and it will link to retrieval 10. It will also pass "CUSNO" to the retrieval. More information about parameter passing can be found here.

  1. Click "Save" and run your application.

In the Crazy Bikes example from above, at run-time you will see this screen:

By clicking on one of the graphed bars (2009, Bicycles), I am redirected to this page:

Created: September 26, 2008 | Modified: June 12, 2017

Search


Browse By Category

Starting with m-Power (8)
Build Process (13)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
m-Power Data Explorer (4)
Graphs (8)
General (24)
Calculations (5)
m-Power Administration (23)
Utilities (9)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Parameters Form Validation Security External Objects Data Dictionary Java App Properties Dates Reports Application Properties Video Report Database Prompt Screens Admin Administration Performance Compiling Freemarker Graphing RPG Retrieval Build Process Dropdowns Graphs Graph Properties Calculations Bootstrap Templates Maintainers Bar Graphs Summaries Email DB2 Popular Advanced Retrievals SQL Getting Started Excel Tomcat Maintainer m-Painter mrc-Productivity Series Production Record Selections

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2018 mrc. All rights reserved.
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566