Skip to main content

Posts

Showing posts with the label SQL Server Reporting services

How to Rename a SSRS Report Project Solution

How to Rename a SSRS Report Project Solution: Overview: As a developer many times we come across scenarios where we have created a Report Project solution with a specific name e.g. "Reports_Dev". after some time say when the development is complete, we might think to rename the same Project solution to "Reports_Production" Let’s see how to do it... Solution: 1.         Create a copy of the SSRS Project Solution 2.         Now find the following items: Solution Folder Name:  Reports_Development Files in this Folder:                 Reports_Development.sln  (this a .sln file)                 Reports_Development.suo  (this is a hidden .suo file)            ...

SSRS Reports - Rendering Format Support in SQL Server Reporting Services

SQL Server Reporting Services 2012 has added new rendering options for Excel and Word to support the office 2007 -2010: Now it Supports for new file formats: ·           Excel renders for  Excel 2007-2010 (*.xlsx) o      For more info check:  http://msdn.microsoft.com/en-us/library/dd255234(v=sql.110).aspx ·           Word render for  Word 2007-2010 (*.docx) o      For more info check:  http://msdn.microsoft.com/en-us/library/dd283105(v=sql.110).aspx Below are new features with this new file format support: 1.         Feature equivalence with existing word and excel renders 2.         ZIP-compressed files – now easy to export and share the files 3.         Larger worksheets in Excel ·        ...

SSRS Best Pracitice - 3

Page Setup: This Property have a very high importance when we need to print the report or export the report to the hard page break formats like PDF, word etc. For every Report as a best practice we should do proper page set so that the report items are properly displayed while printing or exporting the PDF or word etc. Let’s see an example how to do it: 1. Enable the Ruler in the design 2. Open the Report Properties 3. By default the page size is width-8.5in Height: 11in, now you have to set the page size as following: Take the width of the design using ruler and add the margin into that and set this value as the width of the page. E.g. width in the design is showing as 15in and margin is set at 1in left and right  so total width of the page is 17in (15in+1in+1in). Set this amount in the page width and when you run the report it will display the objects properly on the PDF or Print etc. View of the report before setting the page setup in the report propert...

SSRS Best Pracitice - 2

Shared Data Source: As a best Practice we should use a Share data source in all our Reports as far as possible. benifits of doing this are: 1. We can Move all our Reports from one environment to another with less efforts. 2. No Need to concern about handling so many Data sources for the Reports. 3. Shared Data source is easy to handle in the Reports, Just change the Database or server Name and all your Reports will pointing to the new Data. 4. Coding Standards also will take few efforts for the Data Source. 5. Less Confusion about the Source Data when using the Shared Data Source i.e from which data base my reports are fetching data? etc. Happy Learning!

SSRS Best Practice - 1

Which Report Link we can share to the End-Users: Once we have done with the coding and testing for the Report, it is ready for the deployment to the Report server and will be available to share the link with the End-users. We can share a Report manager report link with the end-user or we can share a Report viewer link. Let’s see how these two links works: Report Manager Link e.g http://%3c%3cservername./Reports/Pages/Report.aspx?ItemPath=%2f<FolderName>%2f<ReportName > Report viewer link e.g http://%3c%3cservername%3e%3e/ReportServer/Pages/ReportViewer.aspx?%2f<FolderName>%2f<ReportName>&rs:Command=Render After analyzing these two snapshot for the same report open from the Report Manager and Report Viewer following are the observations: 1.  in the Report manager Report link we are able to see the links like Home, folders etc. but in the Report Viewer Report link these links are not visible on the report...

SSRS Reports - How to Create Static Rows in a Matrix in SSRS?

Today one of my team members asked me about how to create a matrix in which the rows will remain static/constant and the column group will grow as per the data available. SQL Server Reporting Services 1. Create a data set to get the required data for the matrix. 2. Drag a matrix object on the report body. 3. Add the number of required rows to outside the row group  (This is the main trick for creating the static rows in the matrix) 4. Delete the row group detail row from the matrix 5. Add the labels to the row lines headers, add the column group values and data values in the matrix 6. Run the Report and your Matrix is ready with Static Rows! Happy learning!!!

SSRS Reports - How to Hide/Disable the atomFeed/ Datafeed icon on SSRS ReportViewer page?

I got a requirement for a dashboard in which the end user doesn't want the datafeed icon to be displayed on the Report because of the crucial data in the report. His concern was if by mistake some body click on the datafeed icon all the data will be available publicly. As this requirement is only for one report, so the challenge was how to disable the datafeed icon for that particular report. There is one parameter (& rc:Stylesheet) which is useful in this case. Let’s see how it work: to customize the toolbar for the ReportViewer 1. Open the directory at the following location of your Microsoft SQL server installation: <drive>:\Program Files\Microsoft SQL Server\MSRS10_50.<InstanceName>\Reporting Services\ReportServer\Styles 2. Create a copy of the file “HtmlViewer.css” in the same folder and name it "CustomHtmlViewer.css". 3. Open “CustomHtmlViewer.css”, find the section . ToolbarAtomDataFeed {        ...

SSRS Reports - How to set chart category dynamically in SSRS Reports?

How to set a dynamic category in the charts: Sometimes there is a requirement where we want to analyze the data based on different dimensions at run time. So it’s like at run time we can analyze the same measure with different dimensions. Solution: We can achieve this by using a filter in the report which allows the user to select the dimension against which they want to analyze the data (Measures) at run time and using this value in the charts “category group” to dynamically set the values. Create a data set for the filter: Filter for the Dimension Names: for Example SELECT      'DepartmentGroupName' AS Dimension UNION SELECT      'OrganizationName' AS Dimension UNION SELECT      'ScenarioName' AS Dimension Create a data set for the Report data: Data for the Report:   for example(Just selecting the top 1000 rows for the demo) SELECT       ...