What IS SSRS and What reports can we make using SSRS?

SSRS interview Question; What Is SSRS and What reports can we make using SSRS?

SSRS is a Server based Report generating System. We can Build Tabular Reports, Matrix Reports and develop graphical reports using Chart, Maps etc.
Reports can be developed in :
 
  •  Report Builder
  •  Visual Studio
  •  In SQL Server Data Tools (SSDT)
  •  By hand writing XML File
To create interactive dashboards, you can use below:
  •  Sparklines   (Word Size Small Charts, Usually used in Tables or matrix)
  •  Line charts (Used for showing Trend History throughout Year or Months)
  •  Bar charts (used for comparing data monthly or yearly)
  •  Data Bars
  •  Indicators (inline gauges)
  •  Maps (Show Geographical position of data across countries) 
  •  Pie Charts (For Showing Proportion)
  •  Gauges (For Visual Analogies Ex. Showing Trend Progress Further Two Types Linear and       Radial)
 

Comments

Contact Form

Send