1. Define Query parameter in SSRS?

Query parameters is revealed in the query of the datasources that are to be included into the SQL script’s where clause of the SQL that can accept parameters. Query parameters begin with the symbol @.

2. What are the Reporting Service Constituents in SSRS?

A. Report Manager : A Web-based administration tool for managing the Report Server.
B Report Server : Provides services for implementation and delivery of reports.
C. Report Designer : A place where we can create report.

3. What do you understand by matrix in SSRS?

A matrix is a data region related to a report set. Matrix permits us to create crosstab reports with the report variables showing on rows and columns. It allows us to drag.

4. What do you mean by sub reports and how we can create them?

A sub report is like any other reports which can be termed in main report and can be generate through main report. Parameters can be conceded from main report to sub report and basis of that report can be created.

5. Definereport model project?

Report model project is used for creating Adhoc reporting. We can create the adhoc reports over report builder. Report model project can be created on bids or report server. This model can have simple view.

6. What do you understand by report server project?
Report Server Project comprises of RDL file and it need to be deployed on report server to view the report files to application and user. It is a solution where we can design our reports. We can add it by going into BIDS clicking on new item and then selecting reports server project. Once the solution is formed we can start forming reports.

7. Explain report builder?

Report builder is used to create small reports and it is a define interface. We can’t change the report interface in report builder it pre designed. We can just drag columns in the report. It creates reports on database objects available with report model project.

8. In which SQL Server type report builder introduced?

Report builder presented in SQL Server 2005. While creating or arranging report model project on report server we can get error or it might not get formed. For this we need to check whether the service pack 22 is installed or not.

9. How toorganise the Report?

Report can be organized in three ways :-
 Using visual studio : In visual studio we can directly deploy the report through solution explorer by providing the report server URL in project properties at Target Server URL. This will organize entire project or single report as per our selection.

2.     Using report server : We can directly go to the report server and deploy the report by looking the report from the disk location on server.

3.     Creating the utility : SQL server provides the utility which can be used to create a modify utility for our report deployment in bulk.

10. DefineRS.exe utility?

Rs.exe utility is used for organizing the report on report server. It comes with the report server and can be modify accordingly

Thanks & Regards
Sky InfoTech Pvt. Ltd.
A -50, Sector-64, Noida  (UP)
Ph. 0120 - 4242224
Noida:  9717292598 / 9717292599
Delhi:  9717292601 / 9717292602
Gurgaon:  9810866624 / 9810866642
Website: https://www.skyinfotech.in/microsoft-bi-msbi-training-in-noida.php