Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > J2EE
J2EE General J2EE (Java 2 Enterprise Edition) discussions. Questions not specific to EE will be redirected elsewhere.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the J2EE section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 3rd, 2008, 06:53 PM
Registered User
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MS Excel and Word Report Design Tool

Worth a look if you want others to do thier own reporting...

Windward Reports, the leader in enterprise report generation, has released the world’s first enterprise reporting software that enables use of Excel as a design tool. The Windward Reports Server Engine is perfect for users creating both java reports and .net reports alike, and now allows users to design reports in both Microsoft Word and Microsoft Excel as well.

Windward, a leader in with its design-in-Word reporting software because of its ease of use, now adds the advantages of Excel to its portfolio of simple-to-use, superior reporting products. Windward’s new AutoTag 6.0 reporting software uniquely uses Excel to intelligently figure out sums and number formatting, and allows users to build a table which supports calculations. AutoTag 6.0 still outputs to Word, or any other output format, to produce reporting documents.

Why is this Excel release so important? Simply put: Freedom. By creating an easy-to-use design tool which allows users to design their reports in Excel (in addition to word), Windward is freeing up thousands of IT man-hours normally allocated to report design, and including Excel business users in their ‘power-to the people’ philosophy. Now, non-technical business users who prefer Excel, can design their own reports and stay within their comfort zone while doing so. Windward Reports AutoTag for Excel doesn’t just look like Excel, it IS Excel.

How Does It Work? Begin with a worksheet. Using the AutoTag pull-down menu, select a data source such as an SQL database or XML file. (AutoTag works in conjunction with the Windward Reports Standard Server Engine, which gives your PC the ability to communicate with your organization's data sources, such as its SQL databases and XML files.) You use standard Excel commands to format and edit the report, and you assign tags to the data fields using the AutoTag pull-down menu. When finished, you save your template and, if you wish, verify that tags are correct with AutoTag's "validate" function.

What makes this unique? With AutoTag for Excel, your number formatting always carries through – it doesn’t matter if you output to RTF, PDF, or any other type. And, by using Excel templates you have a way to easily, and automatically generate reports that perform calculations on a collection of values! For instance, you might use Excel to sum all of the line-item amounts that are generated by an AutoTag. While AutoTag was always easy to use, this additional capability offers functions not available in a word-designed template, allowing the software to be used by more people, in more ways.

When you generate the report Windward Reports merges this template with the data you have selected. The finished report, with all of your formatting, positioning and design, is available in minutes instead of hours or even days.

Download a demo or check out a sample report at www.windwardreports.com. For more information on how you can use Excel or Word to design your reports, call 303-499-2544.

Old January 5th, 2010, 10:02 AM
Registered User
Join Date: Jan 2010
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Default not the only one

Alternative solution: http://www.dancrintea.ro/doc-to-pdf/

Can do the following conversions:
doc --> pdf, html, txt, rtf
xls --> pdf, html, csv
ppt --> pdf, swf

as well as other operations:
- replace strings in DOC, ODT and SXW files - so use them as a kind of templating
- read/write Excel files using simplified API like: getCell(x,y) and setCell(x,y,string)
- hide Excel sheets(secondary calculations for example)

Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a useful java gui design tool? yulin11 Java GUI 4 September 2nd, 2008 10:20 PM
Change the format of MS Excel Cells from MS Access hewstone999 Access VBA 0 March 7th, 2008 07:19 AM
Convert Ms Access report to MS Word doc kite Access 1 October 22nd, 2007 01:45 AM
MS Access ----> MS Word anukagni Access 1 August 30th, 2006 02:15 AM
Exporting data from MS Excel sheet to Ms Access ajindal General .NET 1 January 17th, 2005 03:00 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.