This is a migrated thread and some comments may be shown as answers.

How to call user defined function from mssql into a report

1 Answer 239 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Patricia
Top achievements
Rank 1
Patricia asked on 07 Jul 2009, 03:21 AM
Hi there,

Currently im trying on your reporting tool. I have few questions to ask.

Description:

  1.  Type of project           :  web site application
  2.  Used language           :  (C#)

3.    OS                             :  xp pro service pack 3

       Tools/product            :   Telerik reporting version 2009.2 701 (Jul 1, 2009) 

        Web Viewer version  : 3.0.9.430

 

 

 

i would to know how to call user defined function from mssql to be displayed in a report. Pls provide me an example/documentation regarding this issue. One more thing, im using automatic ui parameterized feature to filter data ( which prompt user input ), i want to use more than one parameter to filter data. When i just tried to add more parameter it failed to work but working well with one parameter. How to address this problem?    Since im working with web application, when i want run the project thru localhost, the page is empty (no data displayed) but i could preview the report. How to solve this portion.

Thank You

Your guidance is much appreciated

Regards

Pat

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 09 Jul 2009, 03:56 PM
Hello Patricia,

We're not sure we understand properly your inquiry - you're talking about SQL user defined functions and not Telerik Reporting user defined functions, correct?
If so, please note that Telerik Reporting does not provide its own data layer but depends on the existing .NET objects (DataSet, Data Table, DataView, ADO.NET, lists - for more information on report data binding, please, refer to this help topic). In this line of thoughts, it is neither aware where the data comes from, nor does it matter to it and preparing the data for the report binding is up to the developer.
Also have in mind that Telerik Reports are standard .NET classes, so anything you can do with them is applicable for our reports as well. You can review this article as a starting point.
As for your second inquiry - please elaborate what is not working. Do you receive any errors? Any additional information you could provide would be highly appreciated.

Greetings,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
General Discussions
Asked by
Patricia
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or