Creating drilldown report in Visual Studio


HTML clipboard

1. First Drag a Table from Toolbox

1.gif

2. Create a new Connection String by Clicking EDIT button. When you click on that EDIT Button the screen will be like below

2.gif

3. Select Server Name, Select Authentication Type. That is Windows Authentication or Sql server Authentication .

4. Select the Database name from the Option from drop down that is (Select or enter a database name)

3.gif

5. And click on Test Connection button and Click on OK Button . The screen shot will be like this

4.gif

6. By clicking on the Ok Button the Screen will close. Next Screen will be looks like below format.

5.gif

7. Next Click on NEXT BUTTON it will display QUERY DESIGNER WINDOW. The screen shot looks like below

6.gif

8. Next Click on EDIT TEXT Button that was located left side at topmost Place.

7.gif

9. By Clicking on the EDIT AS TEST button it will display the following options.

  • SHOW/HIDE Diagram Pane,
  • SHOW/HIDE Grid Pane,
  • SHOW/HIDE SQL Pane,
  • RUN
  • Verify SQL
  • Use Group By
  • Add Table

The screen show looks like below format

8.gif
10. Click on Add Table ICON(Located at the end of right side).have a look for window

9.gif

11. By Clicking on the ADD TABLE ICON the list of Tables will be displayed. The screen looks like below format

10.gif
12. Select the table name from the List of Table and click on ADD Button. Next click on CLOSE BUTTON To close the window. Next the screen looks like below format.

11.gif
13. Select what are all the columns are required by checking the check box . Kindly have a look below screen shot to get an idea.
 
12.gif
14. Next Click on OK Button . After that the screen shot looks like below format

13.gif
15. Next Click on OK Button . After that the screen shot looks like below format

14.gif
16. Drag the what are all the columns are to display.

17. Select the column for Group By. Here I have selected EmpID for Grouping.

18. Right Click on that Empid column and click on AddGroup , Select Parent group from ROW GROUP
The Screen will be looks like below format.

15.gif

19. Click on Parent Group, Select EmpID Column from Group by DropDown list and Click on OK BUTTON.
The screen shot looks like below format.

20. Select Detail section, right click on that Detail section, Click on INSERT ROW . There 2 options are available . ABOVE and BELOW. Select ABOVE. The screen shot looks like below format.

16.gif
17.gif
21. Next Select Detail section again and right click on that select ROW VISIBILITY Property . The screen shot looks like below format.

18.gif
22. When select ROWVISIBILTY property , The ROW VISIBILITY window will open .Find the Screen shot below format.

19.gif
23. Select HIDE Option from "When the report is initially run" and Check on "Display can be toggled by this Report item".

20.gif
24. Select Group name from the Dropdown list which was enabled when check box checked(Display can be toggled by this Report item) Next the screen shot will be looks like below format.

21.gif
25. Click on OK Button Next the screen shot will be looks like below format

22.gif
26. After that build and run the reports the screen shot looks like below format

25.gif
27.By clicking on the Plus button the record will be shown. The screen shot looks like below format.

24.gif

25.gif

Up Next
    Ebook Download
    View all
    Learn
    View all