Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

Report Training Part 2

Back | Level back

 

Objective

Today, the participant will learn how to create reports with active contents, hence reports including scripts and references to external data sources. Often different ways, will be demonstrated. "Intelligent" reports can be created using scripts and own data sources which change the layout of the report depending on the user data entered or data records selected.

 

Course Information

Max. No. of participants 8
Environment Each of the participants work on individual PC's
Duration 1 day
Food & Beverage Convention beverages, snacks and a three course business lunch are included.
Price 320.- EUR plus VAT. per person. Clients with a Software subscription receive 5% discount. All classes are exclusively for professionals only.
Registration Register...

 

Agenda

„Report Training Part 2“ will last one day. The participant is supposed to have proficient knowledge handling the EULANDA® ERP and creating standard reports. T-SQL knowledge is not needed but it would be helpful if basics are present.

  • Why using script languages?
  • Sequence of creating reports.
  • Report bands, Elements and their properties.
  • Report events and their meaning.
  • Include own data sources
  • Pascal Script language (Basics)
  • The first script
  • Break 10 min
  • Exercise - Suppress  elements
  • Exercise - Control output of the letterhead
  • Exercise - Watermarks as copy counter
  • Exercise - Warnings under certain circumstances like little margin
  • Exercise - Long text printed in bold letters
  • Exercise - Omit shipping address
  • Exercise - Subtotals
  • Lunch break
  • Query language T - SQL (Basics)
  • Send SQL-commands to the server
  • Exercise - Block once printed reports.
  • Exercise - SQL-Result set via scripts
  • Exercise - Control of report print-outs
  • Break 10 min
  • File handling within reports
  • Import of local images and documents
  • Exercise - User dependent signature
  • Exercise - Data export as CSV-file
  • Exercise - Result sets as eMail
  • Exercise - Multiple labels
  • Q & A

 

Further Information

Reports Part 2     Download as PDF-file
Registration or per   Download as PDF-file