Skip to main content

Posts

Showing posts with the label 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 - Importance of setting of the Page Setup in the Reporting services

Benefits of setting the Page setup properties: à In Proper format data export in the hard page break render formats(e.g PDF) à We can properly print the report data on the different size of pages as per our business requirements à It will also save the pages required to print the information properly, which will help to save the environment also J How to open Report Properties to set the page setup: Below window will appear on the screen: In this window there are many options are given as Page setup, Code, References, Variables. On the Page setup option,   à Page Units : here two options are given 1. Inches (it displays the measures in Inches) 2. Centimeters (it displays the measures in Centimeters) If you want more accurate formatting and placement of the object use Centimeters scale. à Paper Size : This Property is very important for the reports. While designing the Report the developer should keep in mind that the how my ...

SSRS Reports - Interview Question - SQL Server Reporting Services

What is a linked report,what is the use of it? What is Placeholder; use of placeholder? What is Drilldown report? What is Drill through report? What is the most complex report you have developed? How to get the values from two data sets into a single table in SSRS? How to deploy the reports on SQL server? / Ways to deploy the reports on Server? How to set alternate row color banding in SSRS? What is data driven subscription in SSRS? From where we can get the reports execution details? What are the difference btwn SSRS 2005 and 2008 R2 version? Can we create the reports using report builder without using the report model? What is a snapshot report and what is the use of it? What are the Cascaded parameters in SSRS and how to create them? Can you list down some Built in fields/Global variables in SSRS Reports? What is the difference btwn Table and Matrix Report? How to create dynamic grouping based on the value selected in a filter the Report? How to dynamic sort t...

SSRS Reports - Space/Gap issue between the objects in SSRS Reports

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the o...