How to pass multiple values using custom data

To pass multiple custom data values to the Bold Reports^® ASP.NET Web Forms Report Viewer Web API, send them as JSON through the ‘data’ property in the ajaxBeforeLoad event. Then deserialize them in the server-side API with a known class type and JsonConvert.DeserializeObject.

1. Map the ajaxBeforeLoad event with the onAjaxRequest function in the script to pass custom data to the server.

   <div style="height: 650px;width: 950px;min-height:404px;">
    <Bold:ReportViewer runat="server" ID="viewer"
        ReportServiceUrl="/api/ReportViewer"
        ReportPath="~/Resources/sales-order-detail.rdl"
        OnClientAjaxBeforeLoad="onAjaxRequest">
    </Bold:ReportViewer>
   </div>

    <script>
    function onAjaxRequest(args) {
    //Passing custom data to server
    }
    </script>

2. Pass the multiple custom data values as JSON and use the data property to send the custom data to the server in the Ajax request.

   <script>
   function onAjaxRequest(args){
       //Passing custom data to server
       var jsonData = {
           customerID: "CI0021",
           productID: "PO0022"
       }
       args.data = jsonData;
   }
   </script>

3. The custom data values are stored in the customData header key, and you can store them in the local property. The following code sample deserializes the JSON string and changes the data source connection strings based on the Customer ID and Product ID in the OnInitReportOptions method.

       public SampleData customDatas = new SampleData();
   
       public class SampleData
       {
           public string customerID { get; set; }
           public string productID { get; set; }
       }
   
       [HttpPost]
       public object PostReportAction([FromBody]Dictionary<string, object> jsonResult)
       {
           if (jsonResult != null)
           {
               if (jsonResult.ContainsKey("customData"))
               {
                   //Get client side custom data and store in local variable.
                   customDatas = JsonConvert.DeserializeObject<SampleData>(jsonResult["customData"].ToString());
               }
           }
   
           return ReportHelper.ProcessReport(jsonResult, this, this._cache);
       }
   
       public void OnInitReportOptions(ReportViewerOptions reportOption)
       {
           if (customDatas != null)
           {
               if (customDatas.customerID == "CI0021" && customDatas.productID == "PO0022") {
                   //If you are changing the connection string based on customer id then could you please change the connection string as below.
                   //reportOption.ReportModel.DataSourceCredentials.Add(new BoldReports.Web.DataSourceCredentials("<Datasource name>", "<connection string>"));
                   reportOption.ReportModel.DataSourceCredentials.Add(new BoldReports.Web.DataSourceCredentials("<database>", "Data Source=<instancename>;Initial Catalog=<database>;"));
               }
           }
       }