Crystal Reports Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype, WebEx, go-to meeting

Course ID: 46119

Course type: Online Instructor led Course

Platform: Skype, WebEx, go-to meeting

Students Interested 0 (Seats Left 10)

₹ 10,000

No Reviews Yet

Batch 1

Date : 21 Jul, 18 - 20 Aug, 18

Timings : 06:00 AM-06:00 AM

Seats Left : 10

Students Interested : 0

Students Attended : 0

Enquire

Raja picture
Raja

B.Tech, 11 years experience with top MNC company

About Raja

Have trained around 150 students so far with 5+ years of training experience.
Have done class room, online and corporate trainings
No reviews currently Be the First to Review

About the Course

1. Introduction to Reporting
2. Record Selection
3. Sorting, Grouping, and Totaling
4. Running Totals
5. Using Formulas
6. Cross-Tab Objects
7. Formatting
8. Report Alerts
9. Multiple Section Reports
10. Subreports
11. Parameter Fields and Prompts
12. Printing, Exporting, and Viewing Reports


13. Charting concepts


 


 


Introduction to Reporting-
Report creation options
Choosing data sources and database fields
The Database Expert
The Field Explorer
About the report design environment
Design tab
Preview tab
HTML Preview tab
Creating a new report
Selecting the data source
Adding tables
Linking multiple tables
Placing data on the report
Formatting data
Record selection
Grouping, sorting, and summarizing data
Using the drill-down option on summarized data
Inserting page headers and footers
Adding a title page to the report
Adding summary information to the report
Exploring reports and working with multiple reports
The Report Explorer-


Record Selection
Selecting records
Options for selecting records
Determining which field(s) to use
Using the Select Expert
Using formulas
Interaction of the Select Expert and the Formula Editor
Saved data selection formulas
Using formula templates
Record selection formula templates



Sorting, Grouping, and Totaling:
Sorting data -
Understanding sort options
Sorting single and multiple fields
Sort controls
Grouping data-
Creating custom groups
Sorting groups conditionally
Sorting records within groups
Group selection-
Grouping data in intervals
Editing groups
Summarizing grouped data


Running Totals
Understanding running totals
How running totals work
Creating running totals
Creating running totals in a list
Creating running totals for a group
Creating conditional running totals
Creating running totals using a formula
To create running totals using a formula


Multiple Section Reports

About sections:
Working with sections
Inserting a section
Deleting a section
Moving a section
Merging two related sections
Splitting and resizing sections
Splitting a section
Resizing a section
Using multiple sections in reports
Keeping variable length objects from overwriting each other
Eliminating blank lines when fields are empty
Adding blank lines conditionally
Working with text objects


Formatting

Formatting concepts
Using a template
Applying a template
Removing an applied template
Reapplying the last template selected
Using Template Field Objects
Template considerations
Using the Report Design Environment
Section characteristics
Making an object underlay a following section
Pre-printed forms
Multiple columns
Hiding report sections
Hiding report objects
Placing text-based objects
Placing multi-line, text-based objects
Spacing between text-based objects
Selecting multiple objects
Vertical placement
Inserting character and line spacing
Setting fractional font sizes
Setting page size and page orientation
Setting page margins
Formatting properties
Working with absolute formatting
Adding borders, color, and shading to a field
Making a report, section, area, or object read-only
Locking an object's size and position
Changing your default field formats
Adding and editing lines
Adding and editing boxes
Adding shapes to a report
Repeating report objects on horizontal pages
Using white space between rows
Working with conditional formatting
Conditional on or off properties
Conditional attribute properties
Changing margins conditionally
Changing X position conditionally
Creating footers after the first page
Using the Highlighting Expert
Undo/Redo activities
Using the Format Painter
To copy and apply formatting


Charting
Charting concepts
Charting overview
Chart layouts
Chart types
Where to place a chart
Drill-down with charts
Drill-down with legends
Creating charts
Charting on details or formula fields (Advanced layout)
Charting on summary or subtotal fields (Group layout)
Charting on Cross-Tab summaries (Cross-Tab layout)
Working with charts
Editing charts using the Chart Expert
Editing charts using the Chart Options menu items


Cross-Tab Objects
What is a Cross-Tab object?
Cross-Tab example
Report of order data - no sorting/grouping
Report of order data - grouped by region
Report of order data - grouped by product
Report of order data - grouped by region and product
Order data in a Cross-Tab object
Creating a Cross-Tab report
Selecting records
Defining the structure of the Cross-Tab
Applying a predefined style and finishing the report
Adding a Cross-Tab to an existing report using the Cross-Tab Expert
Working with Cross-Tabs
Formatting Cross-Tabs
Changing width, height, and alignment of Cross-Tab cells
Formatting background color of entire rows/columns
Formatting fields individually
Formatting several fields at one time
Suppressing Cross-Tab data
Displaying summarized fields horizontally


Printing, Exporting, and Viewing Reports
Distributing reports
Printing a report
Exporting a report
Viewing reports
Report Parts and other Report objects


Report Alerts
About Report Alerts
Working with Report Alerts
Creating Report Alerts
Editing Report Alerts
Deleting Report Alerts
Viewing Report Alerts
Referring to Report Alerts in formulas


Using Formulas
Formulas overview
Typical uses for formulas
Formula components and syntax
Formula components
Formula syntax
Specifying formulas
Working with the Formula Workshop
Working with the Formula Editor
Creating and modifying formulas
To create a formula and insert it into a report
Creating a formula in the Formula Expert
Editing formulas
Searching for formula text
Copying formulas
Deleting formulas
Removing the working formula from your report
Error Messages and Formula Compiler Warnings


Parameter Fields and Prompts
Parameter and prompt overview
Parameter field considerations
Prompt considerations
Data and non-data parameters
Optional parameters
Understanding dynamic prompts
Understanding lists of values
List-of-values types
Determining which list-of-values type to use
Lists of values and prompt groups contrasted
Creating a parameter with a static prompt
To create a parameter with a static prompt
To incorporate the parameter into the record selection filter
To incorporate the parameter into a saved data selection formula
Creating a parameter with a dynamic prompt
To create a parameter with a dynamic prompt
Creating a parameter with a cascading list of values
To create a parameter with a cascading list of values
The Parameter Panel
Working with lists of values
Long lists of values
Best practices for prompting
Unmanaged reports
Managed reports
Deleting parameter fields
To delete a parameter that is not used in a formula
To delete a parameter used with the Select Expert
To delete a parameter that is used in a formula
Responding to parameter field prompts
Previewing a report for the first time
Refreshing report data



Subreports:
What are subreports?
Unlinked vs. linked subreports
How subreport linking works
Inserting subreports
Previewing subreports
Saving a subreport as a primary report
Updating subreports
Linking a subreport to the data in the primary report
To link a subreport to the data in the primary report
Linking a subreport to the main report without modifying the selection formula
To link a subreport to a main report without modifying the selection formula

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 10)

₹ 10,000

Enquire

Post your requirement and let us connect you with best possible matches for Crystal Reports Training Post your requirement now
₹ 10,000 Enquire

Enquire

Submit your enquiry for Crystal Reports Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Raja

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more