Combining a snake report with a normal report

[anthony]

I'm creating a report that will present information split into several
sections with each section dealing with a particular aspect of data.
No problem there. However, one of the sections will contain
photographs which I need to snake across and down the page. That's
fine if the report just contained photos because I can create the
column of an appropriate width and let the report get on with it. But,
because those sections of the report that are not photos need to be
full width, I don't see how I can combine the two. Perhaps with a sub-
report (I'm not sure and this Access Bible I've got here says nothing
about sub-reports)?? All advice welcome, please

Many thanks

[Pachydermitis]

On Jan 12, 8:28*am, anthony <[e-mail]:

I'm creating a report that will present information split into several
sections with each section dealing with a particular aspect of data.
No problem there. However, one of the sections will contain
photographs which I need to snake across and down the page. That's
fine if the report just contained photos because I can create the
column of an appropriate width and let the report get on with it. But,
because those sections of the report that are not photos need to be
full width, I don't see how I can combine the two. Perhaps with a sub-
report (I'm not sure and this Access Bible I've got here says nothing
about sub-reports)?? All advice welcome, please

Many thanks

For sub reports, just create a separate report for each one of the
sections. Then create another report and drag each section report
in. Resize and rearrange as you like. In the main report the sub
reports can be super thin and stretch all the way across the page, and
when you actually view them they will grow to their full length (by
default).

[anthony]

OK, groovy. I'll do some experimentation. Thanks very much

[anthony]

I can't get this to work and it's driving me bananas. I have a main
report with the detail section consisting just of a subreport. The
subreport is supposed to snake, and it does when opened on its own.
However, when added as a subreport to the main report, it doesn't
snake. It provides all the right data but doesn't snake. If I remove
the master/child links, it snakes but obviously produces rubbish. I am
at my wits end - Access 2007, by the way

[Earl Anderson]

What exactly is "snake"? I gather you want some photos on a report, but are
those same or related photos supposed to go onto another report? Would you
cite an example of what you are trying to achieve as an end result?

Just curious...
Earl
"anthony" <an*************@gmail.comwrote in message
news:69**********************************@e23g2000 prf.googlegroups.com...

>I can't get this to work and it's driving me bananas. I have a main
report with the detail section consisting just of a subreport. The
subreport is supposed to snake, and it does when opened on its own.
However, when added as a subreport to the main report, it doesn't
snake. It provides all the right data but doesn't snake. If I remove
the master/child links, it snakes but obviously produces rubbish. I am
at my wits end - Access 2007, by the way

[anthony]

A snake report is one that consists of columns (two in my case). You
can configure the data to go down each column, then across to the top
of the next column and down that etc, or across each row, down to the
beginning of the next row and across that and so on

Part of my report consists of photos and I want six photos on the page
in two columns, hence the need for a snake report

EXCEPT, I can't get it to snake!

[Dominic Vella]

To create a Snake Report, you go into the menu item "File/Page Setup", click
on the Columns tab. In this case you'd type in that you want 2 columns.
Make the report width small enough to fit inside 2 columns.

You'd want to do this in a SubReport because the majority of the report is
single column.

I hope this helps.
Dominic

"anthony" <an*************@gmail.comwrote in message
news:c5**********************************@q39g2000 hsf.googlegroups.com...

I'm creating a report that will present information split into several
sections with each section dealing with a particular aspect of data.
No problem there. However, one of the sections will contain
photographs which I need to snake across and down the page. That's
fine if the report just contained photos because I can create the
column of an appropriate width and let the report get on with it. But,
because those sections of the report that are not photos need to be
full width, I don't see how I can combine the two. Perhaps with a sub-
report (I'm not sure and this Access Bible I've got here says nothing
about sub-reports)?? All advice welcome, please

Many thanks

[anthony]

Hi Dominic

Getting the subreport on its own to snake isn't the problem. It snakes
beautifully. What it won't do is snake when added as a subreport.
Interestingly, it will snake as part of the main report if you remove
the master/child links but then, of course, the data is rubbish

[Salad]

anthony wrote:

Hi Dominic

Getting the subreport on its own to snake isn't the problem. It snakes
beautifully. What it won't do is snake when added as a subreport.
Interestingly, it will snake as part of the main report if you remove
the master/child links but then, of course, the data is rubbish

Is it possible your subreport, on the main report, is too small? For
example, is it as wide as the main report? Is your column width setting
sufficient? Are your margins in the subreport different than the main
report? I wouldn't have an idea what the link fields would have to do
with anything in making it work or fail.

Maybe you can describe how you are doing this. Are the images
hyperlinks or are then stored in the table? If you provided suffiecent
(but not overwhelming) detail, maybe one of us can recreate a similar
report the way you are doing and see what's happening.

[anthony]

>From what table?

All the fields from both tables are in the query

>Why is PhotoID required in the main report?

Are you saying that it would be better to sort PhotoID in the
subreport?

>Maybe create a group with a header on RegNo

There is a group on RegNo (no fields); I need RegNo to appear on every
page which is why it's in the page header

>And what is PhotoID? Is it a number?

It's an AutoNumber

>I would create a main report with just the fields I need.
I would create a subreport that has just the fields that
I need that also has a link field to the main report

That's exactly what I've done. I've only got two fields on the main
report and two on the subreport. All sorting takes place in the report

>I posted a solution for that last week for a snaking subreport.

Do you remember the subject (so I can search for it)?

TVM

[anthony]

>BTW, what version of Access are you using?

2007

Very good advice; I'll look at that carefully, re-jig and report back.
Very grateful for your help

[anthony]

Hallelujah! Salad has it!

[Salad]

anthony wrote:

Hallelujah! Salad has it!

Not sure what I have. :)

Hip Hip Hurray!
http://www.youtube.com/watch?v=bXk5PWs0EEs

[Larry Linson]

"Salad" <oi*@vinegar.comwrote

>Hallelujah! Salad has it!

Not sure what I have. :)

If everybody is screaming and fleeing away, I don't want to know.

If it is young people of the opposite sex, screaming and stampeding toward
you, you have "star power", Salad.

:-)