____ JK - BI Blog ____

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

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

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