Multiple Body Columns

How do I setup multiple columns in a report? For example: How would I take a
report that has 1 table with 1 column. Currently this one column is written
vertically down from top to bottom over 10 pages. If I repeat the column
multiple times on the same page I can cut the report down to 2 pages. In
Crystal Reports they call it "Formatting Groups with multiple columns". Can
anyone point me in the right direction?
Thanks!I have seen the columns property on the body, but when I set it to something
other than 1 shows multiple columns in design, but does not output them in
preview.
"Mike" <m@.m.com> wrote in message
news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
> How do I setup multiple columns in a report? For example: How would I take
> a report that has 1 table with 1 column. Currently this one column is
> written vertically down from top to bottom over 10 pages. If I repeat the
> column multiple times on the same page I can cut the report down to 2
> pages. In Crystal Reports they call it "Formatting Groups with multiple
> columns". Can anyone point me in the right direction?
> Thanks!
>|||I read somewhere that this in only possible in certain rendering formats
(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
any format, so I used a workaround with a stored proc that returns a dataset
with extra columns (in your case 4 or 6 columns) containing the extra
records. Then I put the data in a grid that has a blank, non-framed column
between each set of extra columns. I can send you a pdf of the output if you
like. If you don't know the exact number of pages, that solution might
become complicated. In my case, that part of the report never goes over one
page.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike" <m@.m.com> wrote in message
news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
> How do I setup multiple columns in a report? For example: How would I take
> a report that has 1 table with 1 column. Currently this one column is
> written vertically down from top to bottom over 10 pages. If I repeat the
> column multiple times on the same page I can cut the report down to 2
> pages. In Crystal Reports they call it "Formatting Groups with multiple
> columns". Can anyone point me in the right direction?
> Thanks!
>|||You're right! I tried to view the report as a tiff and as a PDF and they
displayed properly. I should be able to use that. Too bad the HTML format
doesn't work. Thanks for the lead on this.
Mike
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:uW9mxInEIHA.1208@.TK2MSFTNGP03.phx.gbl...
>I read somewhere that this in only possible in certain rendering formats
>(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
>any format, so I used a workaround with a stored proc that returns a
>dataset with extra columns (in your case 4 or 6 columns) containing the
>extra records. Then I put the data in a grid that has a blank, non-framed
>column between each set of extra columns. I can send you a pdf of the
>output if you like. If you don't know the exact number of pages, that
>solution might become complicated. In my case, that part of the report
>never goes over one page.
> --
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike" <m@.m.com> wrote in message
> news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
>> How do I setup multiple columns in a report? For example: How would I
>> take a report that has 1 table with 1 column. Currently this one column
>> is written vertically down from top to bottom over 10 pages. If I repeat
>> the column multiple times on the same page I can cut the report down to 2
>> pages. In Crystal Reports they call it "Formatting Groups with multiple
>> columns". Can anyone point me in the right direction?
>> Thanks!
>|||I just checked. The printer output also works (i. .e. paper).
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike" <m@.m.com> wrote in message
news:OqwTOJpEIHA.5208@.TK2MSFTNGP04.phx.gbl...
> You're right! I tried to view the report as a tiff and as a PDF and they
> displayed properly. I should be able to use that. Too bad the HTML format
> doesn't work. Thanks for the lead on this.
> Mike
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uW9mxInEIHA.1208@.TK2MSFTNGP03.phx.gbl...
>>I read somewhere that this in only possible in certain rendering formats
>>(i.e. TIFF or printer, I can't remember which). I couldn't make it work in
>>any format, so I used a workaround with a stored proc that returns a
>>dataset with extra columns (in your case 4 or 6 columns) containing the
>>extra records. Then I put the data in a grid that has a blank, non-framed
>>column between each set of extra columns. I can send you a pdf of the
>>output if you like. If you don't know the exact number of pages, that
>>solution might become complicated. In my case, that part of the report
>>never goes over one page.
>> --
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike" <m@.m.com> wrote in message
>> news:eKOmV1mEIHA.5856@.TK2MSFTNGP04.phx.gbl...
>> How do I setup multiple columns in a report? For example: How would I
>> take a report that has 1 table with 1 column. Currently this one column
>> is written vertically down from top to bottom over 10 pages. If I repeat
>> the column multiple times on the same page I can cut the report down to
>> 2 pages. In Crystal Reports they call it "Formatting Groups with
>> multiple columns". Can anyone point me in the right direction?
>> Thanks!
>>
>|||You can find more information about Multi-Column reports and how to
make/design them at the link here:
http://msdn2.microsoft.com/en-us/library/ms155816.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Mike" <m@.m.com>
> Subject: Multiple Body Columns
> Date: Fri, 19 Oct 2007 09:30:20 -0700
> Lines: 10
> How do I setup multiple columns in a report? For example: How would I
take a
> report that has 1 table with 1 column. Currently this one column is
written
> vertically down from top to bottom over 10 pages. If I repeat the column
> multiple times on the same page I can cut the report down to 2 pages. In
> Crystal Reports they call it "Formatting Groups with multiple columns".
Can
> anyone point me in the right direction?
> Thanks!
>
>