Changing the Sender in XP_Sendmail

Is is possible to change the sender when using XP_Sendmail? I am sending a
notification that reports are available in reporting services in a single
email and want to change the sender from SQLSERVICEADMIN to something users
will recgonize easily.
Thanks for the help!!
Anthonyanthonysjo wrote:

> Is is possible to change the sender when using XP_Sendmail? I am
> sending a notification that reports are available in reporting
> services in a single email and want to change the sender from
> SQLSERVICEADMIN to something users will recgonize easily.
You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
HTH,
Stijn Verrept.|||Yes, I had found reference to that but my DBA's will push heavily on not
installing it. Is there another way?
"Stijn Verrept" wrote:

> anthonysjo wrote:
>
>
> You could use xp_smtp_sendmail (see http://www.aspfaq.com/2403)
> --
> HTH,
> Stijn Verrept.
>|||As I know there is no way using the "friendly" name within XP_sendmail.
Once I had a commandline program which was able to send also via SMTP.
But this could be easily reprogrammed in .NET or another programming
language covering the same functionality. If you are interested in,
just send me a mail.
HTH, Jens Suessmeyer.

Changing the port that Reporting Services 2000 is running on after activation.

Hi,

I have just installed reporting services 2000 on a non-standard port and have used the rsactivate tool to activate it.

I then installed Microsoft CRM which seems not to like the non-standard port for reporting services, how do I go about deactivating the webservice so I can change the port and then activate it again?

Thanks

I am not too familiar with RS2000, but I think all you have to do is to change the port in IIS, then change the url in the report server and report manager config files. You do not need to run reactivate again.

Changing the parameter of a Snapshot

I understand that a history can be created in Reporting Services. Is
it true that when you click on the "New Snapshot" button, you get a
report using the default parameter? If so, then the "history" feature
is pretty much useless as you can only generate one version of the
report. What we want is to be able to take snapshots of a report at a
give point in time with the desired parameters.
Thanks for any input here.Yes, snapshots in the history are taken with default values of parameters.
If you need to store snapshot with different parameter values, you need to
set different defaults and then take snapshot. Also, when you render that
snapshot, you can change values of parameters that are not used in query.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Eugene" <primer200@.yahoo.com> wrote in message
news:6290d6d2.0407281559.735524cb@.posting.google.com...
> I understand that a history can be created in Reporting Services. Is
> it true that when you click on the "New Snapshot" button, you get a
> report using the default parameter? If so, then the "history" feature
> is pretty much useless as you can only generate one version of the
> report. What we want is to be able to take snapshots of a report at a
> give point in time with the desired parameters.
> Thanks for any input here.|||Dmitry,
From a user point of view, I changed the parameter and I want to take
a snapshot of what I did. That would be a fair enough request,
wouldn't it? The administrator can't give a user Content Manager right
for him to change the default. May be this can be included in
enhencement for the next release?
Regards
Eugene|||We consider this as a request, however, it is not as straightforward as it
seems.
1. Snapshots were not intended to be a replacement for a good Data
Warehouse. Every missing feature about snapshots (and even snapshots
themselves) can be "worked around" by setting a data warehouse that can
reconstruct result of a query for any given time.
2. History is bound to a report, not to a user. Items in history don't carry
any individual security. Anyone who have access to a report would be able to
render from history. Therefore, personal preferences of a anyone, creating
snapshot would affect all users.
3. When allowing defaults only we identify snapshots by creation time. If we
accept parameters, we would have to introduce other means to identify and
manage snapshots. It would be possible and reasonable to take multiple
snapshots at the same time.
4. In many cases, users can create a linked report, provide different
default values for parameters and take snapshot of that linked report.
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Eugene" <primer200@.yahoo.com> wrote in message
news:6290d6d2.0408012040.b062b04@.posting.google.com...
> Dmitry,
> From a user point of view, I changed the parameter and I want to take
> a snapshot of what I did. That would be a fair enough request,
> wouldn't it? The administrator can't give a user Content Manager right
> for him to change the default. May be this can be included in
> enhencement for the next release?
> Regards
> Eugene

Changing the MSSQLServer service account causes SQL Agent could not start

Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
running either a domain account or local system account, i.e.
MSSQLServer service is under a domain account, SQL Agent is under
local system.
For a reason, we need to switch the domain account to the other domain
account, the MSSQLServer service is started up with no problem but the
SQL Agent is not able to start up neither in local system or new
domain account, the error message is: "The SQL Server Agent
(MSSQLSERVER) service on Local Computer started and then stop
automatically if they have no work to do, for example, the Performance
Logs and Alerts service. "
Switch back to original domain account is fine, let the MSSQLServer
running on local system account is fine too for both MSSQLServer and
SQL Agent.
P.S. Both old/new domain accounts are in the server's local admin and
domain administrator groups and as well as SQL sa.
What is needed to use a domain account as the SQL service account?
Thanks,
Yvette.
Hi Yvette
"yvette.ye@.gmail.com" wrote:

> Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
> running either a domain account or local system account, i.e.
> MSSQLServer service is under a domain account, SQL Agent is under
> local system.
> For a reason, we need to switch the domain account to the other domain
> account, the MSSQLServer service is started up with no problem but the
> SQL Agent is not able to start up neither in local system or new
> domain account, the error message is: "The SQL Server Agent
> (MSSQLSERVER) service on Local Computer started and then stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts service. "
> Switch back to original domain account is fine, let the MSSQLServer
> running on local system account is fine too for both MSSQLServer and
> SQL Agent.
> P.S. Both old/new domain accounts are in the server's local admin and
> domain administrator groups and as well as SQL sa.
> What is needed to use a domain account as the SQL service account?
> Thanks,
> Yvette.
>
For the account types that can be used see
http://support.microsoft.com/kb/907557
and http://support.microsoft.com/kb/283811 describes the requirements for
the accounts if you don't use EM or SCM to change the account.
John
|||"John Bell" wrote:

> Hi Yvette
> For the account types that can be used see
> http://support.microsoft.com/kb/907557
> and http://support.microsoft.com/kb/283811 describes the requirements for
> the accounts if you don't use EM or SCM to change the account.
> John
Also try http://msdn2.microsoft.com/en-us/library/ms143504.aspx
John

Changing the MSSQLServer service account causes SQL Agent could not start

Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
running either a domain account or local system account, i.e.
MSSQLServer service is under a domain account, SQL Agent is under
local system.
For a reason, we need to switch the domain account to the other domain
account, the MSSQLServer service is started up with no problem but the
SQL Agent is not able to start up neither in local system or new
domain account, the error message is: "The SQL Server Agent
(MSSQLSERVER) service on Local Computer started and then stop
automatically if they have no work to do, for example, the Performance
Logs and Alerts service. "
Switch back to original domain account is fine, let the MSSQLServer
running on local system account is fine too for both MSSQLServer and
SQL Agent.
P.S. Both old/new domain accounts are in the server's local admin and
domain administrator groups and as well as SQL sa.
What is needed to use a domain account as the SQL service account?
Thanks,
Yvette.Hi Yvette
"yvette.ye@.gmail.com" wrote:
> Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
> running either a domain account or local system account, i.e.
> MSSQLServer service is under a domain account, SQL Agent is under
> local system.
> For a reason, we need to switch the domain account to the other domain
> account, the MSSQLServer service is started up with no problem but the
> SQL Agent is not able to start up neither in local system or new
> domain account, the error message is: "The SQL Server Agent
> (MSSQLSERVER) service on Local Computer started and then stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts service. "
> Switch back to original domain account is fine, let the MSSQLServer
> running on local system account is fine too for both MSSQLServer and
> SQL Agent.
> P.S. Both old/new domain accounts are in the server's local admin and
> domain administrator groups and as well as SQL sa.
> What is needed to use a domain account as the SQL service account?
> Thanks,
> Yvette.
>
For the account types that can be used see
http://support.microsoft.com/kb/907557
and http://support.microsoft.com/kb/283811 describes the requirements for
the accounts if you don't use EM or SCM to change the account.
John|||"John Bell" wrote:
> Hi Yvette
> For the account types that can be used see
> http://support.microsoft.com/kb/907557
> and http://support.microsoft.com/kb/283811 describes the requirements for
> the accounts if you don't use EM or SCM to change the account.
> John
Also try http://msdn2.microsoft.com/en-us/library/ms143504.aspx
John

Changing the Currency with Reporting Services

Hi,

I am formatting a currency field within reporting services using an expression. However i get the $ sign. I need the ￡ sign. How can i change this?

Thanks

David

Weird. It seems that once you wrap the FormatCurrency() Vb function, the localization goes out the window

Two workarounds
A)
1. Kill the FormatCurrency Wrapper function in your expression.
2. Use the Format Property of the texbox instead..so Format might equal C2 (for currency with 2 decimal places of precision.
3. Set your Language to English (United Kingdom) - found in Properties, in the International group

B)
If you simply MUST have the FormatCurrency wrapper then do the following
1. Wrap that expression in a CDBL()...so CDBL(FormatCurrency(blah))
2. Follow 2 & 3 in the steps for option A

