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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Binding data source to rdlc report

Thread ID:

Created:

Updated:

Platform:

Replies:

124706 Jun 23,2016 09:36 PM UTC Jul 4,2016 10:07 AM UTC ASP.NET MVC 5
loading
Tags: ReportViewer
Anas Alwindawee
Asked On June 23, 2016 09:36 PM UTC

Hello

I have made a sample web application with sample creator, my application consist of a report viewer, I also have a rdlc report which contain charts.

My questions are:

1. is it OK to create the reports and there data sets with report wizard, if so how then to bind the data to the report viewer where my data source is sql server database.

2. How to query the database with parameters ?

* I could not found a good documentation regard reports data source.

Thanks in advance.



Yuvaraj Devarajan [Syncfusion]
Replied On June 24, 2016 01:26 PM UTC

Hi Anas, 
 
Thanks for contacting Syncfusion support. 
 
If RDLC Report, we can achieve your requirement to specify the filter to Data Set or Data Region as shown in below screenshot,  
 
 
 
We have prepared a RDLC sample based on this and it can be downloaded from below location, 
 
Please refer the below screenshot more details on this, 
 
If RDL Report, we can use the query parameter to filter the report data as shown in below screenshot. 

ReportBuilder: 
 

We have prepared the sample and it can be downloaded from below location, 
 
Please refer the below MSDN article more detail about Query Parameter. 
 
Regards, 
Yuvaraj D. 


Anas Alwindawee
Replied On June 30, 2016 06:32 AM UTC

Hello Yuvaraj,

Many thanks for your help, I managed to make it work.

Just I have another issue, that is the chart in report viewer draw all the points at one point on date axis as shown in below image, I tried with settings of chart axis but no thing change, could you please help.



Yuvaraj Devarajan [Syncfusion]
Replied On July 1, 2016 06:23 AM UTC

Hi Anas, 
 
We are unable to replicate the mentioned issue at our end. The series group and category group axis are working fine at our end. We have prepared a sample using chart report items and it can be downloaded from the below location,   
 
Please refer to the below output rendered screenshot:   
 

If the issue still persists, then share the issue reproducible ReportDefinition (RDLC) file with data to validate the mentioned issue at our end.   
 
Regards, 
Yuvaraj D. 


Anas Alwindawee
Replied On July 3, 2016 09:52 PM UTC

Hello Yuvaraj,

Many thanks for your kind support, the problem solved after I changed the date format, may be it's interesting that the report viewer does not handle the date when it's delimiter is "-", after I changed the delimiter to "/" it worked properly.

BR



Yuvaraj Devarajan [Syncfusion]
Replied On July 4, 2016 10:07 AM UTC

Hi Anas,   
 
We are unable to reproduce the mentioned date format issue at our end. The mentioned issue might have occurred due to internally failed to process the DateTime type in our Chart Engine. So, share the below information to replicate the mentioned issue at our end.   
1.            Confirm your product version   
2.            Share the Machine culture and Browser culture.   
3.            Share the reproducible RDL report definition with data.   
   
Regards,   
Yuvaraj D.   


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.

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

;