In the previous movie, I showed you how to create a subreport within a main report, but there wasn't a link between the two data sets. Now learn how to create a linked subreport that displays values related to the current row of the main report. In some ways, linked subreports are like groups.
- [Instructor] In the previous movie,…I showed you how to create a subreport within a main report,…but with no link between the two data sets.…In this movied, I will show you how to create…a linked subreport that displays values…related to the current row of the main report.…My Crystal Reports file that I'll use…as my base of operations is the linked report,…and you can find it in the Chapter 10 folder…of your Exercise Files collection.…I have a very simple report and you can see…that it consists of two columns or two fields of data,…category ID, and category name.…
What I'd like to do is to add a subreport…to the detail section so I can see all the products…that are related to those categories.…To do that, I need to insert my subreport,…so I'll go to the Insert menu,…and about half-way down, click Subreport.…Using the controls in the Insert Subreport dialog box,…I will leave the Create a Subreport With the Report Wizard…option selected, if I wanted to link to an existing report,…I could select the top option, Choose an Existing Report,…
Author
Curt Frye
Released
1/11/2017- Setting program and report options
- Changing the page layout
- Linking to a data source
- Adding fields to a report
- Creating sections
- Sorting and grouping data
- Formatting number, dates, and other fields and objects
- Adding charts
- Selecting records
- Managing reports with parameter fields
- Summarizing data with formulas and cross-tabs
- Adding subreports
- Exporting reports
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 15s
-
-
1. Getting to Know Crystal Reports 2016
-
Set program options2m 17s
-
Set report options3m 45s
-
Assign report properties2m 5s
-
Navigate within a report3m 14s
-
2. Creating a Report
-
Link to a data source1m 59s
-
Add fields to a report3m 3s
-
Save a report3m 45s
-
3. Managing Report Sections
-
Create a section4m 38s
-
Resize a report section1m 46s
-
Merge report sections1m 29s
-
Manage section order2m 13s
-
Hide report sections1m 30s
-
Delete a section1m 47s
-
-
4. Sorting and Grouping Data
-
Sort data3m 48s
-
Define a group2m 21s
-
Reorder and delete groups2m 37s
-
Change group options3m 13s
-
Create a summary3m 7s
-
Define statistical summaries3m 50s
-
Create a drill-down report2m 54s
-
Sort by group2m 25s
-
-
5. Formatting Reports and Report Elements
-
Apply a report template1m 50s
-
Format a report control5m 10s
-
Apply formats to date fields3m 37s
-
Highlight records5m 48s
-
-
6. Adding Charts to a Report
-
Available chart types6m 1s
-
Create a chart3m 36s
-
Format chart elements5m 57s
-
-
7. Selecting Records in a Report
-
8. Managing Reports Using Parameter Fields
-
Allow dynamic parameters2m 52s
-
9. Summarizing Data Using Formulas
-
The Formula Workshop4m 38s
-
Correct formula errors3m 53s
-
-
10. Adding Subreports
-
Create an unlinked subreport3m 34s
-
Create a linked subreport4m 37s
-
Format subreports4m 13s
-
-
11. Summarizing Data Using Cross-Tabs
-
Add a cross-tab to a report3m 14s
-
Manipulate a cross-tab3m 12s
-
Sort cross-tab group values2m 50s
-
Format a cross-tab2m 57s
-
12. Exporting Report Data
-
Export to Excel2m 33s
-
-
Conclusion
-
Next steps1m 20s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create a linked subreport