java - Generate a report with multiple tables -
i'm new jasperserver , ireport, i've been managing. did reach block today , here problem: i'm trying display multiple tables (maybe 50+) each table can have same data in first column. row column entire different row row. mean following:
value1 x1 y1 z1 value1 x2 y2 z2 value1 x3 y3 z3 value2 x1 y1 z1 value2 x2 y2 z2 value2 x3 y3 z3
this can have first column similar same value. i'm trying change each first column has own table so:
value1 table ------------ x1 y1 z1 x2 y2 z2 x3 y3 z3 value2 table ------------ x1 y1 z1 x2 y2 z2 x3 y3 z3
edit
to expand on original question, data i'm retrieving via sql stored in 1 table. i'm trying break table simple formatting. i've linked picture ease understanding.
is possible in ireport?
it's bit hard understand want, i'm going guess...
select * table1 union select * table2;
union all
differs union
in all rows returned in order selected.
comparison, union
sorts rows , discards duplicates.
Comments
Post a Comment