1490 Courses in Sheffield delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

How to handle Subject Access Requests and other Data Subject Rights.

Your Journey to Pelvic Floor Confidence starts here.. Are you ready to feel more confident in your pelvic floor when you cough, sneeze, laugh, run, jump or exercise? Then this course is for you!! I will show you in JUST 4 WEEKS how to improve your pelvic floor function & feel confident again! Pelvic Floor Confidence can be yours in just 4 weeks!!! Proven Results = A more confident you and a stronger pelvic floor The course has been designed to give you more information about the pelvic floor, how it works and what it does. You will learn how to work with your pelvic floor and increase it’s capacity to best serve your lifestyle and improve your pelvic floor confidence in a functional way. Week 1 – Understanding the pelvic floor and an introduction into the fundamentals of pelvic floor exercises, introduction to functional exercises Week 2 – Pelvic Floor first stage exercises, distraction techniques for urge incontinence and understanding our toilet patterns, with functional exercises Week 3 – Next Step Pelvic Floor Exercises, Pelvic Organ Prolapse and living with it, toilet habits and functional exercises Week 4 – Advanced Pelvic Floor Exercises, Bowel Issues and Irritants. Once you have completed the 4 weekly sessions you will have access to a 12 week follow on programme that will help you implement further what you have learned. This course has been designed to help you understand the importance of your pelvic floor and to help you support it in a functional way.

The Real Estate Investor course primarily focuses on financial modelling and commercial considerations in the real estate industry across various sectors, geographies, and project types.

E-Learning courses are self study courses which students can join from anywhere in the world.

E-Learning courses are self study courses which students can join from anywhere in the world.

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Historical Association webinar series: Making history accessible Presenters: Catherine Priggs and Dale Banham  In this session, participants will review their action research projects established during the first webinar. Coaching conversations will encourage reflection, allowing participants to share their actions and insights. Additionally, they will begin developing a strategic plan to outline next steps for supporting students with SEND in accessing the history curriculum.  To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/bdNUSwLNrL Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

E-Learning courses are self study courses which students can join from anywhere in the world.

E-Learning courses are self study courses which students can join from anywhere in the world.