We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Passing values to hidden paramater to SSRS report

Thread ID:

Created:

Updated:

Platform:

Replies:

148517 Oct 23,2019 12:09 PM UTC Nov 4,2019 08:59 AM UTC AngularJS 7
loading
Tags: ejReportViewer
Joe Samraj
Asked On October 23, 2019 12:09 PM UTC

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

Vinoth Srinivasan [Syncfusion]
Replied On 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. 


Joe Samraj
Replied On 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

Mahendran Shanmugam [Syncfusion]
Replied On 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. 


Joe Samraj
Replied On 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

Vinoth Srinivasan [Syncfusion]
Replied On 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. 


Joe Samraj
Replied On November 4, 2019 07:39 AM UTC

Hi Vinoth,


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


Thanks,
Joe

Vinoth Srinivasan [Syncfusion]
Replied On 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. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon