>dear hilmar
>thank you for my qestion
>I'couln't recivied an example about my qaestion. I2m waiting for it. I'll be very Happy if you send an example code assoon as posible to the adres below.
>(note report is include marked with lines ruled)
Mehmet,
First of all, to explain why I didn't respond immediately: Obviously, I am not connected 24 hours. Usually I access the Universal Thread in the mornings, Bolivian time (11:00 - 16:00 UTC).
There is no need to send additional requests to my e-mail - which I also access from my work, and during the same hours!
In a previous message, you wrote:
>dear hilmar
>table 1 has field1,field2,fiedl3
>table 2 has field4,field5
>table 3 has field6,7,8,9,10
>table 4 has fiel11,12,13,14
>table 5 has field15,16
>thank you
I will assume that all fields are character(5); adjust the sample code accordingly.
The sample code for the union of the first two tables would be something like this:
select "1" as origin, field1, field2, field3, space(5) as field4,;
space(5) as field5;
from Table1;
union select "2" as origin, space(5) as field1, space(5) as field2,;
space(5) as field3, field4, field5;
from Table2;
into cursor TmpResult
Additional comments:
As you can see in the example, you must fill in empty fields.
All parts of the union must match. If fields don't match, you will get an error message about "not union compatible", or something similar.
The extension of the above concepts to five tables shouldn't cause you conceptual troubles, but it does require more work, because of the many fields involved.
In the detail band of your report, create five rows of objects - one for each part. For each object in the first row, print conditionally on origin = "1".
Feel free to ask if you need further help - through the Universal Thread, please.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)