Log in to start a topic

Passing paramters to a Code Base Active Report 17 on MVC 4.8

Posted by: newton.chan on 11 September 2023, 8:06 am EST

  • newton.chan

    • Post Options:
    • Link
      Copy

    Posted 11 September 2023, 8:06 am EST - Updated 11 September 2023, 8:08 am EST

    We need to send some JSON and Data from the JS on the CSHTML to the GetReport() on the STartup.cs

    The report is a Section Report “Code base” in .cs format and not .rpx

    i tried this to send a param value from JS named “repData” to the GetRport()

    on index.html

    
<!DOCTYPE html>
<html lang="en">

<head>
  <!-- IIS Virtual Directory name -->
  <!--<base href="/JSViewer_MVC/">-->

  <meta charset="utf-8">
  <link rel='shortcut icon' type='image/x-icon' href='favicon.ico' />
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="theme-color" content="#000000">
  <title>JS Viewer</title>
  <link href="jsViewer.min.css" rel="stylesheet">
  <link href="index.css" rel="stylesheet">
</head>

<body onload="loadViewer()">
  <div style="width: 100%; overflow-x: hidden">
    <div style="float:right;width:100%" id="viewerContainer">
    </div>
  </div>
  <script type="text/javascript" src="jsViewer.min.js"></script>
  <script type="text/javascript">
      window.onload = function () {
          loadViewer();      
      } 

    let viewer;

    function loadViewer() {
      viewer = GrapeCity.ActiveReports.JSViewer.create({
          element: '#viewerContainer',
          reportParameters: [{ name: 'repData', values: ['test'] }]
      });
        viewer.openReport("SectionReport1.cs");
    }
  </script>
