Copyright: Vista, http:
Citation: Excel Report Builder


Excel Report Builder

Content

Introduction

Installation and start of Excel Report Builder

Function of the program Excel Report Builder

The definition of the report parameters

Operations after the definition of parameters

Report Examples

Creating reports

Command line mode

Interactive mode

Registration

About Vista

License agreement

Custom Development

Vista Affiliate Program

Copyright, Vista. 1999


Introduction

Excel Report Builder is an easy to use Microsoft Excel-based reporting tool for your database applications. You can use MS Excel for creation and editing of various styles of sophisticated reports (form, columnar).

It is necessary to have IDAPI (BDE) of Inprise Corporation (version 4.0-4.5), Excel 7.0 - 8.0 and Windows 95 installed on your computer. Excel Report Builder is copyright Vista (1997 - 1999).

Excel Report Builder allows to create reports of the following types:

 1. Form Report (for example agreement, notice, reference).

 2. Columnar Report

Excel Report Runtime  (put_rep1.exe) - program for outswapping data in prepared Excel-forms.

Excel Report  Builder  works with Paradox and DBF - tables, and also with any SQL - databases through BDE 4.0 -4.5.

Content

Copyright, Vista. 1999


Installation and start of Excel Report Builder.
Installation and start of Excel Report Builder

For installation of the program:

a) Unzip excelrep.zip.

b) Run setup.exe .

Starting Excel Report Builder

Do one of the following:

•	 Click the Excel Report Builder icon in the Windows .

•	 Choose Excel Report Builder from the Windows

On the screen the picture - see figure 1 will appear.

Fig. 1 Picture to the program Excel Report Builder

In some seconds the picture will be automatically removed from the screen and instead of it the working window of the program - fig. 2 will be displayed.

Fig. 2. The working window of the program.

Content

Copyright, Vista. 1999


Function of the program Excel Report Builder

The program contains the main menu and panel of keys of fast call of functions.

The menu File is contained the following submenu:

New	creation of the new report

Open…	opening of the created report

Close	closing of active window of the report

Save	saving of the report

Save as…	saving of the report under other name

The name of the last 4 reports, with which the user worked

Exit	exit from the program

Submenu New, Open and Save  are duplicated by first three functional keys located on the panel of keys of fast call of functions.

The menu Report is contained the following submenu:

Blank Builder	call EXCEL for the form of the report

Generate Report	call of the program Generate   Report   for outswapping data in the generated form of the report

Submenu Blank Builder and Generate Report are duplicated by fourth and fifth by functional keys located on the panel of keys of fast call of functions.

The menu Options is contained submenu:

Show prepared report	installation of the parameter of operation of the program Generate

Report

If the given parameter is selected, Excel will be displayed during creation of the report. Otherwise Excel will be displayed after creation of the report.

The menu Windows is contained submenu:

Cascade

Tile Horizontal

Tile Vertical

Arrange

Layout of open windows in the form

Name of open windows

The menu "? "

The submenu contains:

About	call of a picture to the program Excel Report   Builder (fig. 1)

Content

Copyright, Vista. 1999


The definition of the report parameters

For creation of the new report execute the function New the menu File.

On the screen the clean form of the essential elements of the report (fig. 3) will be displayed.

The first field Report name contains the name of the report.

The option buttons joined under the common name Report type, allow to create the report or as the form (Form Report), or as the table (Columnar Report).

The option buttons joined under the common name Number of sheets, allow to display each form of the report on a separate page (Several), or on one page (Single) - one on one with installation of separators of pages.

Fig. 3 Forms of the definition of the essential elements of the report.

The option buttons joined under the common name Open Table by … , allow to select the database source with use full paths (Path) or Alias (database name )

Open Table by full path

Use a key   …  for a choice of the database

At pressing this key the standard dialog box will be called. Use this window for a choice of the database source.

Open Table by Alias Option

The form of the report parameters will look like, represented on a figure  4.

Now instead of a key  … and the fields of input of the name of the file will be displayed two lists of a choice

•	Select registered Alias;

•	Select of the name of the file of the database on indicated Alias.

After filling all fields of the form it is necessary to save the report (file of the report will be displayed full has the extension *.rp).

It is in addition possible to set parameters of data processing:

•	Range of records;

•	SQL query.