Cheers

Changing services on different account....

If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
are[vbcol=seagreen]
>

Changing services on different account....

If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
Smith
Hi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>
|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
are
>

Changing services on different account....

If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> > If I change the login account for MSSQLSERVER and SQLSERVERAGENT what
are
> > all the things that I should cross check to make sure that everything is
> > fine and smooth transition.
> >
> > 1. All scheduled job on SQL Server.
> >
> > Any thing else I am missing in the above list?
> >
> > SQL 2K.
> >
> > Thanks,
> >
> > Smith
> >
> >
> >
>

Changing sa password on reporting services DB server

I need to know how to change ReportManager to use the new SA password for the DB Server. I can not get into an interface since the sa password was changed. Everything gives a login failed for user 'sa' error message.
You need to use RSCONFIG with the -sql switch to do this. Have a look in the
helpfile for the full syntax. If you can't find it then I'll dig it out of
my notes, as I had the same issue a few weeks ago.
HTH,
Paul Ibison

Changing sa password on reporting services DB server

I need to know how to change ReportManager to use the new SA password for the DB Server. I can not get into an interface since the sa password was changed. Everything gives a login failed for user 'sa' error messageYou need to use RSCONFIG with the -sql switch to do this. Have a look in the
helpfile for the full syntax. If you can't find it then I'll dig it out of
my notes, as I had the same issue a few weeks ago.
HTH,
Paul Ibison

