Reports

Report with explicit parameters

 There are two ways to create a report 

• using controller class 
• SSRS report using DP class 

1. For SSRS Report first create a DP class and declare the insertion in your temp table (In memory) and declare the logic for your report 

you can also place your queries in DP class or AOT queries 

2. Now create a contract class in which you will declare your parameters for your report and it will also perform validation of the data

3. Now create a UI builder class for your the lookup of your parameters and how they will bind to your report.

4. Now finally create your report from solution explorer and click add item and select report 

fill in the following properties in it to get the temp table mapped with the report

In this query first write name of your DP class and .temptable name to get its fields to map in the report 

IF IN YOUR REPORT MULTIPLE DATA IS NOT VISIBLE ADD ROW GROUP AND SORT ACCORDING TO YOUR DESIRED FIELDS 

5. Now create an output menu to refer this report as SSRS report and also mention the name of the Design tab in your report 

• FOR CONTROLLER CLASS YOU CAN CREATE THIS CONTROLLER CLASS AND MENTION OUTPUT MENU OBJECT TYPE CLASS and OBJECT NAME CONTROLLER CLASS NAME 

 HEY HEY HEY !! HACK OF THE DAY!!!

GO TO ANY CLASS FROM OTHER CLASS SELECT CLASS NAME 

AND PRESS F12