Skip to main content

Posts

Showing posts with the label SSRS 2008 R2

Why SQL server reports are coming blank or user not able to see the data

Problem statement: Sometime while opening the SSRS reports in Browser, it shows blank data even if there is data present in the database or some functionality does not work properly. Solution: here are some points to check to identify the root cause of the problem: User Access on Reports : Check the access of the user on Reports User Access on Source data: Check the access of the user on Cube or database Browser: If the user is having the proper access on the Reports as well as the Cubes or Database then check, on what browser user is running the report. Internet Explorer: If the user is using a browser other then Internet Explorer, then ask the user to use the Internet Explorer to access the SSRS Reports. There are many functionality of SSRS Reports which are not supported by all the browsers. Below are link for more details: http://msdn.microsoft.com/en-us/library/ms156511(v=sql.105).aspx http://social.msdn.microsoft.com/Forums/sq...

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 Best Pracitice - 4

Report Model: 1. Field Alignment:  Apply the Alignment properly for all the fields as per the Requirement i.e. Code we can set the Center align, Text (Address, Names, and Description) we can set the Left align, Currency, financial data we can align Right. 2. Fields Default Sorting: Define the fields default sorting column to sort the data. 3. Format for the values: Define a proper format for the fields values i.e. for Number use N0, for Percentage use P0 etc. 4. Use Proper Naming conventions for the fields in the Report Model. it should be user friendly Names which represent the proper link to the information in the field. 5. Remove unnecessary aggregations on the numeric fields which are of no use. i.e. for a code in int we can remove the avg. of code which we know that is will not give any significant result. 6. Only include the necessary tables in the Model. To remove to complexity of the model use the Named Query to fetch the data for a particu...

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 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 {        ...