goto section expert (right click on left side of screen where rh,ph,gh,d are listed) and select suppress box then put in what criteria you want to suppress.
On my report I created a group by invoice # then suppressed the group if Inv$=Pay$, so it only shows invoices with balances.
I am trying to connect a windows 2003 server to a progress 9.1D db using a Merant 3.7 Progress ODBC driver.
Should the OID be = to (db server or client)
OID/OIB Options
protocol =tcp
service name =10670 (from the services file test1 10670/tcp)
host name= 172.31.1.1 (ip of the sun server where...
I have 10 records where table1.pk1_id = table2.fk_pk1_id
I only want to select 1 record out of the 10
The 1 record with highest value for table2.pk_id2
table1 table2
pk1_id pk2_id
fk_pk1_id
I left outer join the tables on table1.pk1_id=table2.fk_pk1_id
This is what...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.