Microsoft Excel reporting and 
 data analyzing with practically no coding. 
 .Net, ActiveX, and VCL versions. 
 www.AfalinaSoft.com  

Home    Products    Downloads    Registered users    Support    Prices    Order    Primary Subscription

 

MS Office COM Add-ins. Microsoft Excel reporting 
 and data analyzing


Summarizing and outlining - XL Report.R/3 Screenshots

Summarizing and outlining



No coding is required to add this feature to your report.
Update the template and that is all.

Totals   |   Subtotals   |   Nested subtotals   |   Advanced formatting

Totals

To summarize data, you make your customer click the AutoSum button in Excel worksheet or use the SUM column option in XL Report template.

See how we change the template to produce a report with a total inserted under a column.

XL Report template - click to enlarge

And now see the total inserted.

XL Report report - click to enlarge

Subtotals

To insert automatic subtotals you should group the data in a column and use summary options in columns you want the subtotals to be calculated. To group your data, use the GROUP column option in XL Report template.

See how we change the template to produce a report with subtotals inserted.

XL Report template - click to enlarge

And now see the subtotals inserted.

XL Report report - click to enlarge


Components

XL Report.R/3 XL Report.R/3

Data Access methods

  • ADO
  • DAO
  • RDO
  • unbound data
  • SAP Automation ActiveX Controls

Excel version supported

MS Excel 97 (SR2)
MS Excel 2000
MS Excel 2002 (XP)
MS Excel 2003



[ Download it ]

Copyright © 1999-2006
All right reserved.
Privacy Policy

Write to WebMaster

Page Top
Add-in Express - COM Add-ins, Smart Tags and RTDS in C#, VB, C++, J#, and Delphi