Start New page when the Page fill

moqbel

Dear friend

i desig report to compine three table together, Each table contain multy colomn (more than 10) but not all the colomn have data

so i check the colomn data and set it is Top propery

but the proplem when the page is full , how i can open new page ???

I send the example

http://www.arabteam2000-forum.com/index.ph...st&id=58938

gordk

first i don't see any columns.
i see mulutiple text fields arranged vertically on masterdata bands on page 1 and the same for the sub reports.
basic problems i think i see so far. location/position on design page of subreport objects,
use of the same dataset for 2 masterbands.
could you please give a description of how you think this report should output.
and what the dataset linking is.
masterdata1 .dataset is clinic is it returning multiple records for one lab or 1 rec for one patient etc.

you should not have to adjust the top position of any objects at run time.

gordk

after looking into your design
i would definitely redesign.
first a design page does not have to be the size of the output page.
go to mnu>file>pagesettings largeheight in design mode. gives lots of room to work.
for a sample look at your lay out for subrep1 and all the code you have to write trying to position all the memos and their visibility due to the fact that when a field is empty you don't want the horizontal line of memos to display.
here is what i would do.
make a 0 height mdband it is only used to acsess dataset
add a childband set the masterbands childprop to child1

place the first horizontal set of 3 memos in child1
add the next childband child2 and place the next set of memos in child2
set child1 child prop to child2 and it's printchildifinvisible prop to true
repeat these steps until you have all the memo sets added.
now you can replace all your likes of code.
this
if <FrxClinical."Glucose6-8"> = '' then
begin
memo20.visible := false;
memo200.visible := false;
memo2000.visible := false;
end
else
begin
memo20.top := _top;
memo200.top := _top;
memo2000.top := _top;
_top := _top + 25;
end;
will become
if <FrxClinical."Glucose6-8"> = '' then child1.visible := false else child1.visible := true;
when a child is not visible the next child is printed in its location.
instead of writing this code in the begin end block of the code page it could be in the obp event of the masterdataband.
and you may possibly be able to forget the subreport and do this on the first designpage.
i would do the same type of thing with your other subreports
and would also move those subreport objects into detaildatabands with a rowcount prop of 1, and no dataset prop. on the first design page
then the report engine will produce pages as necessary.
this is the way i see it currently unless you can give me more info.

gordk

My previous reply was just a concept.
we have a basic lab report so i need some answers to the questions below.
parameters for report generation.
will this report be printed on an individual basis by selecting the individual patient and running the report, or will it be a bulk printing of all of the tests for all patients on a particular day?
this tells us, if we want a multi design page report where we run the report a certain no of times or a
single design page using subreports.
It will also provide us with info on how to connect the query datasets.
master/detail relation ships.
Can't tell this right now as you only have a number of individual queries with no masterfield relations.
and only one record in each of the tables being queried. however it is obvious the Masterid field in each query would be the obvious link.
So the answer to above question is very important.

the report has 3 basic "sections or areas" Clinical, Hematology, Microbiology.
Do you want each of these "areas", to output as separate pages or start printing as soon as there is freespace available on the first out put page?
Also, if any of these areas due to number of records or fields will result in more output pages being formed do you want area headers to repeat on the new output page?

Next, will all the fields of any area be displayed or only those with data?

gordk

send me your email address and i will send you a reworked report layout.

moqbel

Dear friend

The report will be for One Paient for each time

I have Relation ship Between Tables
Info is the master table and other table is details (Id field)

I want to start printing as soon as there is freespace available on the first out put page?

Yes I want area headers to repeat on the new output page

will all the fields of any area be displayed or only those with data, I dont what you mean

my e-mail is : moq_ham@hotmail.com

Thanks

gordk

will send it to day.