using reportsmith to create interface files l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Using ReportSmith To Create Interface Files PowerPoint Presentation
Download Presentation
Using ReportSmith To Create Interface Files

Loading in 2 Seconds...

play fullscreen
1 / 28

Using ReportSmith To Create Interface Files - PowerPoint PPT Presentation


  • 127 Views
  • Uploaded on

Using ReportSmith To Create Interface Files. Charles Cook Specializing in ReportSmith Training and Consulting 00 March 2000. Presented By. Charles Cook Specializing in ReportSmith Training and Consulting CharlesCook.com Charles@CharlesCook.com. Creating Interface Files. Overview

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Using ReportSmith To Create Interface Files' - nalani


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
using reportsmith to create interface files

Using ReportSmith To Create Interface Files

Charles Cook

Specializing in ReportSmith Training and Consulting

00 March 2000

presented by
Presented By
  • Charles Cook
    • Specializing in ReportSmith Training and Consulting
    • CharlesCook.com
    • Charles@CharlesCook.com
creating interface files
Creating Interface Files
  • Overview
    • Save As
    • Fixed Format Files
    • Using Summary Fields
    • Header/Footer Records
    • ReportSmith 3.1
save as
Save As
  • What is saved
    • Only data in the detail section of your report is saved
    • Column headings are always saved
    • Headers and Footers are not saved
      • Crosstabs in headers and/or footers are not saved
      • Summary fields in headers and/or footers are not saved
save as5
Save As
  • Data Types
    • Report Files (.rpt)
      • This will save the attributes of your report not the report data
    • Report Query Files (.rqf)
    • Excel Files (.xls)
    • Text Files (.txt)
      • Tab Delimited
    • Lotus 123 Files (.wk3)
    • Comma Delimited Files (.csv)
    • Data Interchange Format Files (.dif)
    • Quattro Files (.wkq)
fixed format files
Fixed Format Files
  • Overview
    • Format the data using a SQL derived field
    • Save the data using Save As
fixed format files12
Fixed Format Files
  • Formatting the data
    • Create one SQL Derived Field
    • Convert the data to a string if necessary
      • Conversion function will format the data
    • Pad the data with leading or trailing spaces or zeros
    • Trim the field to size
    • Concatenate the field to the next field
fixed format files15
Fixed Format Files
  • Save the data
    • Save As Text Files
using summary fields
Using Summary Fields
  • Overview
    • Group the data and create summary fields
    • Create a macro to write the data to a file
      • The data can be delimited or fixed format
    • Link the macro
using summary fields19
Using Summary Fields
  • Create a macro
    • Loop through each record in the report
    • Write one record for each group
      • Write the summary fields not the data fields
      • The summary fields are for the report group
    • Tell the user the file has been created
header footer records
Header/Footer Records
  • Overview
    • Added to the macro
    • Header records are written before the loop
    • Footer records a written after the loop
    • Write the summary fields not the data fields
      • Summary fields are for entire report group
reportsmith 3 1
ReportSmith 3.1
  • Overview
    • Saving formatted data
    • Printing to HTML
presented by28
Presented By
  • Charles Cook
    • Specializing in ReportSmith Training and Consulting
    • CharlesCook.com
    • Charles@CharlesCook.com