Telerik report designer using store procedure return multiple data sets how to access all data sets. report shows only top dataset result

1 Answer 32 Views
General Discussions HTML5Viewer Integration Performance Report Designer Report Management Report Viewer
Supriya
Top achievements
Rank 1
Iron
Supriya asked on 22 Feb 2024, 04:59 AM

We have started exploring Telerik report. at present we are using SSRS. in Telerik report we notice when using progress Telerik report designer i.e teleri standalone report designer app when we pass stored procedure as data source and that stored procedure returning more then one data set only Top 1 data set result will be visible in Telerik report designing app.

I am attaching screen short below :

  1. from SP enter image description here

  2. from Telerik Report Design app 

    1. enter image description here

    As can be seen from both above screen short Telerik Report design app shows only one dataset under Datasource1 whereas SP send two dataset.

    How can i get both dataset in Telerik report design ??  

1 Answer, 1 is accepted

Sort by
0
Momchil
Telerik team
answered on 26 Feb 2024, 01:27 PM

Hello Supriya,

Indeed, if an SQL query returns more than one data set, only the first one will be used (see Selecting Data with the SqlDataSource).

If you do not wish to split the stored procedure in two or write a new select query, you can set up an ObjectDataSource and choose the desired data set based on the DataMember property of the data source. An example of this can be found in the Binding ObjectDataSource to a DataSet article.

Additionally, the Connecting the ObjectDataSource component to a Data Source article describes how you can create such a data source and how to integrate it into various applications, such as your Standalone Report Designer.

I hope this helps

Kind Regards,
Momchil
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Supriya
Top achievements
Rank 1
Iron
commented on 12 Apr 2024, 04:00 PM

Thank you for your response.  where i can get the details of .TRDX and .TRD files.   what is the difference between them. i had tried sample in . TRDP could not open in xml or any notepad.  only file was opening in Telerik report design.

i have full knowledge about SSRS. RDLC and RDL files. RDLC we normally edit in XML like for accessing more that one dataset in the form of

 <DataSet Name="LabelCaption">
      <Query>

so on

 

i wanted to know if similar holds good for .TRDX or .TRDP files.   

Momchil
Telerik team
commented on 15 Apr 2024, 02:15 PM

Hello Supriya,

The .TRDX report definitions are plain text files with XML content while the .TRDP definitions are ZIP archives containing the XML report definition and its resources (see Declarative Types).

You can use any text editor to edit the .TRDX definitions and a file archiver to edit the .TRDP reports but we do not recommend doing this.

If making changes to the reports outside of the report designer is mandatory, I would suggest using our programmatic API instead. For example, you can unpackage a .TRDP report, make the desired changes to the report object that is created, and package the report back to .TRDP.

Regards,
Momchil

Tags
General Discussions HTML5Viewer Integration Performance Report Designer Report Management Report Viewer
Asked by
Supriya
Top achievements
Rank 1
Iron
Answers by
Momchil
Telerik team
Share this question
or