Multiple Copies of Invoice

Check the below code, this may help you to resolve your issue.

private void btnPrint_Click(object sender, EventArgs e)
{
    // Assuming parameterValue is the variable storing the user-selected parameter value (Original/Duplicate/Triplicate/ALL)
    string parameterValue = "your-parameter-value";
    switch (parameterValue)
    {
        case "Original":
            PrintReport("Original");
            break;
        case "Duplicate":
            PrintReport("Duplicate");
            break;
        case "Triplicate":
            PrintReport("Triplicate");
            break;
        case "All":
            PrintReport("Original");
            PrintReport("Duplicate");
            PrintReport("Triplicate");
            break;
        default:
            // Handle any other cases or errors
            break;
    }
}

private void PrintReport(string selectedOption)
{
    ConnectionInfo connectionInfo = new ConnectionInfo
    {
        ServerName = @"Your-Server-Name",
        DatabaseName = "SampleDB",
        UserID = "sa",
        Password = "pa$$w0rd"
    };

    ReportDocument reportDocument = new ReportDocument();
    reportDocument.Load("path_to_your_report_file.rpt");
    reportDocument.SetParameterValue("SelectedOption", selectedOption);

    TableLogOnInfo tableLogOnInfo = new TableLogOnInfo();
    Tables crTables = _reportDocument.Database.Tables;
    foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
    {
        tableLogOnInfo = crTable.LogOnInfo;
        tableLogOnInfo.ConnectionInfo = connectionInfo;
        crTable.ApplyLogOnInfo(tableLogOnInfo);
    }

    reportDocument.Refresh();
    reportDocument.PrintToPrinter(1, false, 0, 0);
}

To achieve this functionality in Crystal Report using C#, you can follow these steps:

1. Create a parameter in your Crystal Report design to capture the user's selection. Let's call it CopyType. Set the parameter type to "String" and provide the available values as "Original," "Duplicate," "Triplicate," and "ALL."

2. In your Crystal Report design, add the necessary sections for each copy of the invoice. For example, you can have three sections: "Original," "Duplicate," and "Triplicate." Design each section according to your requirements.

3. In the section expert for each copy section, go to the "Common" tab and set the "Suppress" formula. Use the following formula for each section:

• For "Original" section:

• {CopyType} <> "Original"
  

• For "Duplicate" section:

• {CopyType} <> "Duplicate"
  

• For "Triplicate" section:

  {CopyType} <> "Triplicate"
  

• In the section expert for the "ALL" section, set the "Suppress" formula as follows:{CopyType} <> "ALL"

• {CopyType} <> "ALL"

• In your C# code, pass the user's selection to the Crystal Report parameter. Here's an example:

ReportDocument report = new ReportDocument();
report.Load("path_to_your_report.rpt");

// Set the parameter value
report.SetParameterValue("CopyType", "Original"); // Replace "Original" with the user's selection

// Print the report
report.PrintToPrinter(1, false, 0, 0);