reporting services table formatting

When you have a table that continues onto another page, how do you get
the table headers to show on the 2nd page? I just get a continuation of
the table with no headers on subsequent pages.
Anybody know how to do this?
*** Sent via Developersdex http://www.examnotes.net ***You can set the property RepeatOnNewPage property of the header to True in
order to get table headers on each page. It is False by default.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:uLW3bBMeGHA.3388@.TK2MSFTNGP05.phx.gbl...
> When you have a table that continues onto another page, how do you get
> the table headers to show on the 2nd page? I just get a continuation of
> the table with no headers on subsequent pages.
> Anybody know how to do this?
>
> *** Sent via Developersdex http://www.examnotes.net ***

reporting services table formatting

When you have a table that continues onto another page, how do you get
the table headers to show on the 2nd page? I just get a continuation of
the table with no headers on subsequent pages.

Anybody know how to do this?

Are you using Reporting Services 2005?

If so... Select the table and right click to get the pop-up menu. Select properties and on the first tab (General) there is a checkbox "Repeat header rows on each page"

mike72:

When you have a table that continues onto another page, how do you get
the table headers to show on the 2nd page? I just get a continuation of
the table with no headers on subsequent pages.

Anybody know how to do this?

Reporting Services Formatting Problem(s)

Hi. We seem to be having some recurring formatting issues with
Reporting Services (SQL 2005) and Visual Studio (2005).
We have a report that basically shows one record per page (it's used
to produce award-type certificates). We want the info centered on the
page, both horizontally and vertically. When we run the report, it
centers the info on the page one (the first record); however, all the
subsequent pages don't adjust to the centering, the text is just at
the top of the page. It seems like Visual Studio isn't re-formatting,
or re-running the report for pages 2 - the end. We tried deploying the
report, thinking that would force the report to reformat for the
remaining pages, but it didn't work. The formatting itself seems to
be ok because it adjusts the first page to anything we want - it's
just everything after the first page that doesn't change. Any ideas
would be appreciated - we're heading a roadblock!
Thanks!Have you tried putting your controls inside a rectangle?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
<alisonrhae@.hotmail.com> wrote in message
news:1176477583.112580.97300@.q75g2000hsh.googlegroups.com...
> Hi. We seem to be having some recurring formatting issues with
> Reporting Services (SQL 2005) and Visual Studio (2005).
> We have a report that basically shows one record per page (it's used
> to produce award-type certificates). We want the info centered on the
> page, both horizontally and vertically. When we run the report, it
> centers the info on the page one (the first record); however, all the
> subsequent pages don't adjust to the centering, the text is just at
> the top of the page. It seems like Visual Studio isn't re-formatting,
> or re-running the report for pages 2 - the end. We tried deploying the
> report, thinking that would force the report to reformat for the
> remaining pages, but it didn't work. The formatting itself seems to
> be ok because it adjusts the first page to anything we want - it's
> just everything after the first page that doesn't change. Any ideas
> would be appreciated - we're heading a roadblock!
> Thanks!
>|||On Apr 13, 12:47 pm, "Andy Potter" <i...@.lakeclaireenterprises.com>
wrote:
> Have you tried putting your controls inside a rectangle?
> --
> Andy Potter
> blog :http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com<alisonr...@.hotmail.com> wrote in message
> news:1176477583.112580.97300@.q75g2000hsh.googlegroups.com...
No, but I will. The only thing on the report page at this point is a
a single table with 1 column and 4 rows of information. Thanks for the
thought!
Alison Mumaugh

Reporting Services Formatting Fields from whole minutes to hours

Dear All,

I have a problem formatting a field in Reporting Services (minutes to hours).

I have a field called duration which stores time in whole minutes only. I can format this into hours within mssql using the following:

cast(sn.duration/60 as varchar(5)) + ':' + RIGHT('0' + cast(sn.duration%60 as varchar(2)), 2)

But I need to have totals and average columns in my report, which means that the data must come through to RS in the minutes format so I can perform the calculations there.

I have the first part (I think!!):

=string.format("{0:0}",Fields!SalesTime.Value / 60) + ":"

But I cannot get the minutes part working!

Any help would be gratefully received.

Dan

note direction of the slash!

635

= (635\60) & ":" & 635 - ((635 \ 60) * 60)|||

Thank you,

with a little formatting it has worked a treat!!!

Dan

Reporting Services Error After Formatting Report

I created a drill-down report from a cube in Analysis Services using the report wizard. When I preview the report, the columns are not wide enough to view the data without the data getting wrapped around to the next line (the number 51,520,384.92 does not display on a single line). When I try to change the column width and then preview the report, I get a fatal error and Visual Studio closes. I had the same problem when I tried to change the number format to display 2 decimal places and preview the report. However, the number format worked if I saved my changes before previewing the report. Unfortunately this does not work for column width. Is there a work around for this? If I can't format my reports I'll have to use another application.

I can format reports without any problems when I create them manually, but it would be nice to use the wizard for the easier reports.|||I believe this issue has been fixed in the upcoming SP1 release of SQL Server 2005.

Reporting Services Error After Formatting Report

I created a drill-down report from a cube in Analysis Services using the report wizard. When I preview the report, the columns are not wide enough to view the data without the data getting wrapped around to the next line (the number 51,520,384.92 does not display on a single line). When I try to change the column width and then preview the report, I get a fatal error and Visual Studio closes. I had the same problem when I tried to change the number format to display 2 decimal places and preview the report. However, the number format worked if I saved my changes before previewing the report. Unfortunately this does not work for column width. Is there a work around for this? If I can't format my reports I'll have to use another application.

I can format reports without any problems when I create them manually, but it would be nice to use the wizard for the easier reports.|||I believe this issue has been fixed in the upcoming SP1 release of SQL Server 2005.