Report objects for Enterprise Reporting

These are the typical reports objects, to be provided by the reporting tool. Many of these are elf-explanatory.

• Graphics: These are various graphical forms, which you embed in a report
  

• Custom formulae: These are the formulae created by the users. It is similar to the formulae concept in excel. However, here you can save the formulae, which can be reused in different reports. For example- a custom formulae for sales revenue could be the ‘Net of tax revenue=Billed revenue minus the local service tax’)
  

• Cross reference
  

• Views
  

• Virtual tables: These tables don’t exist physically, but are logical tables. These virtual tables simplify the reference tables which have to be used for end user querying/reporting. Typically the source data tables are large and complex, and by making virtual tables, one can create a simpler source, which could have picked up relevant fields from the source table, combine data across two OR more source tables etc. For example- instead of writing a report query on production report from three different source tables (Product Master, production Report, Assembly Line Master), one can make a virtual table combining the data across three of these tables, and the reporting query can be built on this virtual table.
  

• Pre-defined formulae: This is pre-defined formulae contained with in the system. For example- Monthly production (= Sum of the daily production in the current month)
  formula created in reports server, for reference.

• Summarized fields OR aggregation functions
  

• Dynamic parameters
  

• Hyperlinks: These are hyperlinks, which point to a certain report OR book mark in a report OR a page in a report. You can insert these hyperlinks in the report.
  

• OLE Objects : Can be an excel sheet, image..
  

• Parameters: These can be a global OR local list of parameters, which act as input to the reporting queries. For example- beginning of the month, end of the month date, age, location..
  

• Cascading parameters: Where value of a parameter depends on the value of another parameter
  

• User defined functions: Global functions outside of the pre-defined list within the tool.
  

• Custom functions: These are the functions developed for a report which can be used for other reports
  

• Alerts- Standard exception highlighting logics