→ It shows all the records of the table/view/sheet/file with proper format.
→ Can aggregate values as per different groups and display pure summary records.
→ Powerful mechanism of displaying summaries for combination of each row & column label.
→ we can filter records based on a business condition which is same as that of a where clause of SQL statement. Text search functionalities are also included in it. Calendars, lenses are also added for fine tuning the search. Top-N/Bottom-N analysis can also done effectively.
→ There can be numeric or string expressions as additional columns along with regular columns. Every reporting tool provides a function library for creating the expressions. Particularly date functions, financial functions, ranking functions are quite frequently getting used.
→ It shows all the records of the table/view/sheet/file and at the end shows totals, highest, lowest, average values.
→ To display different categories of records based on some business condition like sales about 1 million shown in different color.
→ We can combine actual records and summaries together. Particularly suitable for showing sub totals along with actual records.
→ Suitable for hiding lower level records or summaries, as and when required can drill down. We can establish a hierarchy.
→ We can take one or multiple values from the user run time and display records as per the value (s) provided.
→ We can display the geographic data on the map by plotting summary values as per the country, state, city, area, pin code, etc.
→ A typical RDBMS implementation of parent-child relationship can be depicted in the report by showing parent record as a header and its child records as the details.
→ An infographic (information graphic) display the text into graphics. Common examples are traffic signs, subway maps, tag clouds, musical scores and weather charts.
→ Heat maps use color to communicate relationships between data values that would be would be much harder to understand if presented numerically in a spreadsheet.
→ We can establish relationship between multiple parameter lists and depending on the selection of value from one parameter list the next parameter list will get populated. For e.g. when India is selected from Country list then the next list should get states of India only.
→ We can create a local standalone report and then deploy it on the Report Server. Due to this any business user can see that report through web browser. Of course proper privileges have to be given to those users by the Report Administrator.
→ We can convert the report into other formats such as pdf, excel, word, html, text, xml, etc.
→ Combining logically related reports in one container.
→ Data can be shown in different types of charts such as column, bar, line, pie, area, etc.
→ It can be done design time or interactive sorting.Deign time means done by developer. Interactive sorting means user will run time sort the records in ascending or descending manner.
→ From one report we can navigate to another report & based on the value selected in the first report the records of that value will be shown in the next navigated report.
RDBMS such as SQL Server, Oracle, DB2, etc.
OLAP applications such as SSAS, Oracle Essbase, etc.
Big data, Hadoop applications
ERP applications such as SAP, Oracle Apps, etc.
Unstructured data formats such as JSON files
Laying out columns (dimensions, measures & hierarchies) in the presentation area.
Creating derived columns
Adding visual effects with graphs, maps, heat maps, etc.
Performing Data Blending → It will create logical relationship between the tables/views/sheets/files of the different heterogeneous sources. Due to the data blending the entire data from varied sources get the status of one single unit for further processing.
Creating an environment of Self-Serviced Report → The end user can directly create a report without having any technical knowledge of RDBMS, SQL, Data Ware house, OLAP, etc. The data extraction, data blending & OLAP layering job is done by technical team. The end uses will have that wrapper and create self-serviced reports!!
Create the dimensions based on the source columns
Create the facts tables, aggregations based on the source columns
Create the hierarchies
Displaying the output in the standalone executable environment.
Provide mechanism of rendering reports in other formats.
Provide mechanism of deploying reports on the Report Server.