Changing sa password on reporting services DB server

I need to know how to change ReportManager to use the new SA password for th
e DB Server. I can not get into an interface since the sa password was chan
ged. Everything gives a login failed for user 'sa' error message.You need to use RSCONFIG with the -sql switch to do this. Have a look in the
helpfile for the full syntax. If you can't find it then I'll dig it out of
my notes, as I had the same issue a few weeks ago.
HTH,
Paul Ibison

Changing path of web service?

I have 2 report services servers one for development and one for live, I
need to add a reference to the web service in my app, but during development
it has to refernce development server, during deployment it has to reference
what ever the end user calls their server, can you change the reference url
of a web service at run time? if so how? thanks! the web services will all
have the same definition at all times. I'm also doing this in VB.NETSmokey Grindle wrote:
> I have 2 report services servers one for development and one for live, I
> need to add a reference to the web service in my app, but during development
> it has to refernce development server, during deployment it has to reference
> what ever the end user calls their server, can you change the reference url
> of a web service at run time? if so how? thanks! the web services will all
> have the same definition at all times. I'm also doing this in VB.NET
IIRC, when you declare an instance of the web service, you can set it's
URL property to the correct one.

Changing layout for report

Hi all!
Does anyone know if it is possible to change the layout of reports? I'm
using reporting services for some new reports in our application, and I want
the new reports to look similiar to the existing reports. Some of the things
I would like to do is to move the parameters to the right of the report
(instead of having them on top) and changing background color for parameters
area and tool bar.
Can anyone tell me if this is possible, and if so, how can I achieve this?
Thanks!
Regards
HanneUsing Report Manager this is not possible... You would have to use your own
ASPX pages to create what you wish.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Hanne" wrote:
> Hi all!
> Does anyone know if it is possible to change the layout of reports? I'm
> using reporting services for some new reports in our application, and I want
> the new reports to look similiar to the existing reports. Some of the things
> I would like to do is to move the parameters to the right of the report
> (instead of having them on top) and changing background color for parameters
> area and tool bar.
> Can anyone tell me if this is possible, and if so, how can I achieve this?
> Thanks!
> Regards
> Hanne|||I'm fairly new to both RS and ASP.NET... Could you please briefly explain how
this works and how I use the reports with my own ASPX pages? Would really
appreciate it if you could!! Do you have any samples?
Regards
Hanne
"Wayne Snyder" wrote:
> Using Report Manager this is not possible... You would have to use your own
> ASPX pages to create what you wish.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Hanne" wrote:
> > Hi all!
> >
> > Does anyone know if it is possible to change the layout of reports? I'm
> > using reporting services for some new reports in our application, and I want
> > the new reports to look similiar to the existing reports. Some of the things
> > I would like to do is to move the parameters to the right of the report
> > (instead of having them on top) and changing background color for parameters
> > area and tool bar.
> >
> > Can anyone tell me if this is possible, and if so, how can I achieve this?
> >
> > Thanks!
> >
> > Regards
> > Hanne

