Data Dynamics Reports Online Help
Walkthrough: Drill-Through
See Also Support Forum
User Guide > Samples and Walkthroughs > Walkthroughs > Walkthroughs: Interactive Reports > Walkthrough: Drill-Through

Glossary Item Box

This walkthrough expands upon the report created in the Walkthrough: Basic Report. If you have not created the basic report already, please do so before continuing.

This walkthrough illustrates how to create a drill-through link to another report containing details about the linked item. 

The walkthrough is split up into the following activities:

To complete the walkthrough, you must have access to the Reels sample database included with this installation.

When you are finished you will have a report that looks similar to the following.

Creating a detail report and saving it into the basic report folder

To create a report in Visual Studio

  1. Open the Basic Report project you created previously in Visual Studio.
  2. From the Visual Studio Project menu, select Add New Item.
  3. In the Categories pane, select Data Dynamics Reports.
  4. In the Templates pane, select Report and name the report MovieDetails.rdlx.
  5. Click Add in Visual Studio 2005. 

Connecting the detail report to a data source

To connect the detail report to a data source

  1. If the Data Explorer is not in view, from the View menu, select Other Windows, then Data Dynamics Reports Data Explorer (at the bottom).
  2. Click the Add icon and select the Data Source... option.
  3. In the Report DataSource smart panel that appears, select the General page.
  4. Change the Name to Reels.
  5. Select the Shared Reference checkbox.

  6. Click the Browse button and select ReelsDataSource.rdsx, which is located in C:\My Documents\Data Dynamics\Reports\build number\Samples\Reels.
    Note: In Windows Vista, the path is C:\User\your name\Documents\Data Dynamics\Reports\build number\Samples\Reels\.
  7. Click the Accept button in the lower right corner to close the smart panel and see Reels appear in the Data Explorer.

Adding a Dataset with a parameter

To add a Dataset with a parameter

  1. Click the Add icon and select the Data Set... option.
  2. In the DataSet smart panel that appears, select the General page.
  3. Change the Name to MovieInfo.
  4. On the Parameters page under Parameter Name enter MovieID.
  5. Under Value enter 
    =Parameters!MovieID.Value
  6. On the Query page, paste the following SQL command into the Query text box:
     

    SELECT * FROM MovieCastInformation;

  7. Click the Validate icon to validate the query and to populate the Fields list.
  8. Click the Accept button in the lower right corner to close the smart panel and see MovieInfo and the selected fields appear in the Data Explorer.

Creating a Dataset to populate the parameter values

To create a Dataset to populate the parameter values

  1. Click the Add icon and select the Data Set... option.
  2. In the DataSet smart panel that appears, select the General page.
  3. Change the Name to MovieTitles.
  4. On the Query page, paste the following SQL command into the Query text box:
     

    SELECT MovieID, Title FROM Movie
    ORDER BY Title ASC;

  5. Click the Validate icon to validate the query and to populate the Fields list.
  6. Click the Accept button in the lower right corner to close the smart panel and see MovieTitles and the selected fields appear in the Data Explorer.

Adding a Report Parameter

To add a Report Parameter

    1. In Layout view, click in or below the report body to ensure that the report has focus.
    2. From the Report menu, select Report Parameters.
    3. In the Report Parameters smart panel that appears, click the Add button to add a parameter.
    4. Change the Name to MovieID.
    5. Change the Data type to Integer. (This data type must match that of the field.)
    6. Enter the following text to prompt users for a value: Movie.

  1. To provide a list of values for the Report Parameter

    1. Just below the list of parameters, click the Values icon.
    2. Under Available Values, select From query.
    3. Under Dataset, select MovieTitles.
    4. Under Value field, select MovieID.
    5. Under Label field, select Title.
    6. Click the Accept button in the lower right corner to close the smart panel and add the parameter to the collection.

Adding controls to the report to contain data

