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 :
from SP
from Telerik Report Design app
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
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.
Rank 1
Iron
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.
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