Changing Group BackgroundColor from Field Values

Hello Everybody,

I'am working with "Reporting Services 2005".
I would like to have specific Colors for a Group.

e.g.

+Apel: (Group, f.e. "green")

+peach: (Group, f.e. "red")
....

Apel and peach have each a color assigned in the database.
Each Report can have different Fruits on it, but they are defined by their color.

Could change the color statically and and toggle Details Colors, but nut this!

Thanks very much for any kind of help!

Have your query return the background color. THen add that color field to your group. Set the rowdetail background to the color from the dataset.|||Thanks very much, it works!

changing filename of PDF-Report

Hello,
we use the Report Services to generate bills from our orders. Therefor a
url with all the report parameters is created and send to the internet
explorer which displays the report with the pdf plugin (standard).
Our problem is that all reports have the same name (for example bill.pdf).
Is it possible to send a paramter (maybe a system one) which the report
server is using and named the file like it?
For example we give in the url &reportname=bill001 and then the file
generated names bill001.pdf?
Thanks for all answers.Hi Thomas,
We are using RS to generate pdf files, but we are just streaming directly
the resulting pdf to the client browser.
So, the result of the Render method of the ReportingServices object (which
is of type "array of bytes" ) gets passed to the browser using
Response.BinaryWrite(result).
I think you could use something to write the array of bytes to a pdf file -
and at this step you can choose the name you want for this pdf file.
Example:
Dim fs As New System.IO.FileStream("c:\customers\BILL001.pdf",
System.IO.FileMode.CreateNew)
' Create the writer for data.
Dim w As New System.io.BinaryWriter(fs)
' Write data to Test.data.
Dim b() As Byte
b = rs.Render(...parameters for report rendering)
w.Write(b)
w.Close()
fs.Close()
Hope this helps,
Andrei.
"Thomas Weiler" <Thomas.Weiler@.bigfoot.de> wrote in message
news:ec8HJOGPFHA.1088@.TK2MSFTNGP14.phx.gbl...
> Hello,
> we use the Report Services to generate bills from our orders. Therefor a
> url with all the report parameters is created and send to the internet
> explorer which displays the report with the pdf plugin (standard).
> Our problem is that all reports have the same name (for example bill.pdf).
> Is it possible to send a paramter (maybe a system one) which the report
> server is using and named the file like it?
> For example we give in the url &reportname=bill001 and then the file
> generated names bill001.pdf?
> Thanks for all answers.

Changing database query (server, database, tables and query)

I'm working with ASP.NET web forms (using Visual Studio and C# code)
I've now introduced 'SQL Server 2000 Reporting Services' and am impressed
with what I've seen so far (albeit that I've only spent a few hours with it).
:)
1). I need the ability to point the report to a server / database rather
than always have it running against the same target. Similarly I may need to
change the SQL syntax of the query being run (rather than relying on
parameter passing).
It looks as if I need to do this via making use of the web service - but I
can't get my head around this.
Thanks in advance
SteveI've just posted a DPE to
http://workspaces.gotdotnet.com/appworld that may help you.
Regards
Toby
"Steve_S3T" <Steve_S3T@.discussions.microsoft.com> wrote in message
news:4AEF4962-798A-4C11-BFEF-B30E4800ADDA@.microsoft.com...
> I'm working with ASP.NET web forms (using Visual Studio and C# code)
> I've now introduced 'SQL Server 2000 Reporting Services' and am impressed
> with what I've seen so far (albeit that I've only spent a few hours with
it).
> :)
> 1). I need the ability to point the report to a server / database rather
> than always have it running against the same target. Similarly I may need
to
> change the SQL syntax of the query being run (rather than relying on
> parameter passing).
> It looks as if I need to do this via making use of the web service - but
I
> can't get my head around this.
> Thanks in advance
> Steve