Data With Gaurav

Drill down Report:  ( Making Reports Interactive/Dynamic ): Ex:           +YearNo                               +Sem                                      +Qtr                                              +Month O/p Drill down Effect: Column Name Visibility Toggles Item ProdCat Show - SubCat Hide ProdCat OrderYear Show - OrderQtr Hide OrderYear OrderMonth Hide OrderQtr Country Hide OrderMonth...

Create Parameter Report: To get the category as drop down. When you have to choose multiple values , you make the below changes in the Query.      Create Cascade Parameter Report: Cascade Parameters means  dependent  parameter. Ex: Create dataset with following: USe  IBank go SELECT  ACID , CustomerName , BRID ,  PID FROM  AccountMaster WHERE   BRID = @BRID  and  PID = @PID ·           First we need to add 2 parameters in our main SQL query (MainDataset). Once added it will automatically add in the Parameters in Report Data window. ·           Create new datasets to get the values in the 2 parameters. o     We need to get all the distinct values in the 2nd parameter.   Ex:  SELECT   DISTINCT ( BRID )   FROM  AccountMaster   o     We must need to add the WHERE clause in the 1st par...

  What is SSRS? ·          App given by Microsoft as part of MSBI ·          Render the business data in rich format. ·          Presentation Logic (Look and Feel Logic) ·          Web Enabled Reports ·          Download the Reports ·          Download the reports in multiple formats i.e. Excel, PDF, Tiff etc. ·          Secure the Reports ·          Centralize the Reports ·          Desktop and Mobile Reports (New in SSRS 2016) Steps to Create a Report: 1.      Create a SSRS Project-> Add a New Report 2.      C...