PL-SSRS_IQA_TechBrosIT

1. SSRS – TechBrosIT Videos 

1. Intro to SSDT and Create First Report Project/Solution

• SSDT (SQL Server Data Tools)  tool install

• http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html

• File >> New >> Project >> 

2. 02 - Create Solution with Multiple Projects or Add Existing Projects

3. 03 - Understanding Shared Data Sources in SQL Server Reporting Services

4. 04 - Understand Embedded Data Sources in SSRS

5. 05 - Intro to Embedded Data Sets and Shared Data Sets in SQL Server Reporting Services

6. 06 - Overview of Reports Tab in SSRS Project

7. 07 - Create Tabular Report by using Report Wizard

8. 08 -Create Tabular Report by using Page & Details options by using Report Wizard

9. 09 - Create Stepped Report by using Report Wizard in SQL Server Reporting Services

10. 10 - Create Stepped Drill down Report with Sub Total by using Report Wizard

11. 11 - Create Block Report with Sub Totals by using Report Wizard

12. 12 - Understand Page,Group and Detail in Report Wizard

13. 13 - Use Query Builder Features in Report Wizard to create SQL Query for Report

14. 14 - Create Matrix Report by using Report Wizard in SQL Server Reporting Services

15. 15 - Create Detail/Tabular Report from Basics in SQL Server Reporting Services

16. 16 - Create Stepped Grouped Report with SubTotal and Grand Total from Basics

17. 17 - Create Block Group Report with Sub Total and Grand Total from Basics

18. 18 - Create DrillDown Group Report with Group Total and Grand Total from Basics

19. 19- Create Multi Group Drilldown report with Group Totals and Grand Total

20. 20 - Create Report with Group on Page without Wizard in SSRS

21. 21 - Create List Reports in SQL Server Reporting Services

22. 22 - Display Report Name and Header Row on Each Page in SSRS Report

23. 23 - How to Display all the rows on Single Page in SSRS Report

24. 24 - How to Add Running Total To Tabular Report in SSRS

25. 25 - Add Running Total by Group and DataSet Level in SSRS Report

26. 26 - Add Row Number to rows in SSRS Report ( DataSet Scope and Group Scope)

27. 27 - Create Statics Values Parameter with Default Value in SSRS Report

28. 28 - Single Value Parameter with Values from Query in SSRS Report

29. 29 - Create Multi Value Parameter in SSRS Report

30. 30 - How to create Date Parameters with Calendar in SSRS Report

31. 31- How to Create Radio Button Parameters in SSRS Report

32. 32 - How to Create Cascade Parameters in SSRS Report

33. 33 -Allow Null Value Parameter Option to Pass Null value From Parameter In SSRS Report

34. 34 - How to make SSRS Report Parameter Optional (Ignore the Parameter)

35. 35 - How to Create DrillThrough Report in SSRS

36. 36 - Use Stored Procedure with Single Value Parameter in SSRS Report

37. 37 - Use Stored Procedure with Multi value Parameter in SSRS Report

38. 38- Wildcard Search in SSRS Report Parameter

39. 39 - Show Null value for Multi Value Parameter in SSRS Report

40. 40 - Default Multi Value Parameters are Not Selected in SSRS Report

41. 41- How to Add, Remove Or Rename Parameter in SSRS Report

42. 42 - Create Sub Reports and Call them in Master Main Report

43. 43 - How to change Color of Alternative Row in SSRS Report

44. 44 - How to change color of Rows per Group in SSRS Report

45. 45 - How to Replace Null Values in SSRS Report

46. 46 - How to Hide Empty Rows in SSRS Report

47. 47 - How to use IIF and Switch Function in SSRS Report

48. 48 - Show Report Parameter values while displaying Rows in SSRS Report

49. 49 - How to use Expressions in SSRS Report

50. 50 - Show different Images depending upon value of Cell in SSRS Report

51. 51- Add Page X of TotalPages in Report Footer Or Header In SSRS Report

52. 52 - What is Page Break in SSRS Report

53. 53 - How to Handle Number of Rows Per Page in SSRS Report

54. 54 - Limit Rows Per Page with Groups in SSRS Report

55. 55 - Limit Number of Rows per Page by Parameter Vaule in SSRS Report

56. 56 - Pass Parameter Value from Image Click in SSRS Report

57. 57 - Hide Or UnHide Columns By Using Parameter Value in SSRS Report

58. 58 - Creating Tabs in SSRS Report

59. 59 - How to Create Report that Get Image from Database Table in SSRS

60. Part 59.1- How to use External Image in SSRS Report

61. 60 - How to Create Column Chart in SSRS

62. 61 - Highlight Columns in Chart for Max and Min Values in SSRS Report

63. 62 - How to Format Text Differently in the Same Text Box in SSRS Report

64. 63 - Create Master Report with Report Selection Parameter To Display Selected Report

65. 64 - How to Rotate Text in SSRS Report

66. 65 - How to Create Stacked Column Chart Report in SSRS

67. 66 - How to Display Total on top of Stacked Chart in SSRS Report

68. 67 - How to Combine Column Chart with Line Chart in SSRS Report

69. 68 - How to Plot multiple lines on Same Graph from Same Dataset in SSRS Report

70. 69 - How to Custom Color Columns in Column Chart in SSRS Report

71. 70 - How to Create Pie Chart in SSRS Report

72. 71 - How to Display Percentage in Pie Chart in SSRS Report

73. 72 - How to Change Data Labels Positions in SSRS Report

74. 73 - How to Show Data Labels in Tooltip on hover in SSRS Report

