ron9999
August 2nd, 2007, 11:47 AM
I create a report with CR9 for a invoice and now I look for a solution of a problem.
The report looks like:
row 1 Db_tttt_tttt_tttt_tttt__tttttttttttttttttttttttttttttt
row 2 Db_______________tttttttttttttttttttttttttttttt
row 3 Db_______________tttt___9999______99999
row 4 Db_______________tttt___9999______99999
row 5 Db_______________tttt___9999______99999__________999999
now it is possible that the content of row 2 or 3 is empty, which of course I don't like to print out. Therefore I like to delete this row and the next one should move upward.
In Form-editor I put: Length (Trim ({rech.kurztext2})) = 0 and in area assistent I checked “ suppress empty area (sorry I hope “suppress empty area” is the name in English, I use CR in German) but it don't work out.
Now I try to put every row in a separate area like
row Db_tttt_tttt_tttt_tttt_tttttttttttttttttttttttttttttt
row Dc_______________tttttttttttttttttttttttttttttt
row Dd_______________tttt___9999______99999
row De_______________tttt___9999______99999
row Df_______________tttt___9999______99999___________999999
now the suppressing of row with empty content works but the next problem is, sometimes the report makes a page break after Dd because he is on the last row of the page.
I thought if I check on row Db how many rows left and the answer is 3 I can force a page break but therefore I have to find out how to figure out how many rows left. For this reason I start a thread but could not get a answer. So may be some can give me a hand with my problem
tia
Ron
The report looks like:
row 1 Db_tttt_tttt_tttt_tttt__tttttttttttttttttttttttttttttt
row 2 Db_______________tttttttttttttttttttttttttttttt
row 3 Db_______________tttt___9999______99999
row 4 Db_______________tttt___9999______99999
row 5 Db_______________tttt___9999______99999__________999999
now it is possible that the content of row 2 or 3 is empty, which of course I don't like to print out. Therefore I like to delete this row and the next one should move upward.
In Form-editor I put: Length (Trim ({rech.kurztext2})) = 0 and in area assistent I checked “ suppress empty area (sorry I hope “suppress empty area” is the name in English, I use CR in German) but it don't work out.
Now I try to put every row in a separate area like
row Db_tttt_tttt_tttt_tttt_tttttttttttttttttttttttttttttt
row Dc_______________tttttttttttttttttttttttttttttt
row Dd_______________tttt___9999______99999
row De_______________tttt___9999______99999
row Df_______________tttt___9999______99999___________999999
now the suppressing of row with empty content works but the next problem is, sometimes the report makes a page break after Dd because he is on the last row of the page.
I thought if I check on row Db how many rows left and the answer is 3 I can force a page break but therefore I have to find out how to figure out how many rows left. For this reason I start a thread but could not get a answer. So may be some can give me a hand with my problem
tia
Ron