My Tech Views

How to create a Stepped Drill Down Report with Subtotals. After creating a Data Source and a Data Set , Insert a table in the report body and drag the fields into the table columns. Now select the row and right click on it, Click on Add Group and select Parent Group, select the field by which you want to group the data. After selecting Group By field, click on Add group header to create a Stepped report, or leave it unchecked to create a block report To include the subtotals right click on the Text Box and select Add total to add the values w.r.t to the Group and then by Parent Group. After adding the Group, In the Row Groups right click on details(since we need the details as drill down) select visibility and select hide button. At the bottom enable Display can be toggled and select the value by which you need the drill down.

How to create a matrix report using report wizard.  Select Matrix Report Type after creating the data source and dataset  Fill the details space with the columns you want to see in details, select the fields into rows to group by that field, select field into col's to see the data w.r.t columns, page is page wise data

How to use query designer to design a SQL query. First click on the Add table(the one on the top with + sign) option to add the required tables. Select the required columns by selecting the check boxes. If you want to see the column with diff name give the name in the Alias column on grid pane. Give the values in the filter column to filter using the where clause. Group the data using Group by symbol(left of add table button) Give the sort type value to order by that column. Click on Red exclamation mark to execute the query. Click on SQL button to verify the SQL Statement.

How to create a Stepped Drill down report using Data wizard. After creating the required data source and dataset select Tabular report type. Select the fields into Details, if you wan to group by certain column select that field into Group, if you want see page wise data of certain column select that field into Page. Select the stepped radio button, select the enable drilldown button to toggle the data with respect to group , select include subtotals to see the sum of the value columns with respect to group and page. When you select the block option Enable drilldown is disabled because the group headers are cleared in block layout. 

Types of DataSources in SSRS. DataSource is the pointer to database objects, Connection string consists of data source which is the server name and initial catalog is the database name.There are two types of datasources in SSRS as mentioned below. Shared DataSource: Shared datasource is the common datasource among all the reports in a project. When we create a shared datasource in a project it can be used by all the reports in the project. The primary usage of this datasource is, when there is a change in the database name , if we change the database name in the initial catalog then every report is connected to new database.       2 .  Embedded DataSource: Embedded datasource is the datasource which is specific to a particular report. The main advantage of using this datasource is with change in server name only this report is affected and it doesn't show impact to the total project.

                             View the report by Grouping. * In order to group the data by certain value, follow the below steps. First insert a List item in the body of the report. Insert a table and assign column values to the table. Now right click on details under the row groups. Click on Group properties, a group property window pops up. Now enter field by which you want to group by in the text box beside group on.       6. Select other properties listed there based on the requirement. * How to toggle the display in the report select the required rectangle or table, right click on it and select tablix properties. click on visibility then select as per the images below. select the required text box or value field by which you need to toggle.        

* To enable Interactive sorting in a SSRS, select a text box in a table, right click on it and click on textbox properties , select interactive sorting and then choose sort by column name.