Focal Point
[CLOSED] Composer Display Issues

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8407081326

August 14, 2012, 03:21 PM
Kevin Patterson
[CLOSED] Composer Display Issues
I'm trying to display two reports side by side in one composer fex. The reports are basically copies of each other except in one of them I subtract 1 from the year parameter. I'm including them in the composer fex by just using an include statement.

When the report on the left hand side (i.e. the fex that was included first) does not return any rows the report on the right doesn't display correctly. It will display a report total, but not the details.

Are there any ideas on how to fix this or is there a better way to show two reports side by side?

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


Kevin Patterson
Appalachian State University
WebFOCUS 7.7.03
Windows, All Outputs
August 16, 2012, 03:32 PM
Doug
There's always another way, and sometimes even a better way. I'd lok into using the date (YEAR and YEAR-1) as a parameter (&RPTYEAR) and -REPEAT thru it twice with an "ON TABLE HOLD AS REPORT&RPTYEAR FORMAT HTMTABLE and use those reports in a -HTMLFORM block using ...etc...




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
August 16, 2012, 04:35 PM
Doug
Here's Freebie For You...
SET PAGE = OFF
DEFINE FILE EMPLOYEE
HIRE_YEAR/A2=EDIT(EDIT(HIRE_DATE),'99') ;
END
-REPEAT ReportLoop FOR &LoopNumber FROM 1 TO 2 ;
-SET &ReportNumber = 80 + &LoopNumber ;
-TYPE *** REPORT &ReportNumber
TABLE FILE EMPLOYEE
HEADING
"REPORT &LoopNumber : HIRE_YEAR: 19<+0><HIRE_YEAR"
SUM SALARY
BY LAST_NAME 
BY FIRST_NAME
WHERE HIRE_YEAR EQ '&ReportNumber.EVAL'
ON TABLE HOLD AS REPORT&ReportNumber FORMAT HTMTABLE
END
-ReportLoop
-HTMLFORM BEGIN
<TABLE><TR><TD VALIGN=TOP>!IBI.FIL.REPORT81;</TD><TD VALIGN=TOP>!IBI.FIL.REPORT82;</TD></TR></TABLE>
-HTMLFORM END
-EXIT
Cool
August 31, 2012, 12:57 PM
Kevin Patterson
Very cool stuff! Sorry again for the slow reply (email filtering got a little out of hand). I'll give these a try just to learn the technique.

I ended up building an html page and just populating two frames. But it will be good to learn these ways as well.

Thanks so much for the help!


Kevin Patterson
Appalachian State University
WebFOCUS 7.7.03
Windows, All Outputs