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,

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

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

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,