By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Combining a snake report with a normal report

P: n/a
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
Jan 12 '08 #1
Share this Question
Share on Google+
13 Replies


P: n/a
On Jan 12, 8:28*am, anthony <anthony.marr...@gmail.comwrote:
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).
Jan 12 '08 #2

P: n/a
OK, groovy. I'll do some experimentation. Thanks very much
Jan 13 '08 #3

P: n/a
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
Jan 14 '08 #4

P: n/a
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

Jan 15 '08 #5

P: n/a
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!
Jan 15 '08 #6

P: n/a
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

Jan 15 '08 #7

P: n/a
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












Jan 15 '08 #8

P: n/a
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.
Jan 15 '08 #9

P: n/a
>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
Jan 15 '08 #10

P: n/a
>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
Jan 15 '08 #11

P: n/a
Hallelujah! Salad has it!
Jan 16 '08 #12

P: n/a
anthony wrote:
Hallelujah! Salad has it!
Not sure what I have. :)

Hip Hip Hurray!
http://www.youtube.com/watch?v=bXk5PWs0EEs
Jan 16 '08 #13

P: n/a
"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.

:-)
Jan 16 '08 #14

This discussion thread is closed

Replies have been disabled for this discussion.