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

June 08, 2013, 06:50 AM

info4pals

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>,

June 10, 2013, 01:46 AM

Dave

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

June 10, 2013, 10:31 AM

susannah

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

June 11, 2013, 08:42 AM

Ram Prasad E

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,