Based on multiple parameters report has to split to multiple

You want to split your report dynamically based on multiple selected parameter values — for example, when a user selects multiple IDs (say 1,2,3) in a dropdown parameter, your reporting tool should automatically generate separate sub-reports (or pages) for each selected ID.

Let’s go through the approach depending on your reporting environment:

Option 1: SSRS (SQL Server Reporting Services)

If you’re working in SSRS (Report Builder / Visual Studio), here’s how to do it:

Step-by-Step Solution

1. Create a Multi-Value Parameter

   • Go to Report Parameters ? Add a parameter, e.g. @ID

   • Enable:

     • “Allow multiple values”

     • “Provide available values” from your dataset (e.g. list of IDs)

2. Filter Your Main Dataset

   • In your dataset query, use an IN filter:

     SELECT *
     FROM YourTable
     WHERE ID IN (@ID)
     

     SSRS automatically converts multi-select parameters into comma-separated lists internally.

3. Group by ID in the Report

   • Insert a Table or List.

   • Right-click ? Group Properties ? Group by =Fields!ID.Value.

   • Inside each group, display your data for that ID.

4. Page Break Between IDs

   • In the Group Properties ? Page Breaks, check:
     “Between each instance of a group”

   • This ensures each ID’s data starts on a new page.

Result:
When you select multiple IDs (like 1 and 2), your report automatically generates:

• Page 1 ? Report for ID = 1

• Page 2 ? Report for ID = 2

Option 2: Crystal Reports (if you’re using that)

In Crystal Reports, the idea is similar:

1. Create a multi-select parameter for IDs.

2. In the Record Selection Formula, filter using:

   {YourTable.ID} in {?ID}
   

3. Create a Group by ID.

4. In Section Expert, enable “New Page After” for the ID group.

Option 3: Generate Reports Programmatically (C# / .NET)

If you’re generating reports using code (like ReportViewer in ASP.NET or Windows Forms):

foreach (int id in selectedIds)
{
    ReportViewer reportViewer = new ReportViewer();
    reportViewer.LocalReport.ReportPath = "YourReport.rdlc";
    reportViewer.LocalReport.SetParameters(new ReportParameter("ID", id.ToString()));
    reportViewer.RefreshReport();
    
    // Export each to PDF or display one by one
}

This loop generates a separate report for each selected parameter.

tip: Dynamic File Export (per ID)

If you want to automatically export each report to a separate file:

• Use ID in file name (e.g., Report_ID1.pdf, Report_ID2.pdf).

• SSRS subscription or custom script can automate it.