Crystal Reports Masterclass

ABOUT THE PROGRAM

Crystal Reports is an application that helps the users to generate reports from simple to complex types. Users can include options such as Charts and sub-reports within a report to analyse the data and can make it more presentable to their clients. Crystal Reports allows data to be grouped as well so that the users can also be presented with a summarized view of their data. This data can come from various sources such as high-end databases like Oracle, SQL Server, DB2, Ingres, and Salesforce. It can also take data as input from other sources such as Microsoft Excel Spreadsheets, XMl Files, Text Files, etc. Earlier on the Crystal Reports Application formed an integral part of Microsoft Visual Studio as a reporting tool but this has been discontinued as Microsoft has replaced the Crystal Reports application with its own in the recent versions of Visual Studio.

  • Learn to create different kinds of reports with crystal reports

  • Learn how to format reports with crystal reports

  • Know how to export reports to a different format using crystal reports

  • Get trained from certified faculty

  • Training provided by global training providers

WHAT'S INCLUDED ?

Find out what's included in the training programme.

Includes

Courseware

Courseware will also be provided to the delegates so that they can revise the course after the training.

Includes

Key Learning Points

Clear and concise objectives to guide delegates through the course.

Includes

Tutor Support

A dedicated tutor will be at your disposal throughout the training to guide you through any issues.

Includes

Certificate

Delegates will get certification of completion at the end of the course.

PREREQUISITES

The Crystal Report Masterclass course comes with no special requirements but the knowledge of Windows environment would be beneficial.

TARGET AUDIENCE

Developers who would like to access the databases and generate reports using Crystal Reports should attend this training.

WHAT WILL YOU LEARN?

By the end of this training, the user will have become familiar with the following concepts of Crystal Reports:

  • Create reports
  • Work with formulas and functions
  • Learn about using parameters in a report
  • Know how to use the formatting features of crystal reports
  • Insert objects in a report
  • Base your crystal reports on external data sources
  • Learn how to export data to other applications using crystal reports

Enquire Program

Fill in the form below & we'd get back to you.

PROGRAM OVERVIEW

The Crystal Reports Masterclass course helps the delegates by teaching them the various tips and tricks regarding the features of Crystal Reports. Professionals use Crystal Reports to develop business reports easily and quickly. Crystal Report has the capability of using almost any kind of data source from Microsoft Excel to high-end SQL supporting databases and Business Objects. As options to generate customized reports may not be available with the software being used in an organisation, reporting tools such as Crystal Reports are a great help. Crystal Reports not only helps generate reports it also facilitates in sharing the required report data with other users such as stakeholders.

Delegates during this training will be provided with all the information they will require when developing their reports at the workplace. Besides just the fundamentals, the delegates will also be provided with tips and tricks that they can use with Crystal Reports. This will save on their time and also add usefulness to their reports. By the end of this training the delegates will have become trained in this skill and they will be able to create reports dynamically as well as interactively. This will also be helpful to their clients as the information presented before them would be helpful to them in making the decisions they want. Moreover, reports can be created using Crystal Reports and exported to HTML format so as to view them over the web.


PROGRAM CONTENT

Introducing Crystal Reports

  • Understanding the Layout in a Crystal Report 
  • Relation between Databases and Reports
  • Crystal Reports Help
  • Customising Crystal Report Settings

Reports

  • Creating Reports 
  • Editing Reports 
  • Displaying Only the Required Data 
  • Report Sections in Crystal Reports

Making Use of Formulas

  • Creating Formulas 
  • Editing Formulas 
  • Using Formulas for Filtering Data 
  • Advanced Formulas 
  • Null Values in a Report

Working with Parameterised Reports

  • Creating Parameter Fields
  • Range Parameters 
  • Creating Prompts in a Report

Grouping Data in a Report

  • Grouping Data
  • Editing Groups in a Report 
  • Grouping with Parameters 
  • Creating a Parameterised Top N Report

Improving Reports

  • Formatting Reports 
  • Inserting Objects in Crystal Report 
  • Suppressing Unwanted Sections 
  • Using Templates

Using Excel to Create Reports

  • Creating Excel based Reports 
  • Editing Reports based on Excel Data 
  • Updating Data in an Excel based Report

Distributing Data using Crystal Reports

  • Exporting Data  from Crystal Reports
  • Create a Mailing Label in Crystal Reports

Crystal Reports Masterclass Enquiry

 

Enquire Now


----- OR -------

Reach us at 0121 368 7851 or info@msptraining.com for more information.

ABOUT Chelmsford

The city of Chelmsford is the principal settlement. It is under the jurisdiction of official charge of Essex which is situated in the eastern region of England. The combined population of the district and urban city is nearly 3 lakh. Its main communities get its name from various cities. In the year of 2012, the queen officially gave it the status of a city. The people of Chelmsford is known as Chelmsfordian. Various ethnic groups in the town get its name from the city of Chelmsford. Preferably, the commuters of various nearby towns make the population of the town. The rail journey between Chelmsford and central London takes 30 minutes less as compare to road journey.

History

During 11th century, there was a bridge that constructed over the River Can. This bridge played important role in the transformation of the town and this town got popularity and started recognizing as a popular town. Prior to 1189, this town was recognised as Celmeresfort and since 1189, the name had changed to Chelmsford. The market was opened immediately after the construction of the bridge over the River Can. It underwent many attacks during 1939 to 1945 and light engineering war production unit was the softest target of the enemies. In 1943, Luftwaffe bombarded where 55 people died and thousand got homeless. After the 1980s, the government has not been giving due importance to defence related industry and this industry drastically impacted during these years. The famous company Marconi shut most of its factories or sold to some other firms.

Administration and policies

This town has its unique geography. It is important for political strategy. It has been recognised as a country town since the 12th century. The various company headquarters such as Essex Country council and Chelmsford city council are situated here. Vicky Ford is the present MP of Chelmsford. He got 22% more votes as compared to his Counter Part.

Demography

As per 2001 census, there was high sex ratio in this region with 50% females and 49% males. Almost 95% people are white and 70% of them follow Christian religion.

Economy

At the initial stage, Agriculture was the only profession that people did with full zeal but with time, it followed the interests in other industries too. There was a small market where people usually do business and earn money. Guglielmo Marconi brought revolution by introducing world first wireless factory. He has great contribution in the invention of the radio. Crompton electrical Engineering, Hoffmann Ball Bearings, English electric valve company, Britvic are the other leading developments in the past. Chelmsford has the best nightlife. The old, as well as superior quality wines, are easily available here.

Transport

The Eastern Counties Railway was introduced a few years prior to the mid-18th century. There were three major viaducts constructed in the past and the major one is 18 arch central park viaduct. A new railway project is in line and it will complete in 2020.

Famous places

The two famous tallest buildings are built nearly 1960s. They are Parkside court and Melbourne court. Till now with 110 m height, the chain home radar tower is the tallest among other buildings.  A person can see it from any part of the city.

Climate

It has a maritime climatic condition. It experiences warmer climate as compared to rest of the United Kingdom. It receives the lowest rainfall and remains drier throughout the year. The rainfall is between 500 mm and 550 mm yearly.

Education, Media and Sports

There are many schools for primary education but Chelmsford College gets a bulk of students for higher education. The radio of this city operates from outside the country. The Chelmsford City Football club representing in the various national championship. The Rugby football club is very famous of this region.