Fig. 4 forms of the essential elements of the report

Content

Copyright, Vista. 1999


Operations after the definition of parameters

After saving the report parameters it is possible to begin creation of Excel-form of the report. For this purpose it is necessary to execute the function Blank Builder the menu Report.

If the source file of the database is correctly indicated and the form of the report is saved, at call of this function will boot Excel and on it a background the list of fields of the source database will appear. At call to a unit of the list the "Insert"dialog box - figure  5 will be displayed.

For an insert of a field in   -   the form specify, with the help of the Mouse, spot of a page Excel and name of a field from the list of fields " Insert Field " databases. After keystroke   Insert field  of the "Insert" dialog box in Excel   -   the form the selected field will be inserted.

Using all functional tools and tools of formatting of the application Excel, create the form - template, in which, in further, the data will be swapped.

Fig. 5 Dialog box of an insert of fields in the form.

Upon termination of creation of the form press a key   Close    of the "Insert" dialog box. In a top of the form "Insert" will be displayed (fig. 6) prospective sizes of the form.

Fig. 6. Setting of the sizes of the form.

In this case offered sizes of the form - 9 lines and 3   of a column. The sizes of the form are easy for measuring, having specified in fields of input Row and Col required. The keystroke   Close    will result in termination the process of creation of the form. The if necessary given form can be corrected later.

Content

Copyright, Vista. 1999


Report Examples

Form Report

Where @Name , @Company, @Income … - names of an inserted field.

Columnar Report

Where @Name , @Company, @Income … - names of an inserted field.

Content

Copyright, Vista. 1999


Creating reports

Command line mode

To create a report  type the command:

put_rep1.exe  C:\BVISTA\NAME.RP

Where C:\BVISTA\NAME.RP is the full path name and name of the file of parameters created with the help of the program Excel Report Builder.

The report will be generated according to parameters indicated in NAME.RP.

If the output file for the report already exists, the new report will be added to the end of the existing one. After termination a message on completion of creation of the report will be displayed.

Interactive mode

To operate the program in interactive mode start the Excel Report Builder program. In the "File" menu select the item "Open" and then select the file with the extension RP you want (For Example NAME.RP). This can be made by pressing the button: .

After loading the parameters of the report, select the item "Generate report" in the "Report" menu or press the button ... The report will be generated according to parameters indicated in the RP - file. (The put_rep1.exe program will be called automatically). After termination a message on completion of creation of the report will be displayed. After that it is possible to load another parameters and to generate a new report or to terminate  operation of the program.

Content

Copyright, Vista. 1999


Command line mode

To create a report  type the command:

put_rep1.exe  C:\BVISTA\NAME.RP

Where C:\BVISTA\NAME.RP is the full path name and name of the file of parameters created with the help of the program Excel Report Builder.

The report will be generated according to parameters indicated in NAME.RP.

If the output file for the report already exists, the new report will be added to the end of the existing one. After termination a message on completion of creation of the report will be displayed.

Content


Interactive mode

Interactive mode

To operate the program in interactive mode start the Excel Report Builder program. In the "File" menu select the item "Open" and then select the file with the extension RP you want (For Example NAME.RP). This can be made by pressing the button: .

After loading the parameters of the report, select the item "Generate report" in the "Report" menu or press the button ... The report will be generated according to parameters indicated in the RP - file. (The put_rep1.exe program will be called automatically). After termination a message on completion of creation of the report will be displayed. After that it is possible to load another parameters and to generate a new report or to terminate  operation of the program.

Content


About Vista

http://www.vista.ru

The Vista team is made up of highly skilled mathematicians, systems

analysts and programmers who, having worked in a

wide variety of financial institutions, have an unsurpassed depth of

knowledge of the Russian economy and its procedures.

We combine this experience with the latest technology in order to bring

you the best possible tools with which to analyse and participate in  the

Russian and other markets.

We invest heavily in market research and systems development in order

to allow our developers to pro-actively respond to the needs of the

marketplace and our clients in a rapidly changing environment.

The Vista company has pioneered the development of high-tech

analytical systems with a solid theoretical base in  modern investment

theory  for financial institutions, banks and others and is a market leader

in this sector.

Vista is currently undertaking the development of a major project  for

the largest Russian non-State pension fund

company. As well as this prestige project, we also work closely with

