.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SSRS 2008 how to define a custom legend and display colors of legend in table

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server

How would i go about setting the background color in a table to a legend series color in a chart control?



View Complete Post

More Related Resource Links

Legend Display Setting in SSRS 2008


In SSRS 2008 when you have only one series , it displays the name of series in legend series 1. But when you have more than one series group it displays with the true series name in legend box. However, in SSRS 2005 for the same report ,legend box displays the true series name whether I have one or many series groups. Is there any way to control how legend displays the selected series name insteady of  "series 1" in SSRS 2008? What I want to do is replacing "series 1" with "Quarter1" in legend box in SSRS 2008.

Below is how legend displays series group in SSRS 2005 and SSRS 2008 respectively,


Quarter 1

Quarter 2

SSRS 2005                                            

How to align data in Chart legend in SSRS 2008?

Hi,I have created a chart of type 3D pie.  I put a String field for Category and Sum(numeric field) for Data.I wanted to show the legend as Category field and Data field and it's displaying as i set.Now how to make alignment of Data in legend, so that my numeric fields should align Right and String field should align Left.  I can make whole legend alignment but I want to make only the numeric field in the legend to align Right.Is it possible or there any work around?Please let me know.

PIvot Table in SSRS 2008

Hi All, Is there any data Region (Pivot) in SSRS 2008 or higher version? Our requirement is to show the report like excel pivot gererated from a OLAP Cube where we can select or unselect any dimesion attribute or measures. Thanks, IndiaSQl  

SSRS 2008 Custom Authentication works when using ReportServer url but not when report manager url is

Hi, I am using SSRS 2008 with Custom security extension for authentication. The extension is developed in c#. I have placed the dll under report server bin and report manager bin directory and the logon,login pages under appropriate directory. My reports manager url is http://localhost:port/Reports and my reports server url is http://localhost:port/ReportServer. When I try to login through reports manager url, I am getting 'login failed' error message from the dll. But when I try to login using reports server url, it works. I have also set 'FullTrust' named permission set in RSMgrPolicy.config . <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> < IMembershipCondition class = " ZoneMembershipCondition " version = " 1 " Zone = " MyComputer " /> Any suggestions please!   Thanks!

Can I change the location SSRS 2008 uses for custom assemblies?

According to all the documentation or articles I've read, in order for an SSRS 2008 report to use a custom assembly the DLL must be copied to 1) For local development on my box:  C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PublicAssemblies 2) For server deployment: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER2008\Reporting Services\ReportServer\bin  I've got this all working just fine. However, I have a need to put this DLL file in a different location.  Is this possible?  Is there a way to reconfigure the server installation so that it looks for custom assemblies in a different location?  Is there something I can do in the SSRS report itself to force it to look for the custom assembly in a different location?

SSRS 2008 - Fixed headers while scrolling - works fine for Matrix - but not for Table??!!


I have this feature working fine for matrix, but it does not work as expected for Table (Tablix).

I tried all over, and setting both check boxes in the 'Tablix Properties' dialog page 'Repeat header rows on each page' and 'Header should remain visible while scrolling' for both row header and column header, but none of it is working. Am I missing something?

In the properties table (F4) for text box of tablix, under 'Other' there is 'RepeatWith' - none / tablix: what is this used for? I tried this property also but I cannot get the headers fixed / visible while scrolling. I cannot get the 'column headers' repeat on each page of the report. Very frustrating...

Does anyone face similar issue? Can anyone help please? Do I need any update / download any fix? For now I have the following version installed for Visual Studio 2k8:
Microsoft SQL Server Reporting Services Designers Version 10.0.1600.22


Trouble Using More Than One LIKE Operator in a Table Filter in SSRS 2008


Hello All,

I'm having what I'm hoping will be a simple issue -

My co-worker has created a large report which contains several tables in SSRS 2008.  Each table is tied to one dataset, yet only certain data can be returned to each respective table.  Right now he's applying filters at the table-level behind each table, however as you can imagine this is not efficient because there is a LOT of data returning for this report. 

I'll try and give a simplified example -

There are two tables in the report body - one for containing products relating to both Cats and Dogs, and one for containing products relating to Birds.   Each product starts with the name of the specific animal - for example "Cats-Mouse Toy", "Dogs-Frisbee", "Birds-Rubber_Leaf".  

