Changing color of the details depending on the value of the field

Hello !
I am using Reporting Services with SQL Server 2000 (SP3).
I am trying to build in dynamic coloring into my report depending on the
value in a certain field. Query already returns name of the color I would
like to use as an additional field (color conditions are driven by range of
data certain value falls into and stored in the database ). I simple need to
pick color stored in this field( it is Dataset field Color) and apply to
particular cell (possibly entire row) when rendering report. Colors are
returned as names: GREEN,RED,GREY etc.
Is there an easy way to accomplish this in Reporting Services?
Any help would be greatly appreciated.
IgorSelect the cell you want to colorize according to the value. Change the
BackColor property and use a VB expression instead of a hard-coded
color. Use the equal sign "=" in order to use a VB expression, just
like this :
=Fields!Color.Value
Since Green, Red and Gray are know colors, they will be authorized.
You also can do something like this (if my sales rate is under 50%, I
colorize in Red, otherwise, in green) :
=IIF(Fields!SalesRate.Value < 50, "Red", "Green")|||Thanks a lot Julich! It worked perfectly! I would actually like to stored
color logic inside that database so that query returns color instead of
having RS making this decisions.
Thanks again,
Igor
"Julich" <julich@.gmail.com> wrote in message
news:1118320972.223994.206500@.z14g2000cwz.googlegroups.com...
> Select the cell you want to colorize according to the value. Change the
> BackColor property and use a VB expression instead of a hard-coded
> color. Use the equal sign "=" in order to use a VB expression, just
> like this :
> =Fields!Color.Value
> Since Green, Red and Gray are know colors, they will be authorized.
> You also can do something like this (if my sales rate is under 50%, I
> colorize in Red, otherwise, in green) :
> =IIF(Fields!SalesRate.Value < 50, "Red", "Green")
>

changing Chart Type

Hi
Do any one have idea on how to change the chart type in Reporting
Services. I'm new to SQL server RS. So if you have any code snippet,
please send. It will very help full for me.
Thanks and regards
SanthamurthyHi,
Are you asking dynamic chart type changing?
I dont think you are asking from layout (while designing) "chart type" since
it is very simple.
Regards
Amarnath
"Santhamurthy" wrote:
> Hi
> Do any one have idea on how to change the chart type in Reporting
> Services. I'm new to SQL server RS. So if you have any code snippet,
> please send. It will very help full for me.
> Thanks and regards
> Santhamurthy
>

Changing a Connection in DTS Local packages

Many of our Local packages in Data Transformation Services has the job of
copying data from one database on one server to another database on another
server. The package typically has 2 Connections defined.
Now we want to move the "destination" database to a new server. Is there any
way this can be done without editing each package in the "Design Package"
GUI
Thanks in advance
Henrik.You can use UDL files for the connection; you can change the properties
programmatically; you can use the Dynamic Properties task to change settings
at runtime.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Henrik Hjøllund Hansen" <hh@.dlf.dk> wrote in message
news:bicqd4$2hmp$1@.news.cybercity.dk...
> Many of our Local packages in Data Transformation Services has the job of
> copying data from one database on one server to another database on
another
> server. The package typically has 2 Connections defined.
> Now we want to move the "destination" database to a new server. Is there
any
> way this can be done without editing each package in the "Design Package"
> GUI
>
> Thanks in advance
>
> Henrik.
>
>

Changes related to PDF in SQL Server 2005 Reporting Services

Hi All,

I am working on SQL Server 2005 reporting services. In reports I am required to make changes related to exporting report to PDF. Following are those changes:

1) Change PDF export page format to letter from legal

2) Fix page break to ensure that all details related to a specific issue are viewable on the same page

In reports exporting is done through the control given by services itself. So can any one please guide me regarding how this changes can be done. Please help me ASAP...

Thanks....

For (1), it seems like you should be able to just change the page size of the report. Or do you need to change the size just for PDF? If you are using URL access or SOAP, you can specify page sizes via device info settings. See http://msdn2.microsoft.com/en-us/library/ms154682.aspx

For (2), you will need to modify the RDL; try looking into the KeepTogether and RepeatWith settings on report items.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp|||

