VISUAL FOXPRO PROGRAMMING FOR CRYSTAL REPORTS: Two Days

An in-depth look at how to integrate Crystal Reports with Visual FoxPro applications

This course is aimed at VFP developers who want to use Crystal Reports as their main reporting tool. It will show you how to create a wide range of reports based on Foxpro data and how to integrate the reports into your VFP applications. 

WHAT YOU WILL ACHIEVE

At the end of the course, delegates who meet the pre-requisites will be able to write VFP program code to manage and control Crystal Reports from within their applications. You will be able open, print, preview and export reports under program control, and give your users many options for modifying the appearance and behaviour of the reports at run time. 

PRE-REQUISITES

To benefit from the course, you should be an experienced Visual FoxPro programmer with a good understanding of its OOP features. Experience of ActiveX Automation would be useful but is not essential. You do not need any previous knowledge of Crystal Reports. 

COURSE CONTENTS

Getting started with Crystal Reports 
  • Creating reports in the CR design surface; using CR experts 
  • Adding more sophisticated features: grouping, sorting, aggregation, conditional formatting, record selection, special fields, run-time parameters 
  • 'Programming' reports with the Crystal Formula Language 

Note: Although the course will give you a useful start in designing reports, it does not aim to cover CR's report design or other end-user features in detail. The main focus is on programming and application development.

Using VFP as a data source 
  • Creating reports based on VFP free tables 
  • Using ODBC to connect to VFP databases 
  • Changing file locations at run time 
  • Dealing with changes in table structures

Distributing reports to non-CR users 
  • Exporting report data 
  • 'Compiling' reports to free-standing executables
  • Using altenative report viewers 
  • Integrating reports with a web browser

Integrating reports in VFP applications 
  • Using the Report Design Component to control reports programmatically 
  • Creating a custom preview window with the Report Viewer control 
  • Dealing with Report Viewer events 
  • Changing the data source at run time 
  • Refreshing data programmatically; working with run-time parameters 
  • Creating a generic report selector form 
  • Letting the user customize the content, layout and formatting of reports 
  • Controlling grouping, sorting and record selection at run time
  • Printing and exporting reports under program control 
  • Distributing CR components with your VFP applications 

Note: This part of the course concentrates on the Report Design Component and Report Viewer control. We do not cover the older integration methods, such as the Report Engine API or the Crystal OCX.

VERSION

The course requires Crystal Reports version 8.0 or 8.5 Developers Edition (parts of the course are also applicable to version 7.0 Professional Edition). The course is equally suitable for programmers working with Visual FoxPro 7.0, 6.0 and 5.0.

E-Mail  us to check availability of places and to make a booking.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

tool for foxpro, tools for foxpro, tools for visual foxpro, tool for visual foxpro, report engine, report writer,

query and report engine, third Party Tools, Visual FoxPro Addons, report generation, query generation,

report and query generator, foxpro query generation, cold fusion, cold fusion development, cold fusion web hosting,

cold fusion ecommerce, cold fusion consulting, cold fusion custom development, visual foxpro development,     

visual foxpro tool, visual foxpro tools, tool for foxpro and visual foxpro, tools for foxpro and visual foxpro,

visual foxpro report writer, visual foxpro report engine, visual foxpro query engine, foxpro query engine,

foxpro programming tools, FoxPro programming tool, oracle report writer, oracle reporting tool,

ms sql reporting tool, ms access reporting tool, ms access report writer, ms access reporting tools,

ms sql reporting tools, oracle reporting tools, oracle query engine, ms sql query engine, ms access query engine,

visual foxpro development, custom applications, database applications, visual foxpro report tools, visual foxpro report tool,

vpm, visual promatrix, dbcx data dictionary, pdf report generation, html report generation, xml report generation,

xml report engine, data dictionary for foxpro, foxpro database, visual foxpro database, visual foxpro dbc, web tools,

web tool, visual foxpro web tool, visual foxpro web tools, visual foxpro report framework, foxpro report framework,

foxpro web tool, foxpro web tools, foxpro development, visual foxpro development, foxpro web site development,

foxpro custom software, visual foxpro custom software, ms access custom software, microsoft visual foxpro,

ms access development, accounting software development, foxpro programming, visual foxpro programming,

ms access programming, visual basic programming, client server databases, client server database,

foxpro consulting services, visual foxpro consulting services, ms access consulting services,

visual basic consulting services, VFP Support, vfp support, foxpro support, visual foxpro support,

foxbase programming, foxpro articles, visual foxpro articles, database development, microsoft sql server,

ecommerce web site development, oracle back end, ms sql back end, visual foxpro front end, foxpro front end,

foxgang, computer services, computer consulting, computer consulting services, foxpro training,

visual foxpro training, accounting system, accountmate, accpac, foxpro consultant, quicken, quickbooks,

collage tracking system, collage software, purchase department software, bidstar software, high school tracking,

accounting software development, tools for accounting, reporting tool for accounting, tool for accounting,

database design, relational database, purchasing department, custom accounting, point of sale, web based accounting,

dos conversion, rbase development, dot net, .net, dotnet, custom programming, custom made applications,

custom made application, quality assurance, visual foxpro, web hosting, web page, crystal reports, programming resource,

vfp training, vfp programming, visual foxpro consultant