</body>
</html>

    on Startup.cs

     public object GetReport(string reportId)
        {
            SectionReport rpt = new SectionReport1();
            var param = new Parameter();
            param.Key = "repData";
            param.Type = Parameter.DataType.String;

            rpt.Parameters.Add(param);
	}

    on SectionReport1.cs i have added a paramter named “repData” and saved the report.

    but the paramters is not sent along with the call or assigned

    How we can do this???

  • anand.sinha

    Posted 11 September 2023, 8:37 pm EST

    Hi Newton,

    The ‘viewer.openReport()’ method accepts a reportID and report Parameter array you can pass your parameters into the same to show in your report.

    Refer to the code snipper below:

    viewer.openReport("CodeReport.cs", [{ name: 'repData', values: ['test'] }])

    And this will work as expected.

    Please find attached a sample implementing the same.

    To learn more about the JSViewer API please refer to JS Viewer API.

    Regards,

    Anand

    JSViewer_MVC.zip

  • newton.chan

    Posted 12 September 2023, 1:01 am EST

    we tried this before and It is NOT working

    we need to send a long JSON object to the report

    this is a sample of the paramter we need to send

            var reportInfo = "COUNTLIST#%&{&quot;SelectedOption&quot;:&quot;1&quot;,&quot;SelectedRowId&quot;:&quot;f51c4d8b-fec7-4c62-b8c6-d53e243a65b1&quot;,&quot;IsStoreCount&quot;:false,&quot;Description&quot;:null,&quot;SearchValue&quot;:null,&quot;SearchBy&quot;:null,&quot;SearchCriteria&quot;:&quot;Equals&quot;,&quot;StoreID&quot;:&quot;001&quot;,&quot;HostStoreID&quot;:null,&quot;StoreName&quot;:&quot;Test Store&quot;,&quot;IsShowExported&quot;:true,&quot;CountBatches&quot;:[{&quot;ID&quot;:&quot;f51c4d8b-fec7-4c62-b8c6-d53e243a65b1&quot;,&quot;CountID&quot;:&quot;20230911-DAILYCC&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;DAILY MANUAL COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-11 5:51:29 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:1,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;f9e1c258-eaa4-43cc-8772-2ea5f870dd9a&quot;,&quot;CountID&quot;:&quot;20230909-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-09 1:00:05 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:201,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;75be069a-add6-4841-9233-adf583186109&quot;,&quot;CountID&quot;:&quot;20230908-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-08 1:00:10 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:587,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;c755c9eb-9ccd-470d-bf0c-ea5d6815c5f5&quot;,&quot;CountID&quot;:&quot;20230907-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-07 1:00:09 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:202,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;68f52203-a3bd-4aff-8ebd-cb7494093253&quot;,&quot;CountID&quot;:&quot;20230905-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-05 1:00:08 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:202,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;a98b0f9f-26e6-4a9d-a6da-696c3c6fcf46&quot;,&quot;CountID&quot;:&quot;20230904-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-04 1:00:05 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:202,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;00719e29-ca82-4523-9bca-4c3b4081f347&quot;,&quot;CountID&quot;:&quot;20230903-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-03 1:00:07 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:202,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;9cc908fd-24c6-4e68-9da1-8d0bbb704d3d&quot;,&quot;CountID&quot;:&quot;20230902-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-02 1:00:11 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:204,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;06930b34-b384-490f-b6e3-8a75c879deed&quot;,&quot;CountID&quot;:&quot;20230901-CYC-03&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;AutomationBatch&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-01 8:37:42 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:25,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;d229a8d0-d0e3-4f9a-9934-67717a549ae2&quot;,&quot;CountID&quot;:&quot;20230901-CYC-02&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;AutomationBatch&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-01 8:27:24 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:24,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;cdf50793-12df-4b3a-adbf-6699d446acad&quot;,&quot;CountID&quot;:&quot;20230901-CYC-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;AutomationBatch&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-01 5:52:22 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:0,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;84dc0f74-c940-4419-9b07-dadecc1944ba&quot;,&quot;CountID&quot;:&quot;20230901-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-09-01 1:00:12 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:204,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;422a0783-2969-4a3b-ba37-45dbbebf204a&quot;,&quot;CountID&quot;:&quot;20230831-HOST-02&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HostTestCount&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-31 3:49:22 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:1,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;55fe41d2-48f9-43bc-b737-166598e86bb9&quot;,&quot;CountID&quot;:&quot;20230831-CYC-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;TestABC&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-31 3:47:39 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:2,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;e01a1f75-913d-4a67-ba8d-d81f7dd824f2&quot;,&quot;CountID&quot;:&quot;20230831-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-31 1:00:10 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:200,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;25e6fffb-6b65-46e5-8f3a-c86369314001&quot;,&quot;CountID&quot;:&quot;20230830-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-30 1:00:07 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:199,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;9d60c4be-6e5d-4378-a1e3-d468e6a5b1da&quot;,&quot;CountID&quot;:&quot;20230829-CYC-04&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;AutomationBatch&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;CLOSED&quot;,&quot;DateClosed&quot;:&quot;2023-08-29 10:35:29 AM&quot;,&quot;DateCreated&quot;:&quot;2023-08-29 10:31:05 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:24,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;53fd7ae7-3ca8-4d0f-97a1-4d03bfb98ce5&quot;,&quot;CountID&quot;:&quot;20230829-CYC-03&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;AutomationBatch&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-29 9:54:55 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:24,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;73bc4af8-5d74-49c6-a830-a2d06387775a&quot;,&quot;CountID&quot;:&quot;20230829-CYC-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;AutomationBatch&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-29 8:06:33 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:true,&quot;ProductsCount&quot;:10,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null},{&quot;ID&quot;:&quot;7196cb7d-d5ba-4aa3-bd51-01182a51af53&quot;,&quot;CountID&quot;:&quot;20230829-HOST-01&quot;,&quot;BatchNo&quot;:null,&quot;Description&quot;:&quot;HOST COUNT&quot;,&quot;StoreInventory&quot;:false,&quot;Status&quot;:&quot;IN PROGRESS&quot;,&quot;DateClosed&quot;:null,&quot;DateCreated&quot;:&quot;2023-08-29 1:00:06 AM&quot;,&quot;DateVerified&quot;:null,&quot;DateExported&quot;:null,&quot;IsStoreCount&quot;:false,&quot;StoreID&quot;:null,&quot;StoreName&quot;:null,&quot;GroupBy&quot;:null,&quot;IsAssigned&quot;:false,&quot;ProductsCount&quot;:202,&quot;ShowUPCVarianceReport&quot;:false,&quot;ShowUPCDetailReport&quot;:false,&quot;ProductsCounted&quot;:0,&quot;LoginUserId&quot;:null,&quot;DetailGridSort&quot;:null,&quot;AccGridSort&quot;:null}],&quot;spi&quot;:{&quot;SortField&quot;:&quot;CYCCREDATE&quot;,&quot;SortMessage&quot;:&quot;Created Descending&quot;,&quot;SortFieldHeader&quot;:null,&quot;SortDirection&quot;:&quot;DESC&quot;,&quot;PageSize&quot;:20,&quot;PageCount&quot;:20,&quot;CurrentPageIndex&quot;:0,&quot;RowCount&quot;:398,&quot;PageStartIndex&quot;:1,&quot;PageEndingIndex&quot;:20},&quot;isError&quot;:false,&quot;Message&quot;:&quot;&quot;}";

    Which contains 2 parts of data delimited by 

    #%&

    so it has 1st ‘COUNTLIST’ then a long JSON

    how to send this ?

    it was fine on old way on Active Report 9 and 11 with the deprecated methods and we need to do the same on AR 17

  • newton.chan

    Posted 12 September 2023, 11:49 pm EST - Updated 12 September 2023, 11:54 pm EST

    I have tried to encode the parameter to Base64 and send it along the URL but getting the error below

    1778×323 155 KB

    please provide a solution to the issue as sending such info to the report while building it is mandatory.

  • anand.sinha

    Posted 13 September 2023, 8:33 pm EST

    Hi Newton,

    This seems to be a duplicate of your support ticket: CAS-43097-Y9Z4R5. We have updated the response in the same.

    We’ll recommend you continue the thread either here or at the support ticket to avoid any confusion.

    Thanks,

    Anand

  • newton.chan

    Posted 14 September 2023, 2:51 am EST

    we will continue on the support ticket itself

  • anand.sinha

    Posted 14 September 2023, 7:42 pm EST

    Hi Newton,

    Sure thanks for notifying we will continue the thread there!

    Regards,

    Anand

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels

  • © 2023 MESCIUS inc. All Rights Reserved.  ·  1.800.858.2739

    All product and company names herein may be trademarks of their respective owners.