Microsoft Excel Report Tool
 

Excel Reporting Functions

XLReportGen is an easy to use, cost effective, powerful and flexible reporting tool. Using XLReportGen, you can rapidly construct various reports in Microsoft ® Excel ® spreadsheet format. XLReportGen supports various reporting functions.

  • Choosing data sources
  • You can select one or more data sources where you get data.

  • Selecting fields
  • You can specify columns or SQL expressions you want to display. It is easy to add, modify and delete fields in a SQL statement.

  • Selecting records
  • you can limit the records in your report to include only records for a specific group of customers, a specific range of account numbers, or a particular date range.

  • Sorting data
  • Sorting means placing data in some kind of order to help you find and evaluate it. For example, you may want to have a customer list sorted alphabetically by name or by country.

  • Grouping data
  • Grouped data is data that is sorted and broken up into meaningful groups. In a customer list, for example, a group might consist of all those customers living in the same Region.

  • Totaling and summarizing data
  • you can sum the values in each group, count all the values or only those values that are distinct from one another, and determine the maximum, minimum, average. For example, determine the total sales per sales representative in a sales reports. The summary would sum or subtotal the order amounts for each sales representative group.

  • Formatting
  • Formatting refers to changes you can make to the layout and design of a report, as well as the appearance of text, objects, or entire report sections. Formatting can give the report a professional appearance. For more information about formatting, see Microsoft Excel Report Formatting.

  • Charting
  • Charts are visually appealing and make it easy for users to see comparisons, patterns, and trends in data. You can use Microsoft Excel to add sophisticated, colorful charts in your reports. For example, you can see at a glance whether sales are falling or rising over quarterly periods, or how the actual sales compare to the projected sales.

  • Pictures
  • You can add pictures to your reports to make them more visually appealing, to create eye-catching reports, or to add emphasis. For example, you can display a logo in your reports, give a product picture for each product in your product catalog.

  • Parameters
  • Parameters prompt the user of a report to enter information. Think of a parameter as a question that the user needs to answer before the report is generated. The information users enter, or the way they respond, determines what appears in the report. For example, in a monthly report, there might be a parameter that asks the user to choose a month.

  • SQL reporting
  • To extract data from database into reports, you need to write SQL statements. To create one complex report, multiple SQL statements can be executed. For more information about SQL reporting, refer to Microsoft Excel SQL Reporting.


 


Copyright © 2004 - 2014 LJZsoft Corporation. All rights reserved.