75. 74 - How to Change the Width of Columns/Bars in SSRS Report

76. 75 - How to Create Bar Chart in SSRS Report

77. 76 - How to Create Bar Stacked Chart in SSRS Report

78. 77 - How to Create Area Chart in SSRS Report

79. 78 - How to Create Scatter Chart in SSRS Report

80. 79 - How to Create Line Chart in SSRS Report

81. 80 - How to Create 100% Stacked Column/Bar Chart in SSRS Report

82. 81- How to Display Checkbox for Active and Inactive values in SSRS Report

83. 82 - How to Sort the Results by using Parameters in SSRS Report

84. Part 83 - How to Implement Interactive Sorting in SSRS Report

85. 84 - Implement Interactive Sorting on Matrix in SSRS Report

86. Part 85 - How to use Indicator in SSRS Report

87. Part 86 - How to Create Matrix Report in SSRS

88. SSIS Tutorial 87 - How to use Data Bar in SSRS Report

89. 88 - How to use SparkLine in SSRS Report

90. Part 89-CasCading Parameters with Dynamic SQL in Stored Procedures in SSRS Report

91. 90- How to Create SSRS Report with Dynamic Columns ( Source Definition Change)

92. Part 91- How to Create BookMarks in SSRS Report

93. Part 92 - How to use Filters in SSRS Report

94. SSRS Report Part 93 - How to Auto Refresh SSRS Report Data

95. SSRS Report Part 94-How to Change Color of Text and Header Row after Interval in SSRS Report

96. Part 94.1- How to create Expand Collapse Parameter in SSRS Report

97. 95 - How to Toggle Report Contents by Image Clicking in SSRS Report

98. Part 96 - How to use Top N Rows in SSRS Report Parameter for Default Values

99. Part 97- How to create Folders by Report Manager

100. Part 98-How to Create Data Source in Report Manager Web Interface in SSRS

101. Part 99-How to Deploy Report and Data Source by using Report Manager

102. Part 100 -How to move report/s between folders by using Report Manager in SSRS

103. Part 101-Download report from Report Server to Local Folder by Report Manager

104. Part 102-How to Deploy Data Source to Report Server from SSRS Project

105. Part 103-How to Deploy Single or Multiple Reports to Report Server from SSDT

106. Part 104 - How to Install Report Builder for SQL Server

107. Part 105 - Get familiar with Getting Start Window & Diff Menus in Report Builder

108. Part 106 -How to create Detail Report in Repot Builder By Wizard

109. 107-How to Create Blocked Report with SubTotals in Report Builder

110. Part 108-How to create Stepped Report with SubTotal in Report Builder

111. Part 109 - How to Create Matrix Report by using Wizard in Report Builder

112. Part 110 - How to create Report with Parameters in Report Builder by Wizard

113. Part 111-How to Create Chart Report by using Chart Wizard in Report Builder

114. Part 112-How to Create Table Report from Scratch in Report Builder

115. Part 113-How to Create Matrix Report from Scratch in Report Builder

116. Part 114-How to Modify Existing Report and Republish to Report Server by Report Build

117. Part 115-How to create Report with Parameters by Report Builder from Scratch

118. Part 116-How to Create Report with Shared Data Set and Deploy to Report Server

119. Part 117-How to use Shared DataSet in Report Builder to Create Report

120. Part 118-How to Create Chart Report(Column,Bar,Stacked,Pie) by Report Builder

121. Part 119 - How to Create Map Reports in SSRS (Map Gallery - Basic Map)

122. Part 119.1- How to create Map Report in SSRS (Map Gallery - Color Analytical Map)

123. Part 119.2 - How to Create Map Reports in SSRS (Map Gallery- Bubble Map)

124. Part 119.3 - How to create Map Reports in SSRS (ESRI Shapefile)

125. Part 119.4 - How to create Map Reports in SSRS (Shapefile and Bing Map Layer)

126. Part 119.5-How to create Map Reports in SSRS (SQL Server Spatial Query)

127. 120 - How to Export detail and Drilldown Reports to Excel

128. Part 121- Export SSRS Report To Excel and Name Sheets to Group Values Automatically

129. Part 122- How to Export SSRS Report to CSV,Tab or Pipe Delimited File

130. Part 123 - How to Export SSRS Report to PDF

131. Part 124-Export SSRS Report to PDF with Expanded Drilldown

132. Part 125 - How to Join Two DataSets in SSRS Report by using Lookup Function

133. Part 126 - How to Check Error Log file for SQL Server Reporting Services (SSRS) Errors

134. Part 127-Export Report Items Tablix,Matrix,Chart to Different Sheets in Excel

135. Part 128 - Reporting Services Databases ( ReportServer and ReportServerTempDB)

136. Part 129 -How to Setup a Windows File Share Subscription in SSRS

137. Part 130-Create SSRS Report with DateTime By Using Standard Subscription

138. Part 131-Setup Windows file share subscription in ssrs with Default Parameter Value

139. Display data on a tablix from two datasets in ssrs report by joining on Multi columns-SSRS Interview

140. SSRS Interview Questions - What are seven rendering extensions available in SSRS

141. How to Add Custom Code in SSRS Report - SSRS Interview Questions and Answers

142. How to use Excel as Data Source in SSRS Report - SSRS Interview Questions and Answers

143. How to use CSV file as Data Source in SSRS Report-SSRS Interview Questions and Answers

144. How to create SSRS Report Dynamically with Dynamic Schema, Dynamic Table Name and Dynamic Columns