Exceed expectations Formats.


92 views
Uploaded on:
Category: Sales / Marketing
Description
. . . . . . Review of the accessible Excel Format optionsExcel Report BurstingExcel Compound ReportsExcel TemplatesReview case utilizing Developer StudioCompound Excel Templates. Exceed expectations Templates Agenda. Copyright 2007, Information Builders. Slide 3. Completely organized spreadsheets, Stop-lighting, numeric/date group interpretation, etc.Real-time drill-down inside of a spreadsheetAutomatic PivotTable gener
Transcripts
Slide 1

Exceed expectations Templates Renee Teatro Information Builders

Slide 2

EXCEL Templates Agenda Overview of the accessible Excel Format alternatives Excel Report Bursting Excel Compound Reports Excel Templates Review illustration utilizing Developer Studio Compound Excel Templates

Slide 3

Creating the Complete Spreadsheet Solution Out of the case… Fully organized spreadsheets, Stop-lighting, numeric/date group interpretation, and so forth. Ongoing drill-down inside a spreadsheet Automatic PivotTable era Native Excel Formulas Compound reports Population of existing spreadsheets

Slide 4

Creating the Complete Spreadsheet Solution Available Excel positions HOLD FORMAT EXL2K Standard Excel yield HTML/XML group Advantages : Full styling and arranging Drill-downs Customized sheet names Distributable Considerations : Heavy styling = expansive record measure No equations XHT document augmentation

Slide 5

Creating the Complete Spreadsheet Solution Available Excel forms HOLD FORMAT EXL2K FORMULA Standard Excel yield augmentation HTML/XML position Advantages : Full styling and arranging Drill-downs Customized sheet names Distributable Formulas = prepared for examination Considerations : Heavy styling loans to substantial record size XHT record expansion Extended handling

Slide 6

Creating the Complete Spreadsheet Solution Available Excel designs HOLD FORMAT EXL2K PIVOT Unique Excel yield expansion Fully utilitarian Excel PivotTable Advantages : Mini information 3D square on your desktop Distributable Ready for investigation Considerations : Large document size Special language structure rules Limited styling

Slide 7

Creating the Complete Spreadsheet Solution Available Excel groups HOLD FORMAT EXL97 Deprecated Excel yield Designed particularly for Excel 97 HTML based (No XML or CSS) Advantages : Styling, drill-down Distributable Considerations : Heavy styling = vast document estimate No recipes No CSS based components Limited numeric designing

Slide 8

Creating the Complete Spreadsheet Solution Available Excel forms HOLD FORMAT EXCEL Deprecated Excel yield Binary configuration Advantages : Opens in all adaptations of Excel Extremely light weight Distributable Considerations : No styling No recipes No drill-downs No headings/footings

Slide 9

Creating the Complete Spreadsheet Solution Excel Report Bursting HOLD FORMAT EXL2K BYTOC Unique Excel yield expansion Bursts information into different worksheets Advantages : Organizes the information into individual worksheets in view of sort qualities Utilizes existing HTML Table of Contents grammar

Slide 10

Creating the Complete Spreadsheet Solution Excel Compound Reports SET COMPOUND=OPEN/CLOSE (NOBREAK) Multi-report yield in a solitary exercise manual Advantages : Ability to join information from various sources Mix and match Excel forms Utilizes existing PDF compound report linguistic structure Distribute numerous reports in a solitary exercise manual

Slide 11

WebFOCUS Release 7 Available Excel positions HOLD FORMAT EXL2K TEMPLATE Populates existing Excel documents Advantages : Leverage spreadsheets as of now being used inside your association WebFOCUS can drive complex Excel applications More Excel usefulness and styling for end clients

Slide 12

Creating the Complete Spreadsheet Solution The best fit for the circumstance Typical circumstances: Novice clients requiring data for WHAT-IF investigation EXL2K FORMULA Advanced clients requiring an information set for abnormal state of investigation PivotTable A depiction of information for survey/recording EXL2K

Slide 13

Creating the Complete Spreadsheet Solution The best fit for the circumstance Typical circumstances cont… Users requiring booked programmed conveyance of information EXL2K EXCEL Advanced full scale based application requiring a constant flow of operational information EXL2K TEMPLATE Highly styled report for presentation HTML or PDF EXL2K TEMPLATE

Slide 14

WebFOCUS Release 7 - Promote User Productivity Excel Templates Ability to populate your own custom Excel exercise manual with information from WebFOCUS will consolidate Excel yield with a current Excel "layout" Benefits Leverage existing spreadsheets as of now in use inside your association Allows WebFOCUS to incorporate with complex Excel exercise manuals that may contain macros, charts, or finish VB applications. Permits engineers to supply impromptu or end clients with more progressed Excel usefulness out of the crate, for example, channels, subtotals, page/print settings, and so on. Permits more progressed styling for Excel based reports.

Slide 15

WebFOCUS Release 7 Excel Templates - Benefits Centralized Excel Templates Refreshed with information from anyplace in the venture Lock/Protect Cells Reduces mistakes WebFOCUS can be your "information motor" Eliminate manual information section Automate your Auditing Create graphs, capacities, correlation equations, and so on. Use Excel\'s Formula Auditing Speed Financial Reporting Improve Consistency

Slide 16

WebFOCUS Release 7 Excel Templates Data entered physically Data consequently revived Replaced sheet

Slide 17

