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 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 textbox expression based on column value

Please forgive what I'm sure is a novice question but I've only been
playing around with Reporting Svcs for a few days.
I have a report that's rendered from a stored procedure (no prob there
- works quite nicely). One of the grouping variables, Type, has values
such as "SS_F", "SS_P" and the like.
Naturally what I'd like to do is assign meaningful labels to these
values. Since there are only a few of them and they're static for the
report - that is, the same 4 values (well, up to 4 .. perhaps only 2 or
3 in any given run) would be returned on any run of the stored proc.
Where do I do that' Or do I need to make the assignments in code? If
so, how do I get there? And before suggesting that I do them in the
sp, I can't - it's not mine to touch :)
Thanks so much for any help!
-Steve LordYou would put in a nested iif statement. RS 2005 books online didn't have an
index listing for that but you could search on the phrase conditional
formatting
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Steve L" <slord@.circlesofcare.org> wrote in message
news:1141419699.794514.9160@.e56g2000cwe.googlegroups.com...
> Please forgive what I'm sure is a novice question but I've only been
> playing around with Reporting Svcs for a few days.
> I have a report that's rendered from a stored procedure (no prob there
> - works quite nicely). One of the grouping variables, Type, has values
> such as "SS_F", "SS_P" and the like.
> Naturally what I'd like to do is assign meaningful labels to these
> values. Since there are only a few of them and they're static for the
> report - that is, the same 4 values (well, up to 4 .. perhaps only 2 or
> 3 in any given run) would be returned on any run of the stored proc.
> Where do I do that' Or do I need to make the assignments in code? If
> so, how do I get there? And before suggesting that I do them in the
> sp, I can't - it's not mine to touch :)
> Thanks so much for any help!
> -Steve Lord
>|||Here's what I had for changing the image used in a report:
=Switch(Fields!PDPType.Value="Bug", "http://localhost/images/bug.gif",
Fields!PDPType.Value="Customization Request",
"http://localhost/images/customization.gif", Fields!PDPType.Value="New
Feature/Enhancement", "http://localhost/images/enhancement.gif",
Fields!PDPType.Value="Script Request", "http://localhost/images/script.gif",
Fields!PDPType.Value="Support Request", http://localhost/images/support.GIF)
Should work for a text field too, I think. Sorry if I'm not understanding
your original question, though, or if you run into another snag. I'm rather
a newbie at the RS stuff myself.
Clint
"Steve L" <slord@.circlesofcare.org> wrote in message
news:1141419699.794514.9160@.e56g2000cwe.googlegroups.com...
> Please forgive what I'm sure is a novice question but I've only been
> playing around with Reporting Svcs for a few days.
> I have a report that's rendered from a stored procedure (no prob there
> - works quite nicely). One of the grouping variables, Type, has values
> such as "SS_F", "SS_P" and the like.
> Naturally what I'd like to do is assign meaningful labels to these
> values. Since there are only a few of them and they're static for the
> report - that is, the same 4 values (well, up to 4 .. perhaps only 2 or
> 3 in any given run) would be returned on any run of the stored proc.
> Where do I do that' Or do I need to make the assignments in code? If
> so, how do I get there? And before suggesting that I do them in the
> sp, I can't - it's not mine to touch :)
> Thanks so much for any help!
> -Steve Lord
>

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 Reporting Website Language

Hi

We use English Server Operating Systems and Applications and German Client Software.
When we use our for German language configured Internet Explorers the Reporting Website is displayed in somewhat horrible translations.

How are we supposed to get the English website without changing the language settings at each IE we use?

You can remove the de driectory in the Report Manager\bin directory. This will disable the German translation. Just tried it myself and it works.

|||Thanks, it worked :).

Changing password

Hi Freinds,
SQL 2000 REPORTING SERVER
I changed my SA account password and Reporting service stop working.
Where should I modify the account crudentails in RSReportServer.config
Thanks,
PatUse rsconfig.exe to reset the connection information for RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick" <patriarck@.gmail.com> wrote in message
news:u%236cNH64EHA.2288@.TK2MSFTNGP11.phx.gbl...
> Hi Freinds,
> SQL 2000 REPORTING SERVER
> I changed my SA account password and Reporting service stop working.
> Where should I modify the account crudentails in RSReportServer.config
> Thanks,
> Pat
>

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 DB locations in production

Can't seem to find the answer to this one.
Anyway, I have a report class that several developers use for reporting.
Each developer has his own DB.
The report class uses the web services for connecting/viewing.
What I want to do is be able for each developer to pass a connection string
or something that will point a shared report to his DB. I really don't want
to create copies of the reports.
Plus, when all production is done we may have hundreds of clients using one
report and each one would need their own DB.
Thanks for any suggestions!
cbmeeks*BUMP*
Sorry to bump but this is starting to become a problem here.
Thanks for any help!
cbmeeks
"cbmeeks" wrote:
> Can't seem to find the answer to this one.
> Anyway, I have a report class that several developers use for reporting.
> Each developer has his own DB.
> The report class uses the web services for connecting/viewing.
> What I want to do is be able for each developer to pass a connection string
> or something that will point a shared report to his DB. I really don't want
> to create copies of the reports.
> Plus, when all production is done we may have hundreds of clients using one
> report and each one would need their own DB.
> Thanks for any suggestions!
> cbmeeks

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

Changing Data Source of Existing Cube

Hi Guys,

We had existing cubes in our Analysis Server, we were required to move them on another Reporting Server which would be using Data Replicated every night to that server. Problem is now source data is divided into 2 Reporting Database Servers. Table Names/View Names are the same in all the Databases. I just want to change the data source pointing to existing Database to the new Reporting Server. Can you tell me how this can be achieved?

Regards,

Kaushal

I have the same question while i also can't find better ways

in fact I have to create cube for another time to change datasource

|||

Looks like RS-related question.

Moving to reporting services forum.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||By Reporting Server, do you mean SSRS? It looks like you just need to change the connection string inside the SSAS database.