INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SubReport snaking columns needed

SubReport snaking columns needed

(OP)
My research on this problem leads me to think it is impossible for a subreport inside a Report, Snake.
The bottom part of the letter has a 4 column subreport. I wanted it to snake around.

Attached is some info to check out what i have done.

Thanks for seeing if there is a possibility.

RE: SubReport snaking columns needed

Hi,

I can give you a strategy to stage your data to snake. I just don't know how that can be performed in Access. Maybe someone with some Access smarts can advise on that part.

You need a report PAGE #, COLUMN # and ROW #.

When your Column and Row counters reach MaxReportColumns & MaxReportRows, the Page counter increments while the Column & Row counters are reset to 1.

When your Row counter reaches MaxReportRows, the Column counter increments and the Row counter is reset to 1.

The report headings & data are 'pivoted' on the Column counter value.

I've done this in Excel but not Access, so that's as far as I can take you.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: SubReport snaking columns needed

You might want to take a look at using MS Word. Export your data & import into Word. You can very simply set up 4 columns an the data will snake. You'll need to massage the data to get headings in a Word Header with the correct alignment et al.

If you need help with this, post in forum68: Microsoft: Office.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: SubReport snaking columns needed

(OP)
I have to stay in Access for this, thanks. I tried something again but did not work.

I went to design on the subreport. Then hit File, Print, Print, Setup, columns,
"2" number of columns (i have 4 fields per column), then
'Down,then Across'. OK. OK.

And erased the test print file in the windows settings, printers.

then ran the main report. The subreport inside it, did not change.
Only 1 column of 4 fields appeared as usual.




RE: SubReport snaking columns needed

(OP)
I tried someone's method of 10 yrs ago. I noticed that he had the subreport as wide as the main report.
He also made some On Page, Event Procedure code. I incorporated it.
If I run the subreport alone, the page nicely snakes with 2 columns each with 4 fields.

However, if I use the main report which contains the same subreport, the subreport only shows the
one column with the 4 fields. My letter works ok. Just that it would be nicer to get
the subreport show two columns instead of wasting a 2nd page.

Ideas? thanks all.

RE: SubReport snaking columns needed

You can create a subreport with multiple columns that displays across then down. If you want these to look like down then across it becomes much more difficult:

Easy
Column 1     Column 2    Column 3
   1            2            3
   4            5            6
   7            8            9
  10           11 

Difficult
Column 1     Column 2    Column 3
   1            5            9
   2            6           10
   3            7           11
   4            8 

I have done this by creating a column in the subreport's record source that can be used to sort the records in a way that presenting across then down actually looks like down then across.

Duane
Hook'D on Access
MS Access MVP

RE: SubReport snaking columns needed

(OP)
I took out the subreport from the main report. I have the former subreport as it's own report.
I have 2 buttons on my main form with the criteria boxes. So hitting 2 buttons to print preview
is fine. The criteria boxes hold the criteria unless i get off the main form.
So is well. thanks for the support.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close