With regard to page breaks I can see a KeepTogether property that refers to the whole report but not to individual groups. There is no RepeatWith setting within my rdl (SQL2005).

I would like my report to group on a particular field but don't want it to break before or after the report header / footer. Any idea how I can do this?

Changes in SP1 for SSRS 2005

Any link for all the changes in SQL Server 2005 Reporting Services in SP1?

http://support.microsoft.com/kb/916940

changed my login password??

I changed my login password to my computer, now I can't start my SQL
services. It says it can't start because of login falure?
--Nevermind. I figured it out
--|||You need to change password for MSSQLSERVER and SQLSERVERAGENT services.
Go to Computer management console and for this services change password on
the LogOn tab.
I hope this will help.
Ana
"DaveF" <dfetrow@.geodecisions.com> wrote in message
news:OmVPiGoNEHA.2708@.TK2MSFTNGP10.phx.gbl...
> I changed my login password to my computer, now I can't start my SQL
> services. It says it can't start because of login falure?
> --
>
>

Change username

I'm using the Forms Authentication with Reporting Services, and I have a
situation where i need to change a username for a user. The user already has
lots permissions to different reports, etc... When I change the username in
my UserAccounts DB and the ReportServer DB it logs in fine, but shows no
objects.
When I view the reports via an admin account, it shows the security still
lists the old username, before I changed it.
Any ideas on how to successfully change a username in reporting services?
Thanks,
-Jonathan
Please post this to the SQL Server Reporting Services newsgroup:
reportingsvcs
Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.
This posting is provided "as is" with no warranties and confers no rights.

Change the username in Active Directory

We use extended properties of Active Directory to filter the data in reporting services throw a web services. We send the userid (User!UserId) to the webservices and retrieve some information about the user.
But if we change the name of one user (rename not recreate), he lost all this properties. When try to execute a report show an error:

Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) I know this issue is in the border of reporting services, but we have spent a lot of time without results and we need any help.

Thanks in advance

How are you doing your rename? Because that's where your issue is <s>.

If you're doing it through some GUI interface and that interface doesn't transfer your extended properties on a rename, then that interface has a bug in it <sigh>.

I do some AD coding but don't have an example I can throw in here. Basically, when any consumer queries AD for a user object, it is allowed to say what properties it's interested in retrieving. If it doesn't know about yours and doesn't retrieve them, it probably doesn't clone them along with the rest of the object. (I think, under the covers, a rename likely does a clone-and-delete.)

So you have to write something that does know about your extended properties and write a better rename...

>L<

|||We rename the user in Active directory but i supposed that in some part of reporting services store the previous username, guid or something to refers to the old user. When we use the user!userID functions, reporting services get the old value instead the new value.

Our process is:
We have two parameters, one with the user and other with the information to retrieve and send to another queries. Send this two parameters to the web services and retrieve a parameter (a custom property defined in AD) to send in another query.

We use directly in web browser the reporting services. And it is the default configuration of report server web.

Thanks for your patience

|||

>>We rename the user in Active directory

I know that's what you did. I asked you *how* you did this (through what interface).

But, yes, if you're getting the old version when you look at user!userID, it doesn't matter.

I don't see why the report server would be caching the previous user name etc, unless you have put this information in as the credentials of the user to run the report in the report configuration?

Could this possibly be an AD refresh type of problem, instead? IOW, you do the rename and all the domain servers don't know about it?

>L<

Change the SQL Server or SQL Server Agent Service account

Good afternoon,
I was to make the exchange of the account that go up the services of the SQL
Server and the SQL Agent.
Of the SQL Server it was modified without problems, to put when I was to
modify of the SQL Agent I received the following error:
Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
and I do not obtain to change the account.
Anybody has some ideia of that to make?
Raphael Soares
where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
need some permissions.
Search Books Online for "level token", and you will find information about service accounts and
needed permissions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> Good afternoon,
> I was to make the exchange of the account that go up the services of the SQL
> Server and the SQL Agent.
> Of the SQL Server it was modified without problems, to put when I was to
> modify of the SQL Agent I received the following error:
> Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> and I do not obtain to change the account.
> Anybody has some ideia of that to make?
> Raphael Soares
|||Tibor
I'm having the same problem that Raphael has.
In my case the account I'm trying to use to start the SQL Server Agent
service, belongs to the local administrators group at the database server,
the account is just a domain account that belongs to Domain users.
I'm trying to change this in the Enterprise Manager
This server has enabled the Terminal services in Application server mode.
Which permission I'm lacking?
It is not supposed that if I do it from Enterprise Manager I'm avoiding to
give manually the permissions that the Books Online article talks about?
Thanks
Guillermo
"Tibor Karaszi" wrote:

