report templates

We want all our reports to have the same header and footer, in crystal
reports we could make a template report... can something similar be done in
report services? Thanks!Sort of. You can create a style template for the creation of reports.
However, if you want to change it later you have to go to each report one by
one and modify it.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:%23q9LZBmNHHA.2140@.TK2MSFTNGP03.phx.gbl...
> We want all our reports to have the same header and footer, in crystal
> reports we could make a template report... can something similar be done
> in report services? Thanks!
>|||thanks!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ejuo$PmNHHA.4928@.TK2MSFTNGP06.phx.gbl...
> Sort of. You can create a style template for the creation of reports.
> However, if you want to change it later you have to go to each report one
> by one and modify it.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/f84b9ac6-bf37-4f27-bbe4-273a4af84c2e.htm
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:%23q9LZBmNHHA.2140@.TK2MSFTNGP03.phx.gbl...
>> We want all our reports to have the same header and footer, in crystal
>> reports we could make a template report... can something similar be done
>> in report services? Thanks!
>|||Awesome, thanks!
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> wrote in message
news:1725398D-0098-4EC6-AF16-C1AADFC53241@.microsoft.com...
> Another Idea:
> Create a template RDL file and save it.
> Place the RDL file into the location:
> Drive:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
> Now when you click add a new item (from a reports project), it will be one
> the available selections.
> Reeves
> "Smokey Grindle" wrote:
>> We want all our reports to have the same header and footer, in crystal
>> reports we could make a template report... can something similar be done
>> in
>> report services? Thanks!
>>

Report Server Windows service account

Someone posted a similar question a while ago, but I didn't see any reply.
Now I'm running into the same issue, and hopefully someone knows the
definitive answer this time.
In rssetup.chm, Microsoft recommends using Local System to run the
ReportServer service for the following reason:
"If you use a domain user account (even one that has local administrator
privileges), it will limit your choices on how to configure a data source
connection for a report as well as introduce new configuration steps that
are not otherwise required. Specifically, you cannot use prompted or stored
Windows credentials to connect to external data sources. Additionally, you
must create a special user account to support unattended report processing."
However, in readme_en.htm, Microsoft says that you must use a domain
account. Here's an excerpt from the readme file:
"1.10 Domain user account requirement for subscriptions and ReportServer
Windows service running under Windows 2000 or Windows XP
If the ReportServer Windows service is running under Windows 2000 or Windows
XP, you must configure the service to run under a domain account. If you use
an account that does not have sufficient domain permissions, subscription
delivery will fail when the report server attempts to deliver reports to
domain user accounts. The following error occurs when report delivery fails
due to authorization and domain access issues: Failure sending mail: The
Report Server has encountered a configuration error."
I guess since readme comes after the setup.chm, the formers supercedes the
latter. However, I have been running the service using Local System and have
not run into any problems so far. Now, we need to settle on a standard
regarding the service account. But I'm not sure which recommendation to
follow.
LinchiI ran into the same thing... no problems until I tried to use the file
share subscription instead of email. Even specifying a valid domain
account in the subscription config didn't help.
With a domain account I didn't have that problem (though it took me
awhile to discver that backing up and restoring the encryption key is
required when changing the service account).