fixed report with number of row in report details (1 Viewer)

[hatmak]

hi

I need to make fixed row for report if no data in text report this row show empty

if page 1 shown 15 record only

and data show in report 13 than the 2 row in report empty


as attached example

page 1 of report is continue from 18 record
i need fixed row in report for all page in report to be 18 record
and in page 2 it show 6 records
i need 12 row in this page empty with same formatting table

 

[Cronk]

Can you clarify?

If the report is giving up to 15 records, you want the records to be displayed on page 1 with blank records shown for any record number less than 15 eg 9 records will have 6 blank records following

If the report has more than 15 records, you want page 1 to display 18 records with any page having less than 18, being filled with blank records to make up 18 lines on each page.

 

[hatmak]

Can you clarify?

If the report is giving up to 15 records, you want the records to be displayed on page 1 with blank records shown for any record number less than 15 eg 9 records will have 6 blank records following

If the report has more than 15 records, you want page 1 to display 18 records with any page having less than 18, being filled with blank records to make up 18 lines on each page.

exactly what i want

 

[Gasman]

Can you clarify?

If the report is giving up to 15 records, you want the records to be displayed on page 1 with blank records shown for any record number less than 15 eg 9 records will have 6 blank records following

If the report has more than 15 records, you want page 1 to display 18 records with any page having less than 18, being filled with blank records to make up 18 lines on each page.

Well I am impressed you understood that.

 

[isladogs]

Me too....

 

[hatmak]

any help

 

[CJ_London]

Your description is not at all clear as to the requirement but adjusting the height of the page footer to 8.619cm would appear to do what you want - 15 rows on the first page 18 on the subseqent ones

 

[hatmak]

many thanks cj_london

but i want when i open report

the count of record if page fully data is 18 record ( or any count of row to fill the page )

and when the page details of report have only 2 record ---- i need to fill the page with same format of table designed in report but blank data ( empty )

 

[CJ_London]

So not 15 rows on the first page?

Suggest take a look at this link - I thing it provides what you require

Solved - Adding blank rows to a report

I know that I can use a union query to add blank rows to a report to fill a printed a page. This method works as far as there is no grouping and sorting in query. As soon as I add a group to the report, the blank lines are printed on a separate page. Obviously, because the rows that union query...

www.access-programmers.co.uk

 

[hatmak]

So not 15 rows on the first page?

Suggest take a look at this link - I thing it provides what you require

Solved - Adding blank rows to a report

I know that I can use a union query to add blank rows to a report to fill a printed a page. This method works as far as there is no grouping and sorting in query. As soon as I add a group to the report, the blank lines are printed on a separate page. Obviously, because the rows that union query...

www.access-programmers.co.uk

if data complete in the first page will be 15

the record no. 16 will be in second page

the link is what I need

thanks
regards

 

[hatmak]

I will try to do it

regards

 

[SHANEMAC51]

I need to make fixed row for report if no data in text report this row show empty

if page 1 shown 15 record only

and data show in report 13 than the 2 row in report empty

with the help of me.NextRecord received

 

[CJ_London]

@SHANEMAC51 - if you are going to offer a solution, please be clear what it is you are offering - how does 'help of me.NextRecord received' help the OP? Where are you putting the code? what triggers it?

 

[SHANEMAC51]

@SHANEMAC51 - if you are going to offer a solution, please be clear what it is you are offering - how does 'help of me.NextRecord received' help the OP? Where are you putting the code? what triggers it?

example of the database - code in the report module + a service line is added to the request (it did not work without it)

 

[arnelgp]

on thi report there are 29 lines for a full page.
i added tableZZ (with same structure as your company_code table).
the code on the form will only run on Print Preview view.
view the report in print preview.

 

[hatmak]

you are genius

thanks a lot arnelgp

but why design the same structure in table zz and count of record will effect in data in this table

 

[hatmak]

when I deleted SOME OF RECORDS

the remaining row show numbers as attached

 

[SHANEMAC51]

on thi report there are 29 lines for a full page.

I was interested in the option with several groups of records, for example, in the context of customer groups, and the name field - expandable
almost turned out - only the extra last sheet

 

[SHANEMAC51]

the remaining row show numbers as attached

extra characters in the added lines are temporary, for clarity when debugging

 

[arnelgp]

the remaining row show numbers as attached

do you mean if the number of records is less than the number of lines in
a report, do not add blank lines?