Sunday, February 26, 2012

Format issues - two-column report

I have a report the gets the following data for each member in a report
table format, this query takes parameters and returns about 20 records
and each has the same information shown below.
Name
company
title
address
phone
email
effective date
However, instead of this data "snaking" to the next column it prints
our five pages of this data with one column. I selected "2 columns"
for the body, and increased the body width, but only one column shows
up in the preview mode and afer I deploy the report. What can I do to
make this report have two columns and have a max of four rows per page,
with two records in each column?Try exporting to a paginated output format like Acrobat or TIFF and see if
it snakes then. It will only print one column in HTML.
--
Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
http://www.amazon.com/exec/obidos/tg/detail/-/1590594231/102-0081700-1383300
http://www.apress.com/book/bookDisplay.html?bID=365
"newbie_dba" <gnice4ever@.yahoo.com> wrote in message
news:1102956134.674586.303090@.z14g2000cwz.googlegroups.com...
>I have a report the gets the following data for each member in a report
> table format, this query takes parameters and returns about 20 records
> and each has the same information shown below.
>
> Name
> company
> title
> address
> phone
> email
> effective date
>
> However, instead of this data "snaking" to the next column it prints
> our five pages of this data with one column. I selected "2 columns"
> for the body, and increased the body width, but only one column shows
> up in the preview mode and afer I deploy the report. What can I do to
> make this report have two columns and have a max of four rows per page,
> with two records in each column?
>|||"Try exporting to a paginated output format like Acrobat or TIFF and
see if
it snakes then. It will only print one column in HTML."
Still doesn't work any other suggestions. Does there have to be a
group by clause in the report?|||Using the list layout object and exporting to Acrobat or TIFF does show
multi-column reports.

No comments:

Post a Comment