Data Source : Data Source is a connection to the database.
Data Set : Data Set is a logical representation of tables.
Shared Data Source : Shared Data Source is a Data Source which can be used across any report in
the same project.
Drill Down Report : With in the same report if we want to do navigation like expansion and collapsion etc then we go for drill down report.
Select All --> F4 --> Hidden : True --> Toggle Location : Group 1 / Group 2 .
Drill Through : Moving from one report to another report based on report action.
Sub Report : Sub Report displays the content in the mail report . It can take parameters .Generally
Sub Reports are taken place in real time to display particular information for every row or set of rows
in the main report.
Parameters : Parameters provides user interaction to the report.
Queried Parameters : In queried parameters values are taken from query .
Non-Queried Parameters : In Non-Queried Parameters values are not getting from the database
based on the query i.e parameter values are written manually.
Eg :Provides flexibility to the user to go to the corresponding location based on location selection.
Multi-Valued Parameters : We can create MVP for both Queried Parameters and Non Queried
Parameters reports. It allows multiple values to select in the parameter list.
Cascaded-Parameters : Based on one parameter value if you display data in another parameter values then it is cascaded.
Eg: Based on the location section , corresponding party code should be selected and based on party code selection the report should be displayed.
Chart Reports : Chart reports are useful to display the data in more analytical way .
Data Section (Y- Axis ) : On Y -Axis actual data represented.
Category Section (X-Axis ) : On X-Axis group wise information displayed.
Series Section : It displays information related to series of data presented in the report.
Types of charts : Microsoft introduced several charts such as Column Chart , Line Chart , Bar Chart,
Shape Chart , Area Chart , Range Chart,Scatter Chart and Polar Chart to represent data in more
analytical way.
Matrix Reports : Matrix reports are useful to display cross tab reports. Generally it displays data in the form of matrix like rows against columns.
Row Section : Row wise information displays.
Column Section : Column wise information displays.
Data Section : Data section may have summarized or aggregated or normal data against row and column section .
Subscriptions : Delivering the report to the corresponding business user in requested format at a stipulated time . With windows authentication we cannot create subscription . We can send reports to the users in e-mail or deliver to a file share or can put report in Microsoft office share point server.
A data-driven subscription can deliver a report in many render formats to many destinations.
Eg : User 1 wants report in XML format and User 2 wants in pdf format and User 3 wants in word but that too on shared drive . To meet this requirement we can use data-driven subscriptions . DDS requires a database table to store all these report values so that these values can be used during report processing.
RDL : Report definition language , when we design a report using any tools like BIDS and when we save a report it is saved as .RDL file . RDL file is a kind of XML code which stores the design of the report. This RDL file is being used for deploying report to report server.
Reporting Services : Reporting service will helps business to transform rows data (table data) into graphical like chart , histograms etc to add meaning to raw data. SSRS can query and display data from any of multiple databases and represent in a way which is more understandable to users.
SSRS supports SQL , T-SQL i. e procedures ,functions etc but it should return single user set , if it returns multiple result sets only first result set will be used for the report dataset. It also supports MDX - For OLAP cube data sources , DMX - For data mining.
Data Regions : Data Regions are report items that displays repeated rows of summarized information from data-sets.
Reporting Service Components :
Report Designer : Report Designer is a place where the report is designed or created.
Report Server : Report Server provides for implementation and delivery of reports.
Report Manager : Report Manager is a web-based administrator tool to manage the report server.
Encryption Key : Encryption Key is used to restore report server database on another machine . In
Encryption Key connection strings are maintained.
Report Server Databases : Reporting Services uses 2 SQL Server databases for storage by default.
Report Server : Report Server is a main database which stores all internal configuration and report meta data.
Report Server Temp db : Report Server temp db used to store temporary data , session information
and cached reports.
Report Server Configuration :
SSRS Configuration files are saved with .XML format.
Mostly all configuration files are located at installed directory i.e
Drive Name \ Program Files \ Microsoft SQL Server \ SQL Server Instance \ Reporting Services \ Report Server and Report Manager .
Rsreportserver.config : Stores configuration settings for feature areas of the report server service , report manager , report server web service and background processing.
Rssrvpolicy.config : Stores code access security policies for the server extensions.
Rsmgrpolicy.config : Stores configuration settings that specify the trace levels and logging options for the report server service.
Data Set : Data Set is a logical representation of tables.
Shared Data Source : Shared Data Source is a Data Source which can be used across any report in
the same project.
Drill Down Report : With in the same report if we want to do navigation like expansion and collapsion etc then we go for drill down report.
Select All --> F4 --> Hidden : True --> Toggle Location : Group 1 / Group 2 .
Drill Through : Moving from one report to another report based on report action.
Sub Report : Sub Report displays the content in the mail report . It can take parameters .Generally
Sub Reports are taken place in real time to display particular information for every row or set of rows
in the main report.
Parameters : Parameters provides user interaction to the report.
Queried Parameters : In queried parameters values are taken from query .
Non-Queried Parameters : In Non-Queried Parameters values are not getting from the database
based on the query i.e parameter values are written manually.
Eg :Provides flexibility to the user to go to the corresponding location based on location selection.
Multi-Valued Parameters : We can create MVP for both Queried Parameters and Non Queried
Parameters reports. It allows multiple values to select in the parameter list.
Cascaded-Parameters : Based on one parameter value if you display data in another parameter values then it is cascaded.
Eg: Based on the location section , corresponding party code should be selected and based on party code selection the report should be displayed.
Chart Reports : Chart reports are useful to display the data in more analytical way .
Data Section (Y- Axis ) : On Y -Axis actual data represented.
Category Section (X-Axis ) : On X-Axis group wise information displayed.
Series Section : It displays information related to series of data presented in the report.
Types of charts : Microsoft introduced several charts such as Column Chart , Line Chart , Bar Chart,
Shape Chart , Area Chart , Range Chart,Scatter Chart and Polar Chart to represent data in more
analytical way.
Matrix Reports : Matrix reports are useful to display cross tab reports. Generally it displays data in the form of matrix like rows against columns.
Row Section : Row wise information displays.
Column Section : Column wise information displays.
Data Section : Data section may have summarized or aggregated or normal data against row and column section .
Subscriptions : Delivering the report to the corresponding business user in requested format at a stipulated time . With windows authentication we cannot create subscription . We can send reports to the users in e-mail or deliver to a file share or can put report in Microsoft office share point server.
A data-driven subscription can deliver a report in many render formats to many destinations.
Eg : User 1 wants report in XML format and User 2 wants in pdf format and User 3 wants in word but that too on shared drive . To meet this requirement we can use data-driven subscriptions . DDS requires a database table to store all these report values so that these values can be used during report processing.
RDL : Report definition language , when we design a report using any tools like BIDS and when we save a report it is saved as .RDL file . RDL file is a kind of XML code which stores the design of the report. This RDL file is being used for deploying report to report server.
Reporting Services : Reporting service will helps business to transform rows data (table data) into graphical like chart , histograms etc to add meaning to raw data. SSRS can query and display data from any of multiple databases and represent in a way which is more understandable to users.
SSRS supports SQL , T-SQL i. e procedures ,functions etc but it should return single user set , if it returns multiple result sets only first result set will be used for the report dataset. It also supports MDX - For OLAP cube data sources , DMX - For data mining.
Data Regions : Data Regions are report items that displays repeated rows of summarized information from data-sets.
Reporting Service Components :
Report Designer : Report Designer is a place where the report is designed or created.
Report Server : Report Server provides for implementation and delivery of reports.
Report Manager : Report Manager is a web-based administrator tool to manage the report server.
Encryption Key : Encryption Key is used to restore report server database on another machine . In
Encryption Key connection strings are maintained.
Report Server Databases : Reporting Services uses 2 SQL Server databases for storage by default.
Report Server : Report Server is a main database which stores all internal configuration and report meta data.
Report Server Temp db : Report Server temp db used to store temporary data , session information
and cached reports.
Report Server Configuration :
SSRS Configuration files are saved with .XML format.
Mostly all configuration files are located at installed directory i.e
Drive Name \ Program Files \ Microsoft SQL Server \ SQL Server Instance \ Reporting Services \ Report Server and Report Manager .
Rsreportserver.config : Stores configuration settings for feature areas of the report server service , report manager , report server web service and background processing.
Rssrvpolicy.config : Stores code access security policies for the server extensions.
Rsmgrpolicy.config : Stores configuration settings that specify the trace levels and logging options for the report server service.
Hi , When can we expect the posts for SSRS , Please post the deployment or DBA roles in SSRS .
ReplyDeleteSure Amrita . please keep in touch with the blog.
ReplyDelete