Is it possible custom query dynamically to get reports?

[handoyo]

Hi,

Is it possible to use custom query dynamically to get custom reports? Outside the designer. Thanks

[Vinoth Srinivasan]

Hi Handoyo, 

 

Thanks for contacting Syncfusion Support. 

 

If your requirement is to update or modify the dataset query and populate the data for report, then you can use expression in dataset query or use parameter value as input to the dataset command text. Also dataset tag in report file can be edited at code behind as given in the below knowledge base. 

 

https://www.syncfusion.com/kb/7083/how-to-edit-a-report-at-runtime 

 

If we have misunderstood your requirement, please share more details on your requirement. 

 

Regards, 

Vinoth S. 

[handoyo]

Hi, my first mistake was not saying that i'm intending to use the report in WinForm. Seems likely the report doesn't work on WinForm isn't it?

[Vinoth Srinivasan]

Hi Handoyo, 

Currently, our reporting control is not available in WindowsForms platform. However, you can use WPF reporting control in Windows Forms using ElementHost control. We have prepared a sample to render reports in reporting control and it can be downloaded from the following location. 

http://www.syncfusion.com/downloads/support/directtrac/130249/ze/ReportViewerWF_(2)-29985739 

Refer to the below MSDN link for more details on Element Host control.
https://msdn.microsoft.com/en-us/library/system.windows.forms.integration.elementhost(v=vs.110).aspx 

Regards, 

Vinoth S. 

[handoyo]

Thanks for the sample. I will look at it.

[Vinoth Srinivasan]

Hi Handoyo, 

Thanks for your update. We will wait to hear from you. 

Regards, 

Vinoth S.