Information générale
Catégorie:
Gestionnaire de rapports & Rapports
>HI,
>
>
>Ok, this is a 'nasty' one (for me anayway)
>
>I have two (2), may become tree (3) tables, which are not related in any kind to each other.
>
>I want to print them all on the same page
>If they all fit on the page or not, is not a priority.
>
>Have doen same tests, no results, ended in dividing the report over tree pages.
>This works fine, but it look like wasting paper to the client.
>SO.....the client is asking to put it all on one page.
>
>ALL suggestions are very welcome !
>
>Marc
You should try using SQL with UNION for all tables adding a column for identification (id_table) . Then , generate a report having groups by id_table.
for Example:
assuming tables
table1 -> ( field_name_1 c(5) )
table2 -> ( field_name_2 c(10) )
empty_val_1 = space(len(table1.field_name_1))
empty_val_2 = space(len(table2.field_name_2))
select ;
"1" as id_table,;
field_name_1 as field1,;
empty_val_2 as field2 ;
from table1 ;
union ;
(select ;
"2" as id_table,;
empty_val_1 as field1,;
field_name_2 as field2;
from table2);
into cursor c_name
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement