تفاصيل الدورة
Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports` tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.
Prerequisites:
Crystal Reports 2008: Level 1. A knowledge of programming and/or SQL would also be helpful.
Creating Running Totals:
- Create a Running Total Field
- Modify a Running Total Field
- Create a Manual Running Total
Working with Cross-Tabs :
- Create a Cross-Tab Report
- Format a Cross-Tab Report
- Create Groups in Cross-Tab Reports
Adding Subreports :
- Insert a Subreport
- Edit a Subreport
- Share Variables
- Creating Drill-Downs in a Report:
- Create a Drill-Down
- Create Headings for Drill-Down Data
Using SQL Statements in Report Processing :
- Create a Report Using SQL Queries
- Summarize Report Data
- Create Joins Using SQL
- Create Subqueries
- Create a SQL Expression Field
Creating Complex Formulas :
- Work with Loops
- Work with Arrays
Adding Charts to Reports :
- Create Charts
- Create a Chart with a Drill-Down
- Create a Top N Chart
- Create a Cross-Tab Chart
- Create Charts for Grouped Data
- Format a Chart
- Create a Chart Template
Enhancing Report Functionality :
- Organize Data Based on a Hierarchy
- Create a Dynamic Image
- Create a Report Alert
- Create a Geographic Map
نبذة عن معهد Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
عرض الجميع دورات Professional Training Solutions Ltd SQL Server أسئلة ذات صلة
Are you from Professional Training Solutions Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- Oracle 12c OCP 120-061: SQL Fundamentals Study 365196 درهممدة الدورة التدريبية: Upto 16 Hours
- SQL – Master SQL Database Queries Course Central91 درهم
514 درهممدة الدورة التدريبية: Upto 2 Hours
