Prev: Help finding the inches...
Next: Report Image Control
From: WSR on 21 Apr 2010 07:08
I have a table with columns that represent different metrics on separate
investments.

Each investment is a separate row of the table.

Is it possible to have a Report based on the table that displays/prints each
row as a separate report?

Thanks!

(B^>)-]=[


From: Marshall Barton on 21 Apr 2010 10:32
WSR wrote:

>I have a table with columns that represent different metrics on separate
>investments.
>
>Each investment is a separate row of the table.
>
>Is it possible to have a Report based on the table that displays/prints each
>row as a separate report?


Well, lots ot things are possible, but in this case it can
be a pain. Why not just start each detail on a new page (or
group on the investment ID and start each group on a new
page)?

If you really have to have separate reports, then you need
to open a recordset on the report's data, loop through it,
open the report filtered on the ID field, wait for the
report to close, and then go on to the next record.

--
Marsh
MVP [MS Access]
From: WSR on 21 Apr 2010 10:54
Thanks for your reply!

That would be the solution if I knew how to do it.

So when I go into Report Layout Tools/Format/Group and Sort/click the "More"
arrow at the bottom.

What would be your instruction to have each investment print on a separate
page?

"do not keep group together on one page"
"keep whole group together on one page"
"keep header and first record together on first page"?

This is difficult to explain but you got the gist of what I'm trying to do!

Thanks again!

(B^>)-]=[

"Marshall Barton" <marshbarton(a)wowway.com> wrote in message
news:um2us55gb5oe2v1prniikb36jrtq94c98m(a)4ax.com...
> WSR wrote:
>
>>I have a table with columns that represent different metrics on separate
>>investments.
>>
>>Each investment is a separate row of the table.
>>
>>Is it possible to have a Report based on the table that displays/prints
>>each
>>row as a separate report?
>
>
> Well, lots ot things are possible, but in this case it can
> be a pain. Why not just start each detail on a new page (or
> group on the investment ID and start each group on a new
> page)?
>
> If you really have to have separate reports, then you need
> to open a recordset on the report's data, loop through it,
> open the report filtered on the ID field, wait for the
> report to close, and then go on to the next record.
>
> --
> Marsh
> MVP [MS Access]


From: Marshall Barton on 21 Apr 2010 13:04
WSR wrote:
>So when I go into Report Layout Tools/Format/Group and Sort/click the "More"
>arrow at the bottom.
>
>What would be your instruction to have each investment print on a separate
>page?
>
>"do not keep group together on one page"
>"keep whole group together on one page"
>"keep header and first record together on first page"?
>

I don't think you need any of that. Just set the group
header section's ForceNewPage property to Yes.
If you do not already have grouping set, then set it for the
detail section.

--
Marsh
MVP [MS Access]
From: WSR on 21 Apr 2010 13:24
Thanks. I'll try that.

Much appreciated!

(B^>)-]=[

"Marshall Barton" <marshbarton(a)wowway.com> wrote in message
news:kqbus5hqemjf0aggl4nl6r2mi5dagrfe5k(a)4ax.com...
> WSR wrote:
>>So when I go into Report Layout Tools/Format/Group and Sort/click the
>>"More"
>>arrow at the bottom.
>>
>>What would be your instruction to have each investment print on a separate
>>page?
>>
>>"do not keep group together on one page"
>>"keep whole group together on one page"
>>"keep header and first record together on first page"?
>>
>
> I don't think you need any of that. Just set the group
> header section's ForceNewPage property to Yes.
> If you do not already have grouping set, then set it for the
> detail section.
>
> --
> Marsh
> MVP [MS Access]


 | 
Pages: 1
Prev: Help finding the inches...
Next: Report Image Control