Hi,
I want know if is possible create a report, with this caracteristics.
Page 1:
Header:
Nome of Company Invoice no 1
Original
Detail:
line 1
line 2
line 3
Page 2:
Header:
Nome of Company Invoice no 1
Copy
Detail:
line 1
line 2
line 3
.
.
.
Many pages of parameter in my code in Visual Studio.
Tanks,
Camsoft77
what about with two table controls that are identical except the "Original"/"Copy" difference?|||urbancenturion,
My question is how i can create two pages or more, with same information but change for example 1 parameter.
I need build a report to create Invoice. with 3 copies of invoice.
Att,
Camsoft77
|||>>I need build a report to create Invoice. with 3 copies of invoice.
The best way to do this is with a cartesian join added to your "real" query.
For example, the following will create three rows for each real table row, with an extra column called "invoice_info", properly ordered so the "original" shows up first, in case that is important to you <s>:
Code Snippet
select sales_no, invoice_info from orderheader join
(select 'ORIGINAL' as invoice_info, 1 AS invoice_order
union
select 'COPY1',2
union
select 'COPY2',3
) xx
on 1 = 1
order by sales_no, invoice_order
.. now put a group on your invoice # (or sales_no, in my example) or whatever you want in your report...
HTH,
>L<
