Share via


Debugging Custom Assemblies

The Microsoft .NET Framework provides several debugging tools that can help you analyze your custom assembly code and locate errors in it. The best tool to use will depend on what you are trying to accomplish. This example uses Microsoft Visual Studio 2005.

The recommended way to design, develop, and test custom assemblies for Reporting Services is to create a solution that contains both your test reports and your custom assembly.

Procedures

To debug assemblies using a single instance of Visual Studio

  1. Create a new report project using Visual Studio.

    At the time you create a report project, Visual Studio also creates a solution to contain it.

  2. Add a new Class Library project to the existing solution. Make sure that the report project is set as the startup project. For more information about how to accomplish this, see your Visual Studio 2005 documentation.

  3. In Solution Explorer, select the solution.

  4. On the View menu, click Property Pages.

    The Solution Property Pages dialog box opens.

  5. In the left pane, expand Common Properties if necessary, and click Project Dependencies. Select the report project from the Project drop-down list. Select your assembly project in the Depends On list.

  6. Click OK to save the changes, and close the Property Pages dialog.

  7. In Solution Explorer, select your custom assembly project.

  8. On the View menu, click Property Pages.

    The Project Property Pages dialog box opens.

  9. In the left pane, expand Configuration Properties, and click Build if you're in a C# project or Compile if you're in a Visual Basic project.

  10. On the Build/Compile page, enter the path to the Report Designer folder. By default, this is C:\Program Files\Microsoft SQL Server. Server\90\Tools\Binn\VSShell\Common7\IDE) in the Output Path text box. This builds and deploys an updated version of your custom assembly directly to Report Designer before your report is executed.

  11. Once you have designed your report and developed your custom assembly, set breakpoints in your custom assembly code.

  12. Run the report under DebugLocal mode by pressing the F5 key. When the report executes in the pop-up preview window, the debugger hits any breakpoints that correspond to executable code in your assembly. Use F11 to step through your custom assembly code.

To debug assemblies using two instances of Visual Studio

  1. Launch Visual Studio .NET 2005 and open your custom assembly project.

  2. Build the project, and deploy your custom assembly and the accompanying .pdb file to the Report Designer. For more information about deployment, see Deploying a Custom Assembly.

  3. Open up a report project that uses your custom assembly while leaving your custom assembly code open in a separate instance of Visual Studio.

  4. Navigate to the instance of Visual Studio that contains your custom assembly project and set some break points in your code.

  5. With the custom assembly project still the active window, click Process on the Debug menu.

    The Processes dialog opens.

  6. From the list of processes, select the devenv.exe process that corresponds to your Report Project and click Attach. When the Attach to Process dialog opens, make sure that the program type Common Language Runtime is selected, and then click OK.

  7. Define the expressions that you will use in your report from your custom assembly and design your report.

  8. When you are finished designing your report, click the Preview tab.

    The report executes, and the custom assembly code should break at your predefined break points.

    Note

    Using the Preview tab does not enforce code permissions for the assembly. For a complete test, which includes any code access security errors, start the report project under the DebugLocal configuration setting.

  9. Step through your code using the F11 key. For more information about debugging using Visual Studio, see the Visual Studio 2005 documentation.

Change History

Release History

17 July 2006

Changed content:
  • Update to reflect Visual Basic UI.

See Also

Other Resources

Using Custom Assemblies with Reports

Help and Information

Getting SQL Server 2005 Assistance