ASP.NET中RDLC报表开发：如何根据唯一ID生成报表？

Hey there! Let's walk through how you can generate an RDLC report filtered by a unique Reservation ID in your ASP.NET MVC app. Here's a step-by-step breakdown tailored to your existing setup:

First, modify your action method to take an additional id parameter (the unique identifier for the reservation you want to report on). We'll also add logic to filter your dataset to only include the matching reservation and its details.

public ActionResult Reports(string ReportType, int? id)
{
    // Validate the ID first
    if (id == null)
    {
        return RedirectToAction("Index"); // Send user back to reservations list if ID is missing
    }

    LocalReport localreport = new LocalReport();
    localreport.ReportPath = Server.MapPath("~/Reports/Report_Reservatie.rdlc");

    // Fetch the specific reservation (and its details) using the ID
    using (var dbContext = new YourDbContextName()) // Replace with your actual DbContext class
    {
        // Use Include() to load associated ReservationDetails (critical if your report shows details!)
        var filteredReservations = dbContext.Reservations
                                            .Include(r => r.ReservationDetails)
                                            .Where(r => r.Id == id.Value)
                                            .ToList();

        ReportDataSource reportDataSource = new ReportDataSource();
        reportDataSource.Name = "DataSet_Reservaties"; // Must match the dataset name in your RDLC EXACTLY
        reportDataSource.Value = filteredReservations;
        localreport.DataSources.Add(reportDataSource);

        // Optional: Add a report parameter if your RDLC uses it (e.g., to display the reservation ID in the header)
        localreport.SetParameters(new ReportParameter("ReservationId", id.Value.ToString()));
    }

    // Render the report based on the requested type (PDF, Excel, etc.)
    string mimeType;
    string encoding;
    string fileNameExtension;
    string[] streams;
    Warning[] warnings;

    byte[] renderedBytes = localreport.Render(
        ReportType,
        null,
        out mimeType,
        out encoding,
        out fileNameExtension,
        out streams,
        out warnings);

    // Return the report as a downloadable file with a meaningful name
    return File(renderedBytes, mimeType, $"Reservation_{id.Value}.{fileNameExtension}");
}

• Dataset Name Match: Double-check that DataSet_Reservaties matches the exact name of the dataset defined in your RDLC report (case-sensitive!). If they don't match, the report will show empty data.
• Load Associated Details: Use Include(r => r.ReservationDetails) to ensure the related ReservationDetails data is loaded—otherwise, the details section of your report will be blank.
• Report Parameters: If you want to display the reservation ID in your report (e.g., in a header), you'll need to:
  1. Create a parameter named ReservationId in your RDLC report (via Report Data pane > Parameters > Add Parameter)
  2. Reference that parameter in your report's text boxes (e.g., =Parameters!ReservationId.Value)

In your Reservations list view (e.g., Views/Reservations/Index.cshtml), add a link/button for each reservation that triggers the report action with the correct ID:

@foreach (var reservation in Model)
{
    <tr>
        <td>@reservation.Id</td>
        <td>@reservation.CustomerName</td>
        <!-- Add other reservation fields here -->
        <td>
            <a href="@Url.Action("Reports", "Reservations", new { ReportType = "PDF", id = reservation.Id })" target="_blank">
                Download PDF Report
            </a>
            <a href="@Url.Action("Reports", "Reservations", new { ReportType = "EXCEL", id = reservation.Id })" target="_blank" style="margin-left: 10px;">
                Download Excel Report
            </a>
        </td>
    </tr>
}

• If the report shows no data: Verify your query returns the correct reservation (check filteredReservations in debug mode), and confirm the dataset name in code matches the RDLC.
• If you get a "data source not found" error: Double-check the ReportDataSource.Name value against the dataset name in your RDLC.
• If details are missing: Ensure your Reservation model has a navigation property for ReservationDetails, and you're using Include() to load it.

内容的提问来源于stack exchange，提问作者user5303319