1. Home
  2. Forum
  3. AngularJS
  4. Passing values to hidden paramater to SSRS report
Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

Passing values to hidden paramater to SSRS report

Hi,

    I'm integrating the SSRS in the angular app. I want to pass some identity related information to the SSRS report, so I don't want to show those parameters in the report at the same time I want to pass the values to the report through API or client side.

    Is this possible?

Thanks,
Joe

7 Replies
VS Vinoth Srinivasan Syncfusion Team October 24, 2019 06:51 AM UTC

Hi Joe, 

Thanks for your interest in Syncfusion products. 

Yes, you can set hidden to the parameter at report level and you can pass the value for the parameter from code behind as per your requirement. Please refer the below help documentation for passing value to parameter from code behind. 


Regards, 
Vinoth S. 


JS Joe Samraj October 25, 2019 12:09 PM UTC

Hi Vinoth,


   Thanks for your reply. We are using angularJS and also how can we pass the data from client side?

Thanks,
Joe

MS Mahendran Shanmugam Syncfusion Team October 28, 2019 11:04 AM UTC

Hi Joe, 

Thanks for your update. 

We can able to pass the datasources at client side in Angular JS platform as shown in below help documentation. 

Regards, 
Mahendran S. 


JS Joe Samraj November 4, 2019 04:35 AM UTC

Hi Mahendran,

     Thanks for reply. We are not using RDLC. I want to pass the value for a hidden parameter from client side in AngularJS.

Thanks,
Joe

VS Vinoth Srinivasan Syncfusion Team November 4, 2019 06:24 AM UTC

Hi Joe, 
 
Please find the below highlighted code snippet for passing value to a parameter from client side in AngularJs. 
 
ReportSample.html 
   <body> 
 
        <div ng-controller="DialogCtrl" class="reportviewer" style="height:100%; width: 100%"> 
                    <label> 
                        CustomerID: 
                        <input type="text" name="CustomerID" ng-model="customerid" required ng-trim="false"> 
                    </label> 
                        <button id="button1" ej-button e-showroundedcorner="true" e-size="medium" e-text="Submit" e-click="onClick" style="height:20px;width:20px;top:10px"></button> 
                        <div id="container" ej-reportviewer e-reportserviceurl="reportServiceUrl" e-   processingmode="remoteMode" e-ajex e-isresponsive="true"       e-parameters="parameters" e-reportpath="rdlReportPath" e-locale="de-DE" style="width:100%;height:580px;"></div> 
        </div> 
            <script type="text/javascript"> 
                var parameters = [{ 
                    name: 'CustomerID', 
                    labels: ['29661'], 
                    values: [29661], 
                    nullable: false 
                }]; 
                 
                angular.module('syncApp', ['ejangular']).controller('DialogCtrl', function ($scope, $interval) { 
                    $scope.reportServiceUrl = '/api/ReportApi'; 
                    $scope.remoteMode = ej.ReportViewer.ProcessingMode.Remote; 
                    $scope.rdlReportPath = 'Region.rdl'; 
                    $scope.parameters = parameters; 
                    $scope.Submit = 'submit'; 
                                    }); 
            </script> 
</body> 
 
 
Regards, 
Vinoth S. 


JS Joe Samraj November 4, 2019 07:39 AM UTC

Hi Vinoth,


   Thank you so much for your help. It works for me.


Thanks,
Joe

VS Vinoth Srinivasan Syncfusion Team November 4, 2019 08:59 AM UTC

Hi Joe, 
 
Thanks for your update. Please let us know if you need further assistance on this. 
 
Regards, 
Vinoth S. 


Loader.
Up arrow icon