> where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
> need some permissions.
> Search Books Online for "level token", and you will find information about service accounts and
> needed permissions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
> news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
>
>

Change the SQL Server or SQL Server Agent Service account

Good afternoon,
I was to make the exchange of the account that go up the services of the SQL
Server and the SQL Agent.
Of the SQL Server it was modified without problems, to put when I was to
modify of the SQL Agent I received the following error:
Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
and I do not obtain to change the account.
Anybody has some ideia of that to make?
Raphael Soareswhere did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
need some permissions.
Search Books Online for "level token", and you will find information about service accounts and
needed permissions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> Good afternoon,
> I was to make the exchange of the account that go up the services of the SQL
> Server and the SQL Agent.
> Of the SQL Server it was modified without problems, to put when I was to
> modify of the SQL Agent I received the following error:
> Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> and I do not obtain to change the account.
> Anybody has some ideia of that to make?
> Raphael Soares|||Tibor
I'm having the same problem that Raphael has.
In my case the account I'm trying to use to start the SQL Server Agent
service, belongs to the local administrators group at the database server,
the account is just a domain account that belongs to Domain users.
I'm trying to change this in the Enterprise Manager
This server has enabled the Terminal services in Application server mode.
Which permission I'm lacking?
It is not supposed that if I do it from Enterprise Manager I'm avoiding to
give manually the permissions that the Books Online article talks about?
Thanks
Guillermo
"Tibor Karaszi" wrote:
> where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
> need some permissions.
> Search Books Online for "level token", and you will find information about service accounts and
> needed permissions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
> news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> > Good afternoon,
> > I was to make the exchange of the account that go up the services of the SQL
> > Server and the SQL Agent.
> > Of the SQL Server it was modified without problems, to put when I was to
> > modify of the SQL Agent I received the following error:
> > Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> > and I do not obtain to change the account.
> >
> > Anybody has some ideia of that to make?
> >
> > Raphael Soares
>
>

Change the Sort Order

Hi,
I hope than somebody can explain me why the report order on the reporting
services desing (Visual Studio), is differen than the query sort order.
Normal SQL Query
1) AA
2) AB
3) A1
4) 1A
Visual Studio Report Design
1) 1A
2) A1
3) AA
4) AB
Can some body help me to change that setting on the
Thanksplease... help me !!!!.....
Edman wrote:
>Hi,
>I hope than somebody can explain me why the report order on the reporting
>services desing (Visual Studio), is differen than the query sort order.
>Normal SQL Query
>1) AA
>2) AB
>3) A1
>4) 1A
> Visual Studio Report Design
>1) 1A
>2) A1
>3) AA
>4) AB
>Can some body help me to change that setting on the
>Thanks
Message posted via http://www.sqlmonster.com|||I almost never set the sort in RS, I set the sort order in my query.
Sometimes I can't do this but when I can, I do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Edman via SQLMonster.com" <u14374@.uwe> wrote in message
news:554a9135a7fd0@.uwe...
> please... help me !!!!.....
> Edman wrote:
>>Hi,
>>I hope than somebody can explain me why the report order on the reporting
>>services desing (Visual Studio), is differen than the query sort order.
>>Normal SQL Query
>>1) AA
>>2) AB
>>3) A1
>>4) 1A
>> Visual Studio Report Design
>>1) 1A
>>2) A1
>>3) AA
>>4) AB
>>Can some body help me to change that setting on the
>>Thanks
>
> --
> Message posted via http://www.sqlmonster.com

change the look of Report Manager

