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:
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.
regardsThis message has been edited. Last edited by: Tamra,
HTML, Excel, PDF
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
WebFOCUS 8.2.03 (8.2.06 in testing)
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.
HTML, Excel, PDF
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.
Focal Point Moderator
Information Builders Inc.
* Summit 2016 – June 13-17 in Reno, Nevada - http://www.informationbuilders.com/events/summitThis message has been edited. Last edited by: Tamra,
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
|Powered by Social Strata|