Skip to main content

Posts

Showing posts with the label SSRS Best Practice

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