I would like to change the look of the Report Manager. I have Reporting
Services on both developement and production servers. I would like to
be able to change the color or font etc. so that I can tell without
having to look in the address box to figure out what server I am on.
Is there a value I can change somewhere that will do this for me?Hi Lou,
you could just edit the style sheet
\Reporting Services\ReportManager\Styles\ReportingServices.css
regards
Matt
"Lou" <lbonnes@.yahoo.com> wrote in message
news:1105847715.370619.296730@.f14g2000cwb.googlegroups.com...
> I would like to change the look of the Report Manager. I have Reporting
> Services on both developement and production servers. I would like to
> be able to change the color or font etc. so that I can tell without
> having to look in the address box to figure out what server I am on.
> Is there a value I can change somewhere that will do this for me?
>

Change the forecolor of the field on the report.

Hi,

I trying to change the color of the text based on a condition using sql server 2005 reporting services. Some thing like this.IIF(Fields!OrderYear.Value < 2000,"Red","Black"). But not able to achieve this.. how can I do that?

Where are you putting this expression? Make sure the expression is on the font color property, not on value.

|||

Yes, you are right. Thank You.

Change the displayed name in the Series Group for a chart

Hi,
I created a chart in sql reporting services. I added a series group to it.
Now what i want to do is to dispaly different series names when the chart is
viewed . For example, in my database, I have Region code as numbers. I have
used this Region Code as the Series group. What i want to do is, ...
if (RegionCode ==01
{
//the series group should display North
}
Similarly for other region codes. Is it possible? & how?
Thanks
pmudYes this is possible through the Label expression of a chart series
grouping.
* right-click on the chart and open the chart properties dialog
* go to the Data tab and edit the series grouping
* the grouping dialog has a grouping expression and a label expression
below. If no label expression is set, it will take the group expression
value as label by default.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:13D0A129-DEAA-4C05-9736-04E3104A9935@.microsoft.com...
> Hi,
> I created a chart in sql reporting services. I added a series group to it.
> Now what i want to do is to dispaly different series names when the chart
> is
> viewed . For example, in my database, I have Region code as numbers. I
> have
> used this Region Code as the Series group. What i want to do is, ...
> if (RegionCode ==01
> {
> //the series group should display North
> }
> Similarly for other region codes. Is it possible? & how?
> Thanks
> pmud

change the default navigation bar

Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.Sorry for the double posting..... :-(

Change the default navigation bar

Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.&rc:Toolbar=false in the url, removes it
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> Is it possible to change the default navigation bar that appears in
> Reporting Services?
> The Navigation bar that allows, page movement, viewing size, Export
> etc.
>|||Thanks for the tip, but I need to create my own now, any ideas?|||I don't think there's a way. There could be a way to change the colors and
fonts, but I don't think you can change the structure.
And it's all messed up for firefox, or netscape. I check the browser before
I call the reports, and turn the toolbar off, if it's not IE.
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112871211.962325.310910@.l41g2000cwc.googlegroups.com...
> Thanks for the tip, but I need to create my own now, any ideas?
>|||"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
hmm... that doesn't seem to work for me. my url reads:
http://MyServer/Reports/Pages/Report.aspx?ItemPath=%2fMy+Report&rc:Toolbar=False&rc:Parameters=false
but both the toolbar and the parameters pane show up just the same... what
am I doing wrong? also, how can I specify that the toolbar not be displayed
after the user presses the "View Report" button (since I obviously don't have
control over the URL at that point)?|||but I just want to remove the navigation bar, and keep the parameters bar ...
the URL:
..?&rc:toolbar=false&rc:parameters=true
doesnt work ...
How do it ?...
"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
> "Bryan Avery" <b_avery@.yahoo.com> wrote in message
> news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> > Is it possible to change the default navigation bar that appears in
> > Reporting Services?
> >
> > The Navigation bar that allows, page movement, viewing size, Export
> > etc.
> >
>
>

Change ReportServer database

We have installed Reporting Services on a new server using the local
database. Now we want to point to a ReportServer database on another
database server.
How can we change the server used for the ReportServer database to point to
a different server?
Thanks
--
RickIn SQL 2005:
Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
Tools/Reporting Services Configuration
This will open the Reporting Services Configuration Manager. Choose
"Database Setup" from the left column and set the server and database name.
In SQL 2000 run the following (see
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
-p<password>
<ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
authentication of the service account SQLRS will use to connect to the
ReportServer database <UserName> & <Password> is the name/password of the
service account mentioned above.
Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
rsconfig can be found in the C:\Program Files\Microsoft SQL
Server\80\Tools\Binn folder.
This assumes that the report services db is a restore of the original. If
it's different then it get's a little more complicated as encryption keys and
versions need to match.
"Rick" wrote:
> We have installed Reporting Services on a new server using the local
> database. Now we want to point to a ReportServer database on another
> database server.
> How can we change the server used for the ReportServer database to point to
> a different server?
> Thanks
> --
> Rick|||Thanks.
--
Rick
"Limey" wrote:
> In SQL 2005:
> Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
> Tools/Reporting Services Configuration
> This will open the Reporting Services Configuration Manager. Choose
> "Database Setup" from the left column and set the server and database name.
> In SQL 2000 run the following (see
> http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
> rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
> -p<password>
> <ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
> authentication of the service account SQLRS will use to connect to the
> ReportServer database <UserName> & <Password> is the name/password of the
> service account mentioned above.
> Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
> rsconfig can be found in the C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn folder.
> This assumes that the report services db is a restore of the original. If
> it's different then it get's a little more complicated as encryption keys and
> versions need to match.
>
>
> "Rick" wrote:
> > We have installed Reporting Services on a new server using the local
> > database. Now we want to point to a ReportServer database on another
> > database server.
> >
> > How can we change the server used for the ReportServer database to point to
> > a different server?
> >
> > Thanks
> > --
> > Rick

Change Reporting Services server name

I renamed the computer name for the server running both SQL Server and
Reporting Services. I used sp_dropserver and sp_addserver to correct the
servername for SQL Server, but now I cannot use the Management Studio to
connect to the Reporting Server. I am running SQL 2005. Any ideas how to
fix the name without re-installing?
Thanks,
MattThe Reporting Services Configuration Manager tool has a Database Setup tab
that you can use to set the server name for the ReportServer database
repository.
Steve MunLeeuw
"Matthew Bando" <MatthewBando@.discussions.microsoft.com> wrote in message
news:D3CF59E6-B63C-4B7D-9C0B-DED2357DF561@.microsoft.com...
>I renamed the computer name for the server running both SQL Server and
> Reporting Services. I used sp_dropserver and sp_addserver to correct the
> servername for SQL Server, but now I cannot use the Management Studio to
> connect to the Reporting Server. I am running SQL 2005. Any ideas how to
> fix the name without re-installing?
> Thanks,
> Matt

change reporting services location (2000)

hi,
our reporting services DB moved and I need to tell the report manager where to find it
isn't it in a config file somewhere, i can't find it?
do i have to reinstall?RSConfig -c -s Server name -d Reporting Services database name -a Sql|Windows -u User name -p User password

nevermind guys|||hrmm it still wont work, says it cant find the db

ugh...|||ok im talking to myself...

now a different microsoft sites says i cannot specify a named instance with this utility... but it let me install it like that (go figure)

now what, i guess i have to reinstall|||hrmm it still wont work, says it cant find the db

ugh...
See the Report Server database can be installed on only one instance of SQL Server per physical database sever computer. The database need not reside on the local Report Server computer but the server must be a member of the Windows domain or a server trusted by the domain.So somebody has moved it and if your reportings were okay so you can easily understand its on the member or a trusted domain.If your reports are not working its better to install it again.|||the ip address of the server changed, so really i shouldnt have to do anything - BUT, they did not open the port that allows dynamic ports to be found (UDP 1434). so i have to redo it and specify the port number i.e. Server\Instance, Port.

the ms website says rsconfig does not support named instances, but the installation GUI did, so that does not make sense

i do not want to reinstall it, it will be a pain, the rsconfig utility should support named instances otherwise what is the point

Change reporting services default URL (From http://server/reports to http://CompanyReports)

I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.

I wouldn't try to change the reporting services default URL.

Instead, I would create an alias or....

Name the server that hosts reporting services "CompanyReports". Then set report manager on that server to be the default website. Then when you navigate to http://CompanyReports from any PC on your network, you will see the report manager on that server.