Multiple Column Lists

I'm trying to create a Report with a sub report of items that needs to be
listed in multilple columns. The data is brought in through a sql query into
the sub report. The list contains anywhere between 1 and 30 items. I can
not get the list to do more than one column. I've tried setting the page
margins to limit the length of the list, but when it reaches the bottom of
the page, instead of wrapping to the second column it continues the list on
another page. Each column is set to 1.95 inches with a .1 inch spacing and
the page length is set to 1.5 inches and width of 4 inches. I've tried
varying the page sizes and nothing seems to work. Any suggestions?In the layout of your subreport, pull in a Table form, then set your fields
in the columns that you want them in. This should format your multiple
columns.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"rb69" wrote:
> I'm trying to create a Report with a sub report of items that needs to be
> listed in multilple columns. The data is brought in through a sql query into
> the sub report. The list contains anywhere between 1 and 30 items. I can
> not get the list to do more than one column. I've tried setting the page
> margins to limit the length of the list, but when it reaches the bottom of
> the page, instead of wrapping to the second column it continues the list on
> another page. Each column is set to 1.95 inches with a .1 inch spacing and
> the page length is set to 1.5 inches and width of 4 inches. I've tried
> varying the page sizes and nothing seems to work. Any suggestions?|||Ok,the multiple columns is just one field being listed in both columns. It
needs to wrap between columns. If I am using a table, can I set two columns
to display half the data in the first column and then the other half in the
second column? i.e. I have a list of 30 different amenities associated with
an apartment and I need it to display the first 15 in the first column then
the last 15 in the second column, but depending on the apartment the
amenities range between 0 & 30, each apartment is different, so the length of
the list varies. I can do it in Access by setting the columns to two and
then placing a list box in the first column of a subreport. It automatically
wraps the list to the second column. But it doesn't work in SQL Server
Reports although according to every manual I've gotten my hands on it should.
"Catadmin" wrote:
> In the layout of your subreport, pull in a Table form, then set your fields
> in the columns that you want them in. This should format your multiple
> columns.
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "rb69" wrote:
> > I'm trying to create a Report with a sub report of items that needs to be
> > listed in multilple columns. The data is brought in through a sql query into
> > the sub report. The list contains anywhere between 1 and 30 items. I can
> > not get the list to do more than one column. I've tried setting the page
> > margins to limit the length of the list, but when it reaches the bottom of
> > the page, instead of wrapping to the second column it continues the list on
> > another page. Each column is set to 1.95 inches with a .1 inch spacing and
> > the page length is set to 1.5 inches and width of 4 inches. I've tried
> > varying the page sizes and nothing seems to work. Any suggestions?|||The only thing I can think of to do is to merge the cells of the columns,
like in Excel. Given your description of your issue, though, I'm not sure if
that will work for you or not.
Unfortunately, SQL RS is picky about the way it expands a field for more
details. Because the fields work like they do in Excel, the auto-increase
feature will increase the field height, not width, and it won't go over into
the next column unless you merge the cells. The only other option I can
think of is a table within a table so that you can adjust the columns for
your amenities independently of the columns in the outside table.
Catadmin
"RB69" wrote:
> Ok,the multiple columns is just one field being listed in both columns. It
> needs to wrap between columns. If I am using a table, can I set two columns
> to display half the data in the first column and then the other half in the
> second column? i.e. I have a list of 30 different amenities associated with
> an apartment and I need it to display the first 15 in the first column then
> the last 15 in the second column, but depending on the apartment the
> amenities range between 0 & 30, each apartment is different, so the length of
> the list varies. I can do it in Access by setting the columns to two and
> then placing a list box in the first column of a subreport. It automatically
> wraps the list to the second column. But it doesn't work in SQL Server
> Reports although according to every manual I've gotten my hands on it should.
> "Catadmin" wrote:
> > In the layout of your subreport, pull in a Table form, then set your fields
> > in the columns that you want them in. This should format your multiple
> > columns.
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "rb69" wrote:
> >
> > > I'm trying to create a Report with a sub report of items that needs to be
> > > listed in multilple columns. The data is brought in through a sql query into
> > > the sub report. The list contains anywhere between 1 and 30 items. I can
> > > not get the list to do more than one column. I've tried setting the page
> > > margins to limit the length of the list, but when it reaches the bottom of
> > > the page, instead of wrapping to the second column it continues the list on
> > > another page. Each column is set to 1.95 inches with a .1 inch spacing and
> > > the page length is set to 1.5 inches and width of 4 inches. I've tried
> > > varying the page sizes and nothing seems to work. Any suggestions?