Course description: Series 7 Version 3 and 4 - Advanced Impromptu Reporting SPVC

PLEASE DO NOT MAKE TRAVEL ARRANGEMENT FOR THIS SELF PACED VIRTUAL COURSE (SPVC). ONCE YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT.

After you receive confirmation that you are enrolled, you will be sent further instructions to access your course material and remote labs. You will then have a 30 day window in which to complete your course. Within this 30 days, you will have 336 hours of elab time. The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but lab system access is allocated on a first-come, first-served basis. When you are not using the elab system, ensure that you suspend your elab to maximize your hours available to use the elab system. Once you have accessed the course, help is available Monday through Friday; questions will be responded to within 24 hours.

NO EXTENSIONS FOR THIS COURSE WILL BE GRANTED.

This is the self paced training version of "Series 7 Version 3 and 4 - Advanced Impromptu Reporting" classroom course. Series 7 Version 3 and 4 - Advanced Impromptu Reporting is a one-day, self paced course that focuses on advanced reporting techniques for report builders, analysts, and administrators. Students learn techniques to create high-performance, real-world business reports. These skills extend well beyond those developed in Impromptu Series 7.x Report Building.

Through Hands-on demos and workshops, and an understanding of how Impromptu works you learn to develop systems of reports. You incorporate optimizing concepts like client/server balancing as well as distribution practices such as preparing for publishing to the Web. Because the requirements of each Impromptu environment are unique, this course emphasizes general concepts that can be tailored to your specific environment.

View this course in other countries

Back to top

This advanced course is for Impromptu users who will be creating, customizing, and distributing reports.

Back to top

You should have:

• Series 7.x Report Building with Impromptu or equivalent experience with Impromptu
• One to three months of hands-on experience creating Impromptu Reports
• Experience with SQL, HTML and scripting languages would be valuable

Back to top

Please refer to Course Overview for description information.

Back to top

Systems of Reports

• Review basic concepts
• Create sub-reports
• Use linked and unlinked sub-reports
• Explore different sub-report options
• Associate Impromptu reports to drill through from one report to another
• Set a default drill-through report

Advanced Crosstabs

• Explain what a crosstab report is
• Explore summarization options
• Explore methods for creating crosstab reports
• Discuss methods for manipulating crosstab report data
• Explore crosstab filters
• Add calculations and advanced calculations to the report

Optimization Techniques

• Use local data sources for faster data access
• User query options to reduce unnecessary work
• Shift work to the database

Distributions and IWR Authoring

• Prepare Impromptu reports for distribution locally
• Prepare Impromptu reports for distribution to Impromptu Web Reports (IWR)

Templates

• Discuss templates and their benefits
• Define the various uses of templates

Back to top

Minimum Requirements (for PC) to use SPVC

• Windows 2000, XP, Vista, and 7
• Firefox, including V3.6.6
• Internet Explorer, including V8
• Browser settings include:
  • Java Runtime Environment must be installed and enabled in the web browser
  • Web browser must be set to enable/allow JavaScript
  • Web browser Pop-up blocking mechanisms must be set to allow pop-ups from elearn.ihost.com
• Cookies must be enabled
• Flash-enabled
• CITRIX, for the remote lab (instructions to install included with the SPVC)

Back to top