|
|||||
|
Alternate Background Color in Tabular Report: Alternate background color of rows in a table make it easier to read horizontally. Also it makes report look and feel better. This is very common but simple task to achieve in SSRS report using expression. Select the detail row of the data table in the layout tab. Go to property window and select . . . → Read More: SSRS 2008 Hosting :: Conditional Formatting in SSRS 2008 RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer. RDL and RDLC are defined by an XML schema called the Report Definition Language The C stands for Client-side processing. RDL stands for Report Definition Language. Limitations of ReportViewer control: Unlike the Report Server the . . . → Read More: SQL 2005 Hosting :: Using Report Service and Server Business Intelligence Development Do you ever come across a requirement where you need to use user defined colors instead of default colors in a chart (for example Pie Chart). In this article, I’ll explain how to create a Custom Palette and how to use that palette in a Pie Chart. In the above screen-shot, I am using color Blue, Red, Teal and Gold for . . . → Read More: SSRS 2008 Hosting :: Adding Custom Color in SSRS Chart Reports In this article, I am going to explain how to create a Recursive Hierarchy Group in SSRS 2008 to display hierarchical levels. This is helpful when we want to display hierarchical data in a report e.g. employees in an organizational chart as shown below: Pre-requisites for this article: SQL Server 2008 along with SSRS installed Applies to: - Internet Information Services 7.o (IIS7) Symptoms: - Unable to render ReportViewer on ASP.NET Web pages while running on IIS7. With all the new features in SQL 2008 R2, here are the major ones getting all the press: PowerPivot There is so much written on the ones above, I wanted to concentrate on talking about other new features in SQL 2008 R2. So, in no particular order: 1. SMB support – . . . → Read More: SQL 2008 R2 Hosting – Top IMPORTANT Features in SQL 2008 R2 Today, I have faced a very simple but still annoying problem. I was asked by a client that queries are not working correctly with given WHERE clause. Actually database was design as case insensitive but SOMEHOW on application side there were some business logics which client needs case sensitive inputs (Just like password) and comparisons. Here is . . . → Read More: SQL 2008 R2 Hosting :: Working with Case Insensitive Data In Reporting Services 2008, it is possible to export to Excel using the Visual Studio interface and the Reporting Services browser. However, what about the case where you have a complex report with numerous tablixes, matrices and so on, and want to preserve these in the target Excel Workbook? You can see this trick: 1. Take the . . . → Read More: SSRS 2008 Hosting :: Preserving Tablixes on Export from SSRS 2008 to Excel SQL Server Reporting Services is an incredibly full featured reporting tool. An often asked question though is “How can I use Reporting Services without setting up a full SQL Server just to run Reporting Services?” Fortunately the folks at Microsoft thought of this, and created a version of Reporting Services that runs in Local, or what Microsoft . . . → Read More: SSRS 2008 Hosting :: Using a Local Reporting Services 2008 Report with an ADO.NET Data Set Problem: “Index was out of range. Must be non-negative and less than the size of the collection. Parameter . . . → Read More: SSRS 2008 Hosting :: Error – “Index was out of range…” |
|
|
|||
|
Copyright © 2012 SQL 2008 Hosting News (SuperBlogAds Network) - All Rights Reserved |
|||||
