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
>

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

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 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 Report Manager Interface

Hello,
I was hoping to modify the default interface for the Report Manager to feel
more like our other online reporting pages. I found a few articles about
creating asp.net web applications and all that, but was hoping just to change
the color scheme, place an image somewhere, etc...
is this possible? if so, how easy is it and are there any good resources out
there?
Thanks!
--
Ben Sullins
Our Vacation Store
http://ovstravelfolio.com/Hi Ben,
You can edit the stylesheet that's located
<ReportManagerRoot>/Styles/ReportingServices.css (with a default
installation the path should be "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
Services\ReportManager\Styles\ReportingServices.css") to change the
color-scheme, fonts, etc...
Editing the physical layout of the portal isn't that easy and not very
practical. You would most likely need to replace the Pages.aspx page and
override the Pages class where you would inject / replace the layout
changes. You can however replace the default images and icons that are
already present in the layout. These are located in
<ReportManagerRoot>/images.
Hope this was of some help.
-Christian
Ben Sullins wrote:
> Hello,
> I was hoping to modify the default interface for the Report Manager to feel
> more like our other online reporting pages. I found a few articles about
> creating asp.net web applications and all that, but was hoping just to change
> the color scheme, place an image somewhere, etc...
> is this possible? if so, how easy is it and are there any good resources out
> there?
> Thanks!
> --
> Ben Sullins
> Our Vacation Store
> http://ovstravelfolio.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 the color of the chart items

Does anybody know how to change the color of the chart items? I dont want to
use the default palette that the reporting have. I want to change the color
of the bars and the pie chart.SQL Server 2000 Reporting Services SP1 added support in this area.
Using the Chart Properties dialog you will need to navigate to
Data Tab : Values : Edit
Edit Chart Value Dialog : Appearance Tab : Series Style button
Style Properties dialog
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nelson" <Nelson@.discussions.microsoft.com> wrote in message
news:4A94A89C-9297-4508-AF08-060CB3CC86E7@.microsoft.com...
> Does anybody know how to change the color of the chart items? I dont want
> to
> use the default palette that the reporting have. I want to change the
> color
> of the bars and the pie chart.|||Bruce,
I followed the navigation steps that you mentioned, but still
couldnt figure out what next to do in order to define explicit color to
the series, rather than allowing it to be defaulted which it is doing
now.
I have downloaded the SP1 and installed the same, but still not sure
how to implement individual color of my choice,
An, earlier response is appriciated.
Thanks,|||If you have not done yet, please read this section in the SP1 readme about
using colors in charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
You may also search this newsgroup for chart color related posting, e.g.:
*
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c8620b23-0340-4d35-a154-4a797ecfab2f&sloc=en-us
*
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=73b9ddf6-58a7-4088-955b-9a03a4d56efa&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Srini" <turlsri1@.yahoo.com> wrote in message
news:1103664443.478130.45620@.c13g2000cwb.googlegroups.com...
> Bruce,
> I followed the navigation steps that you mentioned, but still
> couldnt figure out what next to do in order to define explicit color to
> the series, rather than allowing it to be defaulted which it is doing
> now.
> I have downloaded the SP1 and installed the same, but still not sure
> how to implement individual color of my choice,
> An, earlier response is appriciated.
> Thanks,
>|||Thanks,
I appriciate the early response, will go through the
articles.

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.

Change report server database

I install reporting service on 2 machines. Each RS has it's own report
server database. e.g. A_ReportServer for machine A and B_ReportServer for
machine B. Can I dynamically change the report server database ? i.e.
Machine A point to B_ReportServer database. If yes, how can I do this ?You can redirect A_ReportServer to point to Database B by running the
rsconfig.exe utility. Please refer to the following link for more
information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_7oft.asp
If your looking for load balancing or failover support as in load balancing
of the web servers or Sql Server failover that is available with the
enterprise edition. Check the BOL for more info about how to configure.
"May Liu" wrote:
> I install reporting service on 2 machines. Each RS has it's own report
> server database. e.g. A_ReportServer for machine A and B_ReportServer for
> machine B. Can I dynamically change the report server database ? i.e.
> Machine A point to B_ReportServer database. If yes, how can I do this ?

Change Report Datasource

I have a c# assembly that uses the reporting services webservice to render reports.

Every user accessing this component needs to render this report passing different datasource to it in order to browse data in different databases (es.: test databse server, production database server)

Is it possible to create a linked report and change the connection only to it?

Other suggestions?

Thanks

Hi,

you can change the connection string property depending on the user (role or something you want to differentiate with). I don′t know if that is actually a solution for your problem but this is worth a try. using an expression could be something like

="Data Source=" & IIF(SomeExpression,"TestServer","ProductionServer") (...Rest of the connection string here...)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Yes, it works great with reporting services 2005, but i forgot to tell you that i have to do the same with reporting services 2000...that's the problem. Is it possible under 2000 to do the same thing? If "No", are there other ways to programmatically call a report with dinamyc conection string.

The only solution i've found is as follows:

==========

rs.render --> obtain the byte stream from REPORT_1

rs.CreateReport --> create REPORT_2 using the stream of REPORT_1

rs.GetReportDataSources(REPORT_2) --> to obtain datasource of REPORT_2

Modify the property ".connectString" of this DataSourceDefinition

rs.render to render the newly created report

finally delete the new report.

===================

In this solution, copying the report slows down execution time i suppose...... Another solution might be to directly modify datasourcedefinition of REPORT_1 but if two or more users try to call the same report with different connectionstrings i think there might be problems.

Any suggestions?

|||This is something I would like to do. Where exactly would I enter that expression? In VS Report Designer, when I create a new Data Source, the "fx" button is grayed out. Is that where I should be entering this expression? Is there a reason why the builder is disabled?

Thanks,|||

With Reporting Services 2005, open the report in the solution and switch from design to code view (xml structure) and modify connectstring node as follows:

<ConnectString>="data source=" &amp; Parameters!ServerName.Value &amp; ";initial catalog=Northwind;"</ConnectString>

You also have to create the parameter "ServerName".

If you want, change also the Catalog Name using another parameter...

With reporting services 2000 you cannot do the same...try reading my code example reading abow...that works fine for me