1. Home
  2. Forum
  3. Report Platform
  4. Report parameters not working
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Report parameters not working

Hi,

I'm using JavaScript report viewer control with RDL in App_Data directory. 

Here is exact code snippet I'm using:

 <script type="text/javascript">
        $(function () {
            $("#viewer").ejReportViewer({
                reportServiceUrl: "/api/ReportApi",
                reportPath: '~/App_Data/usertxn.rdl',
                parameters: [{
                    name: 'userId',
                    labels: ['userId'],
                    values: ['3'],
                    nullable: false
                },
                {
                    name: 'dateFrom',
                    labels: ['dateFrom'],
                    values: ['2018-06-01'],
                    nullable: false
                },
                {
                    name: 'dateTo',
                    labels: ['dateTo'],
                    values: ['2018-06-21'],
                    nullable: false
                }]
            });
        });
    </script>

Here is WHERE condition in command text:

 where booking.user_id = @userId and  booking.booking_datetime &gt;= @dateFrom and booking.booking_datetime &lt;= @dateTo and booking.booking_status = 2

If I pass value directly and load report, there is no error but passing values from parameter doesn't yield any result. 

In report designer, If i pass values using visible parameters then also there is no issue. 

Please help.

Thanks & Regards,
Madan G.




1 Reply
MS Mahendran Shanmugam Syncfusion Team June 22, 2018 09:39 AM UTC

Hi Madan, 

Thanks for contacting Syncfusion support. 

We have checked the mentioned problem with your shared details and the report is rendered properly when we set the default parameter in client side at our end. For your reference, we have prepared the sample and could you please confirm whether the sample is working properly at your end, which can be downloaded from below location.   

Output snap: 
 

If the issue still persists, then revert the shared sample with issue reproducible procedure or issue reproducible RDL file to validate the mentioned problem at our end. 

Regards, 
Mahendran S. 


Loader.
Up arrow icon