To do List for SSRS:
1. Report Architecture – Authoring, Deployment and delivery
2. Create Your Data source. DS can be – SQL Server DB/Oracle/CUBE/MS ACCESS/FLAT FILE (Except Excel). If you want to show a report with data from excel, import the excel file into SQL using DTS (Import/Export Wizard) or SSIS Package. Creating a data source involves: Server name, Credentials and Database/Cube/File name-Path.
3. Create Your Dataset: dst can be – SQL Query, MDX Query, Stored Procedure (it can’t be a dynamic Stored procedure that returns different number of columns based on input parameters). The queries used should always return fixed number of columns.
4. Create Your Report: You should know whether the user wants a Tabular/Matrix/Graphical or a combination. Tabular Report is used when you don’t need any kind of grouping or when you need row groups. Matrix Report is used when you need both row and column groups. To any of these reports you can add graphics – Charts / Indicators/Data bars/Spark lines/Gauges/Pivots/Color coding/ Text boxes/ Label/ Report header/ Footer/ Page numbers...Writing SSRS Expressions. Knowledge of SSRS Functions, Aggregations, SSRS Operators and Variables. Tools used to create reports are Visual Studio, Report builder or any third party tools like Tableau, Qlikview. You can also show your data on SSRS Maps to show geographical sales. Knowledge of Sub Report. Linking two reports. Navigating between reports. Report parameters,report variables and group variables,how to add images to report, Page Settings – Margins, Page size, Lookup function to link data from two different datasets. Drilldown reports, Stepped reports, blocked reports, drill through reports, Nested Reports, Interactive Sorting, Custom code (VB or C#),calculated fields
5. Deploy/Publish your Report: You can deploy your report to report server or share point server. You should know the server name, report server url, Folder to which you should deploy your data sources, Datasets and reports.
6. End User Access: End users can access the reports by using the report server url or sharepoint url if they have sufficient permissions. They can also access the reports if they are published to a website (which uses report viewer to show the reports). If the user does not have access to the domain, then the reports can be emailed /shared with the user by exporting the reports. The Various export formats available are CSV, PDF, Word, TIFF, MHTML, XML with Data and any other format preferred by the user.
7. Creating users, roles and assigning permissions on the report server –Users can be only windows users / SQL authenticated users cannot be given permissions. Roles available are System Admin or System User. These are at the site level/server level. Permissions at project or folder level are below
8. Report Subscriptions & Schedules
9. Report Cache and Snapshots
10. Challenges Faced and Solutions
For Detailed Tutorials: http://technet.microsoft.com/en-us/library/ff714047(v=sql.105).aspx
10. Challenges Faced and Solutions:
Pass Multi-value parameter to sub reports in SSRS
Pass a multi-value parameter by using an expression for the subreport parameter's value like so: =Split(Join(Parameters!MyParam.Value, ","), ",")Format number inside ssrs expressionwe can use=Format(Fields!Number.Value, "N")this is for 1,234.00 formatOR=Format(Fields!Number.Value, "F")this is for 1234.00 formatOR=Format(Fields!Number.Value, "0.00")this is for 1234.00 format
Issue with Querystring when deploying ssrs report to sharepoint
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a527b919-cb73-4298-b343-b87754c97214/ssrs-2008-r2-sharepoint-list-item-hyperlink-bug
Performance point -sparklines-in-scorecards
http://nickbarclay.blogspot.co.uk/2007/02/pps-bsm-sparklines-in-scorecards.html
Incorrect format of date report parameters via datepicker - Reporting Services
http://geekswithblogs.net/naijacoder/archive/2008/06/26/123422.aspx
To do List for SSRS:
1. Report Architecture – Authoring, Deployment and delivery2. Create Your Data source. DS can be – SQL Server DB/Oracle/CUBE/MS ACCESS/FLAT FILE (Except Excel). If you want to show a report with data from excel, import the excel file into SQL using DTS (Import/Export Wizard) or SSIS Package. Creating a data source involves: Server name, Credentials and Database/Cube/File name-Path.
3. Create Your Dataset: dst can be – SQL Query, MDX Query, Stored Procedure (it can’t be a dynamic Stored procedure that returns different number of columns based on input parameters). The queries used should always return fixed number of columns.
4. Create Your Report: You should know whether the user wants a Tabular/Matrix/Graphical or a combination. Tabular Report is used when you don’t need any kind of grouping or when you need row groups. Matrix Report is used when you need both row and column groups. To any of these reports you can add graphics – Charts / Indicators/Data bars/Spark lines/Gauges/Pivots/Color coding/ Text boxes/ Label/ Report header/ Footer/ Page numbers...Writing SSRS Expressions. Knowledge of SSRS Functions, Aggregations, SSRS Operators and Variables. Tools used to create reports are Visual Studio, Report builder or any third party tools like Tableau, Qlikview. You can also show your data on SSRS Maps to show geographical sales. Knowledge of Sub Report. Linking two reports. Navigating between reports. Report parameters,report variables and group variables,how to add images to report, Page Settings – Margins, Page size, Lookup function to link data from two different datasets. Drilldown reports, Stepped reports, blocked reports, drill through reports, Nested Reports, Interactive Sorting, Custom code (VB or C#),calculated fields
5. Deploy/Publish your Report: You can deploy your report to report server or share point server. You should know the server name, report server url, Folder to which you should deploy your data sources, Datasets and reports.
6. End User Access: End users can access the reports by using the report server url or sharepoint url if they have sufficient permissions. They can also access the reports if they are published to a website (which uses report viewer to show the reports). If the user does not have access to the domain, then the reports can be emailed /shared with the user by exporting the reports. The Various export formats available are CSV, PDF, Word, TIFF, MHTML, XML with Data and any other format preferred by the user.
7. Creating users, roles and assigning permissions on the report server –Users can be only windows users / SQL authenticated users cannot be given permissions. Roles available are System Admin or System User. These are at the site level/server level. Permissions at project or folder level are below
8. Report Subscriptions & Schedules
9. Report Cache and Snapshots
10. Challenges Faced and Solutions
For Detailed Tutorials: http://technet.microsoft.com/en-us/library/ff714047(v=sql.105).aspx
10. Challenges Faced and Solutions:
Pass Multi-value parameter to sub reports in SSRS
Pass a multi-value parameter by using an expression for the subreport parameter's value like so: =Split(Join(Parameters!MyParam.Value, ","), ",")Format number inside ssrs expressionwe can use=Format(Fields!Number.Value, "N")this is for 1,234.00 formatOR=Format(Fields!Number.Value, "F")this is for 1234.00 formatOR=Format(Fields!Number.Value, "0.00")this is for 1234.00 format
Issue with Querystring when deploying ssrs report to sharepoint
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a527b919-cb73-4298-b343-b87754c97214/ssrs-2008-r2-sharepoint-list-item-hyperlink-bug
Performance point -sparklines-in-scorecards
http://nickbarclay.blogspot.co.uk/2007/02/pps-bsm-sparklines-in-scorecards.html
Incorrect format of date report parameters via datepicker - Reporting Services
http://geekswithblogs.net/naijacoder/archive/2008/06/26/123422.aspx
No comments:
Post a Comment