Summary and multi column detail

  • Thread starter Thread starter JDR
  • Start date Start date
J

JDR

I need to create a report that displays Law Firms and thier attorneys, the
catch is that I want to list the attorneys in multiple columns on the report
i.e.

Law Firm #1
Attorney #1 Attorney #3
Attorney #4
Attorney #5 Attorney #6

Any idea how this can be accomplished?

Thanks

Jeff...
 
JDR said:
I need to create a report that displays Law Firms and thier attorneys, the
catch is that I want to list the attorneys in multiple columns on the report
i.e.

Law Firm #1
Attorney #1 Attorney #3
Attorney #4
Attorney #5 Attorney #6
Click to expand...

Use a subreport.

Remove the attorney data from the main report's recordsource
query. Base the esubreport on the attorneys table and use
the subreport control's Link Master/Child properties to thie
them together.
 
Thanks!

I can tie the attorneys to law firms OK, but when I try to print the report
as multi-column the lawfirms and detail print in columns.

What I'm trying to do is print 1 row spanning the page that has the Law Firm
info and under the law firm print the attorneys in 3 columns. When I use the
Multilple-Column reporting it splits the group header (where I have the
Lawfirm) into columns just like the detail attorneys.

Hope that makes sense!

Any more ides?

Thanks

Jeff...
 
JDR said:
I can tie the attorneys to law firms OK, but when I try to print the report
as multi-column the lawfirms and detail print in columns.

What I'm trying to do is print 1 row spanning the page that has the Law Firm
info and under the law firm print the attorneys in 3 columns. When I use the
Multilple-Column reporting it splits the group header (where I have the
Lawfirm) into columns just like the detail attorneys.
Click to expand...

I guess I was a little short on details, sorry.

It's the subreport that should have the three columns, not
the main report. Wile you're in the Page Setup - Columns
menu, be sure to set the column snaking to Across then Down.
Subreport are unaware of paging issues and will only do one
column in Down then Across snaking.

Place the subreport control in the main report's detail
section just under the law firm text boxes and make it as
wide as the main report.
--
Marsh
MVP [MS Access]


 
Back
Top