the PRIME-TASS news agency in the

development of information systems for commercial banks, insurance

and financial investment companies.

Vista is committed to providing value for money services for the custom

development of software and hardware solutions in your business. We

specialise in the automation and computerisation of accounting systems

and other complex financial and investment software. We have already

designed, developed and installed systems for computerising  80

private pension fund management systems (which corresponds to over

1000 sites). We are also involved in providing support for specialised

hardware devices utilised in the financial services industry.

Our favoured development environments are C++ and Delphi.  We

endeavour to provide a high quality service at a reasonable price.

Please do not hesitate to request a quotation for any special need which

you may have - You will be pleasantly surprised by our terms.  We

especially aim for long-term and mutually advantageous commercial

relationships with our client companies.

To  familiarise yourself further with our company and our products,

please visit  our web site at  http://www.vista.ru.

Email: vista@aha.ru

Content

Copyright, Vista. 1999


Registration
Excel Report Builder Registration

Excel Report Builder is shareware.

The Registration fee is $50 USD.

In order to obtain a completely functional program, you must register it

and pay the fee.

ONLINE REGISTRATION via a SECURE SERVER with a credit card.

Simply go to our web page http://www.vista.ru/Regform4.htm,

and follow the easy steps there utilizing our secure server.

TOLL FREE Voice and Fax Ordering Systems are alternatives

to registering software ONLINE.

You can call 1-877-REGSOFT to place an order by Voice, or

by FAX at 770-497-9234  and you need to know  the Product

ID = 8189 of the software you wish to purchase.

(International  users please make your VOICE orders by calling

770-319-2718, and your FAX orders at 770-497-9234)

Content

Copyright, Vista. 1999


License agreement

License statement and limited warranty.

The software is protected by copyright law and international copyright treaty. Therefore, you must treat this software just like a book, except that you may copy into computer to be used and you may make archive copies of the software for the sole purpose of backing up our software and protecting your investment from loss.