Now I need to somehow filter out each product so that they go to their proper tables.  As mentioned above, my co-worker was creating a specific filter for each product, but this is proving to be inefficient.  For example, there are 52 different products for Birds alone.  That would mean 52 different filter entries for each product.  What I would like to do is use the LIKE operator but i'm not getting the results I want on the first table.

So, on the first table I need something like:  =(Fields!Products.value LIKE &

.NET 4.0 custom assemblies in SSRS 2008

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1593833729 1073750107 16 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} p {mso-style-noshow:yes; mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-s

Embedded HTML using
to replace tags in ssrs 2008   

After doing various amounts of research and testing I need to post a question here. 

I am using an html editor to format html and data (for reports) and then using reporting services to render the html harnessing the report server to view, export, and print. 

As already many of you know around here you can set an ssrs table cell to “HTML – Interpret HTML tags as styles”.  Also many of you know that this functionality does not accept <table><tr><td></td></tr></table> tags.  However, the documentation says it support <div> tags. Yet when I try using div tags with the appropriate styles for creating tables this does not work either.  So if ssrs handles <div> tags could you please tell me a complete list of style attributes it handles as well?

Table Header (Title) Row need to repeat on each page. How to do this in SSRS 2008 & above?



I have a requirement, where 1st row (Hearder) should repeat on each page.

For Example:



Experience in Years




So I want to repeat


Can I set a table to display 20 rows and then scroll instead of expanding down the page? (SSRS 2005


Can I set a table to display 20 rows and then scroll instead of expanding down several page? (SSRS 2005 )

Display message box in SSRS 2008 R2 report


I'm trying to figure out how to display a message box in a ssrs 2008 r2 report. I have custome code that validates a couple of parameters, and I want to display an error message if a user enters an incorrect parameter. I included 'system.windows.forms' as a reference in my report, and tried to use 'system.windows.forms.messagebox.show(errormsg) but I keep getting an error. I created a hidden parameter that references the custom code.

Any help would be greatly appreciated.

Thanks in advance.


SSRS Hide one data value label in chart legend

Is it possible  to hide one value in the legend? I've got a stacked bar chart, but there's one value that I don't want to display in the Legend. Is it possible to hide this particular color and label in the legend?


Edit Table in SSRS 2008


Hi Experts,

We were having table with just ONE DATA COLUMN ( it means no Header and nor Footer), and we were having two row groups on this table.

Now our user's request to some "Total" at the bottom, and I'm trying to edit the table were I can add Table Footer but I'm unable to do the same, Can anybody out to do?

Even I tried by "Insert Row" -> Outside Group - Below but it is still inserting as a "Group level footer" rather I want as a Table level footer.

Long question short, how to edit table to add Table Header or Footer.



Custom display name for a table in dynamic data.


I know this has been asked before but I am working in VB and don't know C#. I want to display a custom name for my tables on a dynamic data page. So far I have located the name of the object in my LinqSQL data context which is SectionTable. When displayed I want SectionTable to appear as Section.

I know something should go in the namechange class, but I don't know what! I have got this far:


Imports Microsoft.VisualBasic

Imports System.ComponentModel.DataAnnotations



Partial Public Class SectionTable

End Class

Public Class namechange

End Class


Thanks in advance.

SQLServer 2008 R2 Reporting Service websevice url does not display with custom authentication



I have installed SQLServer2008R2(CUD3) (64bits on Windows7) Reporting Service with custom authentication.  I can log in to the report server and report manager and everything appears fine, but the webservice url: http://myhost/ReportServer/ReportService2005.asmx no longer works (The webservice url did display before I put int custom authentication).  I got a html back with error message.

This webservice url used to be not protected.  I wonder if this is something changed in 2008R2 and it is a bug, or something I did not do it right.


Thanks for any help!

       // some info here


    <body bgcolor="white">

            <span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

            <h2> <i>Access is denied.</i> </h2></span>

            <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "

Display column from child table. Possible ?



I'am using dnamic entity with EF4. On a list page of a table, I would like to display a column containing information from a child table of the current element. Sample :

Order List :

Order Data | Required Date | Shipped Date | etc... | ... | Customer Name (foreign key with tostring() method override) | Customer Postal Code (Column that I want to add) |

I don't known how to do that. Is it possible ? Maybe I have to to create my own Metadata proxy that will add dynamicly a column on the MetaColumn list of the table.

Does someone have an easier or better idea ?

Thank you for any help.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend