Columns feature and page-break

I'm producing a report to be printed onto labels, and so am using the columns
feature in the layout.
I have a list around my textboxes displaying the data, and another list
surrounding this with a grouping and a page-break at the end of the group.
However the page-break is actually being rendered (into PDF) as a
column-break. That is, one group may finish half way down column 2 on page 1,
and then the next grup will start at the top of column 3 on page 1 instead of
column 1 of page 2.
If this is 'correct behaviour', does anyone know how I might effect a true
page-break?
Many thanks.
--
Mike StephenOn Mar 4, 4:38 am, Mike Stephen
<MikeStep...@.discussions.microsoft.com> wrote:
> I'm producing a report to be printed onto labels, and so am using the columns
> feature in the layout.
> I have a list around my textboxes displaying the data, and another list
> surrounding this with a grouping and a page-break at the end of the group.
> However the page-break is actually being rendered (into PDF) as a
> column-break. That is, one group may finish half way down column 2 on page 1,
> and then the next grup will start at the top of column 3 on page 1 instead of
> column 1 of page 2.
> If this is 'correct behaviour', does anyone know how I might effect a true
> page-break?
> Many thanks.
> --
> Mike Stephen
It seems like you might want to have the inner list control break
after a group as well. SSRS tends to be a little funny about rendering
columns when exported into PDF. Hope this is helpful. Sorry for the
delayed reply.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Column labels in a View

Please bear with me, as I do not work with SQL much. I have a view set
up that compiles rolling monthly data from a historical table. The
view currently looks like this:
Server Current Month One Month Ago Two Months Ago...
Server1 <data> <data> <data>
Is there any way to set the column label for the second column to
datename(m, getdate()) in place of "Current Month"? I would obviously
then want to apply the same logic to the remaining columns.
TIA,
Dave
Hi
You would need to drop the view and re-create it, although this is really a
UI issue!
John
"davrion@.hotmail.com" wrote:

> Please bear with me, as I do not work with SQL much. I have a view set
> up that compiles rolling monthly data from a historical table. The
> view currently looks like this:
> Server Current Month One Month Ago Two Months Ago...
> Server1 <data> <data> <data>
> Is there any way to set the column label for the second column to
> datename(m, getdate()) in place of "Current Month"? I would obviously
> then want to apply the same logic to the remaining columns.
> TIA,
> Dave
>

Column labels in a View

Please bear with me, as I do not work with SQL much. I have a view set
up that compiles rolling monthly data from a historical table. The
view currently looks like this:
Server Current Month One Month Ago Two Months Ago...
Server1 <data> <data> <data>
Is there any way to set the column label for the second column to
datename(m, getdate()) in place of "Current Month"? I would obviously
then want to apply the same logic to the remaining columns.
TIA,
DaveHi
You would need to drop the view and re-create it, although this is really a
UI issue!
John
"davrion@.hotmail.com" wrote:

> Please bear with me, as I do not work with SQL much. I have a view set
> up that compiles rolling monthly data from a historical table. The
> view currently looks like this:
> Server Current Month One Month Ago Two Months Ago...
> Server1 <data> <data> <data>
> Is there any way to set the column label for the second column to
> datename(m, getdate()) in place of "Current Month"? I would obviously
> then want to apply the same logic to the remaining columns.
> TIA,
> Dave
>

Column labels in a View

Please bear with me, as I do not work with SQL much. I have a view set
up that compiles rolling monthly data from a historical table. The
view currently looks like this:
Server Current Month One Month Ago Two Months Ago...
Server1 <data> <data> <data>
Is there any way to set the column label for the second column to
datename(m, getdate()) in place of "Current Month"? I would obviously
then want to apply the same logic to the remaining columns.
TIA,
DaveHi
You would need to drop the view and re-create it, although this is really a
UI issue!
John
"davrion@.hotmail.com" wrote:
> Please bear with me, as I do not work with SQL much. I have a view set
> up that compiles rolling monthly data from a historical table. The
> view currently looks like this:
> Server Current Month One Month Ago Two Months Ago...
> Server1 <data> <data> <data>
> Is there any way to set the column label for the second column to
> datename(m, getdate()) in place of "Current Month"? I would obviously
> then want to apply the same logic to the remaining columns.
> TIA,
> Dave
>