General information
Category:
Reports & Report designer
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only