To add data regions to the report

  1. From the toolbox, drag a List data region onto the body of the report.
    • With the new list selected in the property grid, set the DataSetName property to MovieInfo.
    • Set the Location property to 0in, 0in.
    • Set the Name property to MovieList.
    • Set the Size property to 6.5in, 1.25in.
    • Right-click the list and select Properties.
    • On the Detail Grouping page, set the Group on: Expression to =Fields!MovieID.Value.
    • Click the Accept button in the lower right corner to close the smart panel and accept the changes.
  2. From the toolbox, drag another List data region onto the first list.
    • With the new list selected in the property grid, set the DataSetName property to MovieInfo.
    • Set the Size property to 1.5in, 0.25in.
    • Set the Location property to 4.75in, 1in.
    • Set the Name property to GenreList.
    • Right-click the list and select Properties.
    • On the Detail Grouping page, set the Group on: Expression to =Fields!GenreID.Value.
    • Click the Accept button in the lower right corner to close the smart panel and accept the changes.
  3. From the toolbox, drag another List data region onto the first list to the left of GenreList.
    • With the new list selected in the property grid, set the DataSetName property to MovieInfo.
    • Set the Size property to 3.125in, 0.25in.
    • Set the Location property to 0in, 1in.
    • Set the Name property to CrewList.
    • Right-click the list and select Properties.
    • On the Detail Grouping page, set the Group on: Expression to =Fields!CrewTitleID.Value.
    • Click the Accept button in the lower right corner to close the smart panel and accept the changes.
  4. From the toolbox, draw another List data region onto CrewList. (Draw it small so that it doesn't change the size of CrewList.)
    • With the new list selected in the property grid, set the DataSetName property to MovieInfo.
    • Set the Size property to 1.875in, 0.25in.
    • Set the Location property to 1in, 0in.
    • Set the Name property to CastNameList.
    • Right-click the list and select Properties.
    • On the Detail Grouping page, set the Group on: Expression to =Fields!MoviePersonID.Value.
    • Click the Accept button in the lower right corner to close the smart panel and accept the changes.

To add data fields to the report

  1. From the Data Explorer, drag the Title field onto the main MovieList data region.
    • With the new textbox selected in the property grid, set the Location property to 0in, 0in.
    • Set the Name property to MovieTitle.
    • Set the Size property to 6.5in, 0.375in.
    • Set the TextAlign property to Center and the FontSize property to 14pt.
  2. From the Data Explorer, drag the YearReleased field onto the main MovieList data region just below the Title textbox.
    • With the new textbox selected in the property grid, set the Location property to 1in, 0.375in.
    • Set the Name property to YearReleased.
    • Set the Size property to 0.75in, 0.25in.
    • Set the TextAlign property to Left.
  3. From the Data Explorer, drag the MPAA field onto the main MovieList data region to the right of the YearReleased textbox.
    • With the new textbox selected in the property grid, set the Size property to 0.5in, 0.25in.
    • Set the Location property to 6in, 0.375in.
    • Set the Name property to MPAA.
  4. From the Data Explorer, drag the UserRating field onto the main MovieList data region below the YearReleased textbox.
    • With the new textbox selected in the property grid, set the Location property to 1in, 0.625in.
    • Set the Name property to UserRating.
    • Set the Size property to 0.25in, 0.25in.
    • Set the TextAlign property to Left.
  5. From the Data Explorer, drag the Length field onto the main MovieList data region below the MPAA textbox.
    • With the new textbox selected in the property grid, set the Location property to 4.75in, 0.625in.
    • Set the Name property to Length.
    • Set the Size property to 1.75in, 0.25in.
    • Set the TextAlign property to Left.
    • Add a string to the length data value so that it reads: =Fields!Length.Value & " minutes"
  6. From the Data Explorer, drag the CrewTitle field onto the CrewList data region and drop it in the top left corner of the list.
    • With the new textbox selected in the property grid, set the Location property to 0in, 0in.
    • Set the Name property to CrewTitle.
    • Set the Size property to 0.875in, 0.25in.
    • In the Report Formatting tool bar, click the Bold button.
    • Add a string to the CrewTitle data value so that it reads: =Fields!CrewTitle.Value & "s:"
  7. From the Data Explorer, drag the CastName field onto the nested CastNameList data region and drop it in the top left corner of the list.
    • With the new textbox selected in the property grid, set the Location property to 0.125in, 0in.
    • Set the Name property to CastName.
    • Set the Size property to 1.75in, 0.25in.
  8. From the Data Explorer, drag the GenreName field onto the GenreList data region to the right of  the CrewTitle textbox.
    • With the new textbox selected in the property grid, set the Location property to 0.125in, 0in.
    • Set the Name property to GenreName.
    • Set the Size property to 1.25in, 0.25in.

To add labels to the report 

  1. From the toolbox, drag a TextBox onto the main MovieList data region to the left just below the Title textbox.
    • With the new textbox selected in the property grid, set the Location property to 0in, 0.375in.
    • Set the Name property to ReleaseLabel.
    • Set the Size property to 1in, 0.25in.
    • Set the Value property to Released in:.
    • In the Report Formatting tool bar, click the Bold button.
  2. From the toolbox, drag a TextBox onto the main MovieList data region to the right of the ReleaseLabel textbox.
    • With the new textbox selected in the property grid, set the Location property to 4.125in, 0.375in.
    • Set the Name property to MPAALabel.
    • Set the Size property to 1.875in, 0.25in.
    • Set the Value property to The MPAA rated this film:.
    • In the Report Formatting tool bar, click the Bold button.
  3. From the toolbox, drag a TextBox onto the main MovieList data region below the ReleaseLabel textbox.
    • With the new textbox selected in the property grid, set the Location property to 0in, 0.625in.
    • Set the Name property to UserRatingLabel.
    • Set the Size property to 1in, 0.25in.
    • Set the Value property to User rating:.
    • In the Report Formatting tool bar, click the Bold button.
  4. From the toolbox, drag a TextBox onto the main MovieList data region to the right of the UserRatingLabel textbox.
    • With the new textbox selected in the property grid, set the Location property to 1.125in, 0.625in.
    • Set the Name property to OutOfTenLabel.
    • Set the Size property to 0.625in, 0.25in.
    • Set the Value property to out of 10.
  5. From the toolbox, drag a TextBox onto the main MovieList data region below the MPAALabel textbox.
    • With the new textbox selected in the property grid, set the Location property to 4.125in, 0.625in.
    • Set the Name property to LengthLabel.
    • Set the Size property to 0.625in, 0.25in.
    • Set the Value property to Length:.
    • In the Report Formatting tool bar, click the Bold button.
  6. From the toolbox, drag a TextBox onto the main MovieList data region below the LengthLabel textbox.
    • With the new textbox selected in the property grid, set the Location property to 4.125in, 1in.
    • Set the Name property to GenreLabel.
    • Set the Size property to 0.625in, 0.25in.
    • Set the Value property to Genre:.
    • In the Report Formatting tool bar, click the Bold button.
  7. From the toolbox, drag a TextBox onto the main CastNameList data region to the right of the CrewTitle textbox.
    • With the new textbox selected in the property grid, set the Location property to 0in, 0in.
    • Set the Name property to CrewBullet.
    • Set the Size property to 0.125in, 0.25in.
    • Set the Value property to • (a bullet).
  8. From the toolbox, drag a TextBox onto the main GenreList data region to the right of the GenreLabel textbox.
    • With the new textbox selected in the property grid, set the Location property to 0in, 0in.
    • Set the Name property to GenreBullet.
    • Set the Size property to 0.125in, 0.25in.
    • Set the Value property to • (a bullet).
  9. From the File menu, select Save.

Adding a drill-through link to the basic report and passing a parameter

Pass a parameter to the target report to show only relevant data.

To add a drill-through link

  1. Open MovieRatings.rdlx in the designer.
  2. Right-click the title field in the detail section of the table (=Fields!Title.Value) and select Properties.
  3. On the Textbox Report Item smart panel that appears, select the Navigation page.
  4. Under Action, select Jump to report and select MovieDetails from the drop-down box.

To pass a parameter to the report

  1. Under Jump to report set the Name of the parameter to MovieID.
  2. Set the Value to =Fields!MovieID.Value.
    Caution: The parameter name must exactly match the parameter in the target report.
  3. Click the Accept button in the lower right corner to close the smart panel and accept the changes.
  4. From the File menu, select Save.

Viewing the report

Any report designed with Data Dynamics Reports can be opened in the included Data Dynamics Reports Viewer application or you can view it at design time.

To view the report at design time

  1. Click the Preview tab of the report designer.
  2. Click any movie title to drill through to details about the movie.
  3. Click the Back to parent report icon to return to the Movie Ratings report.

To view the report at run time

  1. Add the ReportPreview control to your Visual Studio toolbox and drop it onto your Windows form.
  2. Set the Dock property of ReportPreview1 to Fill so that it will automatically resize if the form is resized at run time.
  3. Double-click the viewer to go to the Load event and use code like the following. 
    'Visual Basic.NET 
Dim rpt As New System.IO.FileInfo(Application.StartupPath & "..\\..\\MovieRatings.rdlx") 
Me.ReportPreview1.OpenReport(rpt)
    //C# 
System.IO.FileInfo rpt = new System.IO.FileInfo(Application.StartupPath + @"..\..\..\MovieRatings.rdlx"); 
this.reportPreview1.OpenReport(rpt);
  4. Run the project.

See Also

©2010. GrapeCity, inc. All Rights Reserved.