Spring 2008 ECi La Crosse Customer Conference
Session: Crystal Report Writing
User Group: Nextgen
Program Date: Tuesday, April 15, 2008 and Wednesday, April 16, 2008
Program Hours: 1:30—5:30 p.m. (both days)
Location: ECi La Crosse Training Center, Suite 240
This seminar is designed to help you understand the basic concepts of Crystal report design, as well as methods and techniques on how to create your own custom reports with Nextgen data. Topics include:
- Preparing to write a report
- Layout/Developing a report prototype
- Understanding the Nextgen tables and field names
- Previewing and saving report
- Report creation from scratch
- Formatting reports
- Changing font size
- Moving fields to different positions
- Adding and removing tables and fields to and from reports
- Using Nextgen dates
- Using the Nextgen database formula to convert stored date to everyday readable date
- Sorting/Grouping
- How to add sort options to parameters
- How to add grouping to reports
- Using the Select Expert
- Learn how to limit data based on parameter entry or any specific data you would like to omit from the report
- Parameters
- How to add and remove parameters
- Subtotals/Summary/Grand Totals
- How to add subtotals, summaries, and grand totals to reports for any numerical column
- Creating formulas
- Creating formulas to display dollar value fields in red if they are negative values
- Creating formulas to suppress lines and fields if they are 0 quantity or $0 value lines
- Enhancing reports
- Adding and removing your own fields to and from standard reports
- Adding and removing parameters to and from standard reports
- LMS standards
- Where to store modified reports so they do not get overwritten by updates
- Parameter displays in the heading of reports
- Date, time, and naming convention at the top of reports
- Stored Procedures
- How to create and edit stored procedures for reports
- Subreports
- How to create a subreport
- Learning about situations that requires a subreport to be used
- Financial Reporting using encrypted fields
- Learn about our financial tables, how they are encrypted, how to read them, and how use them in your custom reports.
Advanced topics may be covered depending on skill level of attendees and how much time is left after basic topics are discussed. Advanced topics include:
- Working with and editing advanced stored procedures
- Adding tables and fields to stored procedures
- Linking stored procedures to crystal reports
- How to use Nextgen and financial tables and fields more effectively
|
|
|
