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] Integrate a Report into another
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Integrate a Report into another
 Login/Join
 
Member
posted
Hi There

I got the issue that I am not able to directly join the required data into the report.

However the output of the second report is based on a field on the first report. The output of the second report shall be line by line aligned to the first.

In the first report I got articles, orders, with multiple positions per order (summing per same article). The second report has to show the number of articles on stock (resp. different stocks), so I am not able to just join on the article, as it would sum up like the other positions on the order. In a addition I am not able to show the different stock places.

So Report 1:

BY:

Order|Article

SUM:

Number|Amount

Report 2

BY:

Article

ACROSS:

Stock

SUM:

Number

Merged it would just skip the article from the 2nd report and add all the columns with the values to the "end" (right hand side) to the report 1, on the respective row (joined over the article).


Kind of tricky to explain, and I really don't know how I could to this properly in Infoassist..another option, for exporting to excel, to create a empty column with an Excel-Formula (how to do this?) with then looks up the information in the Excel (from the second report/tab). But this either I don't know if possible...

many thanks for your help.
regards

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


Webfocus 8.1
Windows 7
HTML, Excel, PDF
 
Posts: 10 | Registered: November 09, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You are going to have to HOLD the data (probably for both reports but definitely for Report 2) and then JOIN them

Here is an example for the GGSALES table

TABLE FILE GGSALES
SUM 
     GGSALES.SALES01.UNITS
     GGSALES.SALES01.DOLLARS
BY  GGSALES.SALES01.CATEGORY
BY  GGSALES.SALES01.PRODUCT
ON TABLE NOTOTAL
ON TABLE HOLD AS RPT1 FORMAT FOCUS 
END
-RUN

TABLE FILE GGSALES
SUM 
     GGSALES.SALES01.UNITS
BY  LOWEST GGSALES.SALES01.PRODUCT
ACROSS LOWEST GGSALES.SALES01.REGION AS ''
ON TABLE NOTOTAL
ON TABLE HOLD AS RPT2 FORMAT FOCUS INDEX PRODUCT
END
-RUN

JOIN
RPT1.SEG01.PRODUCT IN RPT1 TO MULTIPLE RPT2.SEG01.PRODUCT IN RPT2
TAG J0 AS J0
END
TABLE FILE RPT1
SUM 
     RPT1.SEG01.UNITS
     RPT1.SEG01.DOLLARS
     SEG.J0.SEG01.PRODUCT
-*     J0.SEG01.UNIMidwest
-*     J0.SEG01.UNINortheast
-*     J0.SEG01.UNISoutheast
-*     J0.SEG01.UNIWest
BY  RPT1.SEG01.CATEGORY
BY  RPT1.SEG01.PRODUCT
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END
-RUN  


If you have an indeterminate number of Stock items then you can replace the individual across columns with SEG. to print all fields in a SEGMENT (not sure if you can do that is InfoAssist

Cheers

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 241 | Location: Melbourne, Australia | Registered: February 07, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Hi Stu

Thank you for your reply, I am a Infoassist-User only. It would be brilliant to know how to make this work there, in the GUI.

regards


Webfocus 8.1
Windows 7
HTML, Excel, PDF
 
Posts: 10 | Registered: November 09, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
Hi ValEit,

You should be able to accomplish the previous example within InfoAssist GUI reporting tool.

In InfoAssist you can HOLD data as a FOCUS file (or other file format) and then JOIN the files together for reporting.

Here is a link to the InfoAssist Manual in Technical Content Library

- select your version of WebFOCUS
- click the"+" to open InfoAssist and the various topics.

I hope this helps you out.

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada  - http://www.informationbuilders.com/events/summit

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


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Integrate a Report into another

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