Showing posts with label 2nd. Show all posts
Showing posts with label 2nd. Show all posts

Friday, March 30, 2012

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?

Wednesday, March 21, 2012

Reporting Services Monthly Subscription

Hello,

I'm scheduling monthly subscriptions in reporting services. I would like to receive subscriptions every 2nd Monday of the month. For instance, if the 1st is a Friday, then report should be delivered Monday, the 11th.

So my question is: in reporting services:

if I set the subscription for Monday - 2nd week, and the first day of the month is a Friday

- does it consider the week from 4 -> 10 as the second week (because month began the week before)

- or as the first week (because it takes into account only full weeks)?

Thanks a lot for any help!

Best regards,

Tiago

Hello Tiago,

I just ran a test to check this out. I created a schedule to run on Monday - 2nd week, the next run will be February 12th. It will assume that 1-7 is the first week of any month, 8-14 is the second week, etc.

So, in your example of your subscription on Monday - 2nd week and the 1st is a Friday, it will run on the 11th. Setting a subscription for Monday - 2nd week will be the correct schedule for what you're trying to accomplish.

Hope this helps.

Jarret

|||Excellent, thanks a lot Jarret!