How to format a Report to show number of rows

[palvarez64]

Hello,

I have a report (see attach file, page 1), under "Service Code", "Start", "End" & "Amount" there is 10 rows that s/b visible all the time. If a client has 2 records, the report should show the 2 lines with information and 8 empty rows (see attach file, page 2).

I know it's possible to achieve this task, but I can't find the correct answer.

Thanks,

Pedro

 

[apr pillai]

1. Add empty Text Boxes in all cells of ten rows.
2. Name each Text Box with a unique name but can be addressed each one easily in Code with row, column index numbers or any method that you prefer.
3. Read the field values of each record from the Record Source of the Report and set the Control Source property of each Text Box with the Value.
4. Do this till the end-of-file is reached. Other rows of Text Boxes will remain empty.

There is one Blog Post explaining how to prepare a Dynamic Report:Dynamic Report

You may get more insight into your own problem solving.