Creating Multiple Reports

[wesley.allen]

Hello, thanks for helping.

I am trying to create multiple reports which will eventually be output
to Microsoft Word. Here is what I want to do:

I want to create a seperate report for each person listed in my
database and the securities that they are responsible for pricing.
Each report would list their name and info at the top, with a tabular
of the name and an estimated price at the bottom.

Here would be an example:

John Doe
Franklin Investers
203-555-8151

Nance Primary 52.50
Goodall Printing 35.00


There are 10-15 people and each may have up to 20 or 30 securities. Is
there a way to have a new page of my report for each person? I am not
experienced with Script, so I usually do everything using the design
view of queries and macros.

Thanks again for helping.

 

[Guest]

I would recommend against a seperate report for each person. You don't want
to have to create new objects each time a person is hired or leaves.

Yes, you can force each person onto their own page. In the report design, go
to Sorting and Grouping under the view menu and create a group for your
person field. Make sure you create a group header.

Back in the report, click the header you just created and go to the Format
tab of its properties. The Force New Page property will force a new page
before or after the header. In your case, you probably want Before.

Barry

 

[wesley.allen]

Fantastic. Thanks for helping.

I would recommend against a seperate report for each person. You don't want
to have to create new objects each time a person is hired or leaves.

Yes, you can force each person onto their own page. In the report design, go
to Sorting and Grouping under the view menu and create a group for your
person field. Make sure you create a group header.

Back in the report, click the header you just created and go to the Format
tab of its properties. The Force New Page property will force a new page
before or after the header. In your case, you probably want Before.

Barry