[SOLVED] Not able to place 2 different hold files beside each other.

Hi,
I have 2 different hold files having different print and sort fields but was not successful in placing the reports 1 beside the other.I have tried join,more and match files but of no use.It would be helpful if anyone could please help me out.
Below is my code :
TABLE FILE HOLDDP
SUM
DPTCOUNT
BY ID
BY NAME
BY REG
BY SUBR
BY RMD_YR
BY RMD_DT
BY SLS
BY SLD_Q
ACROSS GRP
ACROSS MSC
ON TABLE SET ASNAMES ON
ON TABLE HOLD AS HOLD1
END
-RUN

TABLE FILE HOLDVO
SUM
MSC
BY ID
BY NAME
BY REG
BY SUBR
BY RMD_YR
BY RMD_DT
BY SLS
BY SLD_Q
ACROSS PYR
ACROSS DPTNAME
ON TABLE SET ASNAMES ON
ON TABLE HOLD AS HOLD2
END
-RUN

Any help in getting this resolved is appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,

webfocus 769,windows 7,html

Posts: 24 | Registered: July 16, 2010

Dave

Master

posted

Hide Post

Hi,info4pals...

Remember that ACROSS is ( technically ) the same as BY. What you have is two different sets of data.

What you could do...

DEFINE FILE HOLDDP
  FIRSTACROSS/<fmt> = GRP;
  SECONDACROSS/<fmt> = MSC;
END

DEFINE FILE HOLDVO
  FIRSTACROSS/<fmt> = PYR;
  SECONDACROSS/<fmt> = DPTNAME;
END

That would make it easy to match both HOLDS. But you will have to change the ACROSS to BY when making the HOLD files.

After the match you can use ACROSS for reporting purposes.

Though this will mix the values from HOLD1 and HOLD2. If that's not desirable you could add another field.

DEFINE FILE HOLDDP
   SORTACROSS/I1 = 1;
END
DEFINE FILE HOLDVO
   SORTACROSS/I1 = 2;
END

And use that as the first ACROSS..

I hope this helps...

G'luck,
Dave

_____________________
WF: 8.0.0.9 > going 8.2.0.5

Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010

Ignored post by Dave posted

Show Post

susannah

Expert

posted

Hide Post

You want your output html beside each other, is that right?
if so,

TABLE FILE CAR.... ON TABLE HOLD AS MYTAB1 FORMAT HTML (or HTMTABLE, whichever you want)
END
TABLE FILE CAR...ON TABLE HOLD AS MYTAB2 FORMAT HTML
END
-RUN
-HTMLFORM BEGIN
<HTML>
<TABLE>
<TR...>
<TD align = top>
!IBI.FIL.MYTAB1;
<TD align=top>
!IBI.FIL.MYTAB2;
</TD></TR>
</TABLE>
</HTML>
-HTMLFORM END

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

Ram Prasad E

Master

posted

Hide Post

Hi,
If you want to display output one beside other, then best to go with Susannah's method of using HTMTABLE and HTMFORM. In case if you are looking to merge the data to have a single HOLD file, then add counter field to both tables and then use MATCH.

Hope this helps.

Thanks,
Ram

This message has been edited. Last edited by: Ram Prasad E,

WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/

Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009

Ignored post by Ram Prasad E posted

Show Post

info4pals

Member

posted

Hide Post

Thanks everyone for the reply.Appreciate everyone for the help.

webfocus 769,windows 7,html

Posts: 24 | Registered: July 16, 2010