WebFOCUS Release 7 Excel Templates – How It Works The Template Create an Excel exercise manual and assign one worksheet that will be supplanted with a WEBFOCUS report Save the exercise manual as a "Solitary File Web Page" (Web Archive) Extension will be ".mht" Must be put away in EDAPATH or APP PATH The WebFOCUS method Output organization is EXL2K [FORMULA] Special punctuation that references the layout record and singular worksheet ON TABLE PCHOLD FORMAT EXL2K TEMPLATE WFTMPLT SHEETNUMBER 1

Slide 18

WebFOCUS Release 7 Microsoft MHTML position Web Archive or Single File Web Page Encapsulation of worksheet documents in MIME group Supported in Office 2002 (XP) and 2003 Used to produce and disperse any multi-record Excel report Compound Reports Bursted reports PivotTables Templates

Slide 19

WebFOCUS Release 7 Creating an Excel prepared worksheet Avoid useful pitfalls that invalidate worked in Excel includes Absolutely no clear lines or cells SET BY DISPLAY=ON If you should have a Heading or Footing Add clear line in the wake of Heading and before Footing No Subheads, Subfoots, Subtotals, and so on Use Excel\'s inherent Subtotal highlight

Slide 20

WebFOCUS Release 7 Excel Template – Example – Existing XLS File – Sheet 2

Slide 21

WebFOCUS Release 7 Excel Template – Example – Existing XLS File – Sheet 1

Slide 22

WebFOCUS Release 7 Excel Template – Example – Existing XLS File – Sheet 1 Change the worksheet configuration to the Excel record sort, mht. This will empower WebFOCUS to populate the datasheet. Save the record to the fitting APP index

Slide 23

WebFOCUS Release 7 Excel Template – Example – Create New Procedure

Slide 24

WebFOCUS Release 7 Excel Template – Name Procedure & Select Report Painter

Slide 25

WebFOCUS Release 7 Excel Template – Example - Select CenturySales

Slide 26

WebFOCUS Release 7 Excel Template – Example – Create DEFINE field

Slide 27

WebFOCUS Release 7 Excel Template – Example – Create DEFINE field

Slide 28

WebFOCUS Release 7 Excel Template – Example – DEFINE in Field List

Slide 29

WebFOCUS Release 7 Excel Template – Example – Add Sortfields to Report

Slide 30

WebFOCUS Release 7 Excel Template – Example – Add verb articles to Report

Slide 31

WebFOCUS Release 7 Excel Template – Example – Add verb items to Report

Slide 32

WebFOCUS Release 7 Excel Template – Example – Run Report

Slide 33

WebFOCUS Release 7 Excel Template – Example – Adjust BYDISPLAY Feature

Slide 34

WebFOCUS Release 7 Excel Template – Example – Adjust BYDISPLAY Feature SET BYDISPLAY=ON

Slide 35

WebFOCUS Release 7 Excel Template – Example – Adjust BYDISPLAY Feature

Slide 36

WebFOCUS Release 7 Excel Template – Example – Add Report Heading

Slide 37

WebFOCUS Release 7 Excel Template – Example – Add Report Heading

Slide 38

WebFOCUS Release 7 Excel Template – Example – Add Report Heading

Slide 39

WebFOCUS Release 7 Excel Template – Example – Add Excel Template

Slide 40

WebFOCUS Release 7 Excel Template – Example – Add Excel Template

Slide 41

WebFOCUS Release 7 Excel Template – Example – Add Excel Template

Slide 42

WebFOCUS Release 7 Excel Template – Example – Add Excel Template

Slide 43

WebFOCUS Release 7 Excel Template – Example – Run Report – Sheet 1

Slide 44

WebFOCUS Release 7 Excel Template – Example – Run Report – Sheet 2

Slide 45

WebFOCUS Release 7 Excel Template – Example – Run Report – Sheet 3

Slide 46

WebFOCUS Release 7 Excel Template – Example – Run Report – Sheet 4

Slide 47

WebFOCUS Release 7 Excel Template – Must have least of 2 Worksheets Microsoft Templates: http://office.microsoft.com/en-us/layouts/default.aspx TABLE FILE CAR PRINT BODYTYPE AS "Bodytype" BY HIGHEST COUNTRY AS "Nation" BY CAR AS \'Auto Name\' BY MODEL AS "Model" ON TABLE SUBHEAD "CAR MANAGEMENT LIST" " " WHERE COUNTRY NE \'Britain\'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT EXL2K TEMPLATE \'EXCEL_CUSTOMER MANAGEMENT LIST11\' SHEETNUMBER 1 … (FOC3290) EXL2K: Template document is not a substantial WebArchive document (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND

Slide 48

WebFOCUS Release 7 Excel Template – Incorrect Template name or expansion Right format name yet .mht record not made and grabbed or Incorrectly spelled or non-existent layout name referenced TABLE FILE CAR PRINT BODYTYPE AS "Bodytype" BY HIGHEST COUNTRY AS "Nation" BY CAR AS \'Auto Name\' BY MODEL AS "Model" ON TABLE SUBHEAD "CAR MANAGEMENT LIST" " " WHERE COUNTRY NE \'Britain\'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT EXL2K TEMPLATE \'WRONG NAME\' SHEETNUMBER 1 … (FOC3289) EXL2K TEMPLATE FILE: Error opening record (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COM

Recommended
View more...