By saying " just like a book", Vista means, for example, that this software may be used by any number of people , and may be freely moved from one computer or location to another, so long as there is no possibility  of it being used by more than one person at a time. Just as a book can't be read by  two different people in two different places at the same time , neither can the software be available for use by two different people in two different places an the same time without Vista' s permission ( unless, of course, Vista' s copyright has been violated).

Transferring the software.

You may transfer all of your rights to use the software to another person, provided that you transfer to that person all of the software, diskettes, and  documentation provided in this package ( including this statement ) , and transfer or destroy all copies in any form. Remember, once you transfer the software you can no longer have any right to use it, and the person to whom it is transferred may use it only in accordance with the copyright law, international treaty , and the statement.

If you have purchased an upgrade version of the software, it constitutes a single product of the Vista' s software that you upgraded. For example, the upgrade and the software that you upgraded cannot both be available for use by two different people at the same time, and cannot be transferred separately , without written permission from Vista.

Except as provided in this statement , you may not transfer, lease, lend, copy, modify, translate , sublicense, time-share , or electronically transmit or receive the software, media, or documentation.

Limited warranty.

The entire and exclusive liability and remedy for breach of this limited warranty shall be limited to replacement of defective media or documentation and shall be include or extend to any claim for or right to recover any  other damages , including or not limited to, loss  of profit, date, of use of the software or special, incidental or consequential damages, or  other similar claims, even if Vista has been specifically advised of the possibility of such damages. In no event will Vista liability for any damages to you or any other person. ever exceed the lower of the list price or the actual price paid for the package or the licence to use the software, regardless of the form of the claim.

VISTA SPECIFICALLY DISCLAIMES ALL OTHER WARRANTIES, REPRESENTATIONS, OR CONDITIONS, EXPRESSED OR IMPLIED, INCLUDIHG BUT NOT LIMITED TO, ANY IMPLIED WARRANTY OR CONDITION OF MECHANTABILITY OR FITNESS FOR A PATICULAR PURPOSE , ALL OTHER IMPLIED TERMS ARE INCLUDED.

Specifically, Vista makes no representation or warranty that the software or documentation are " error free" , or meet any users particular standards, requirements, or needs of all events , any implied warranty, representation, condition, or other term is limited to the physical media  and documentation and is limited to the 90-day duration or the limited warranty.


Custom Development

Vista Custom Development Department.

Since 1993, Vista has provided custom software development services for

businesses engaged in a variety of industries including banking, finance,

investment, manufacturing, education, advertising, research, and

telecommunications.

Our objective is to provide the very best in software technology, service

and support. We are a group of highly skilled professionals providing

consulting services through a number of targeted divisions.

Vista has the talent and resources to produce comprehensive applications

embodying client/server techniques across a range of technologies to

support your business objectives. Vista is uniquely positioned to cover the

entire solution development cycle, from creating a simple custom

application to providing project management services for large-scale

development efforts.

We have extensive experience with the entire development life cycle

including:

          Process Analysis

          Requirements Definition

          Project Planning

          Technology Assessment

          System Analysis and Design

          Rapid Prototyping

          Application Development

          Application Support

Our expertise in the development of custom applications stems from our

comprehensive understanding of a wide range of advanced technologies,

our diversified programming skills and our exceptional software engineering

capabilities.

To stay competitive, you're constantly searching for better ways to

orchestrate the flow of information. We can get the people in your

company working together like never before. Not by just adding more

computers, necessarily, but by helping realign your information systems

with your organizations goals and objectives. You will then have the ability

and flexibility to react quickly to changing conditions and customer

demands.

The Vista provides the highest possible value for the client, plus a fulfilling

career and positive environment for our team members.

Because we believe that the quality of product deliverables is directly

correlated to the way the development project is managed, we've built a

project management team exceptionally skilled at optimizing productivity.

Vista has experience in the design, development, and implementation of

database-oriented applications ranging from standalone single-CPU

packages to networked client/server designs crossing multiple operating

system platforms. Vista programmers use the latest tools and techniques

in database applications design and are fluent in all current development

environments, such as Delphi, C++ and Java.

At the conclusion of the development cycle and prior to delivery of your

product, bug finding and fixing rather than development become the

primary focus. After the creative process of finding development solutions

and after your application has been appropriately coded, it is tested,

debugged, tested some more, then tested again.

Our team environment flattens the learning curve; we share knowledge and

experience to help each other become as productive as possible. In return,

the client gets the highest level of skills for the services they require.

Why outsource development?

Improve your business processes and boost productivity.

Introduce an otherwise unavailable depth of expertise by hiring a company,

not just a programmer. Our team of professionals is not only thoroughly

trained in Client/server technologies, but they also have the business

experience to help you completely re-engineer your business processes.

Generate revenue by marketing your branded applications.

Key Benefits of a Custom System

     Software & Systems Customized exactly to your specification.

     Ability to add or change software and systems when your business

     needs change.

     Since we designed systems around your business, your learning

     curve will be smaller.

Why choose Vista to develop your software solution?

Vista has developed a comprehensive and proven method for designing,

developing, and delivering systems that capitalize on new technologies.

The result is a uniquely integrated effort that provides maximum use of

resources.

Vista employs superior project management and establishes a quality

assurance program incorporating predetermined reviews throughout the life

of the project. We focus on customer requirements and correctly

translating those requirements to system architects.

Vista has extensive experience producing profoundly effective results in

Client/Server solutions, data conversions, workflow automation,

programming, system integration, project management, documentation,

and training.

Contact our Custom Development Department with information about

your custom development needs.


Vista Affiliate Program

Earn cash by linking to Vista Products!

Vista is now offering an affiliate sales program.  Here is how it works.

If you have a website, you link to us as an affiliate.  Users clicking the link

from your site have the option to buy or try Vista Products.  If they buy

immediately, or buy later, you can earn 30% of the sale.  Our early affiliates

are seeing very good results, so sign up now.

1) The first step is to visit http://www.vista.ru/affiliat.htm and learn about

being an affiliate.

2) Add the following programs:

  Shareware 	           	         Product ID

  FTP Navigator.            	10610

  Word Report Builder              	  7069

  Excel Report Builder             	  8189

  Word Report Components           8188

  HTML , TXT Analyzer	             10612

3) Once you signup to create your affiliate account, visit

http://www.sellshareware.com/AffiliateProgramPage.asp?ProgramID=10610

This page will point give you the image and link instructions needed to start

right away.  For each FTP Navigator purchase you help generate, you'll get

30%.

If you have any questions, let us know at vista@aha.ru