telerik reporting stored procedure trdx

[Que]

I want file trdx connect sql stored produre

 

 <DataSources>
    <SqlDataSource ConnectionString="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString" SelectCommand="SELECT InvoiceDetails FROM dbo.POS_Invoice WHERE LEN(InvoiceDetails) > 0" Name="sqlDataSource1" >
      <Parameters>
        <SqlDataSourceParameter DbType="String" Name="@CompanyId">
          <Value>
            <String>=Parameters.CompanyId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="String" Name="@BranchId">
          <Value>
            <String>=Parameters.BranchId.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>

 

thank a lot

[Stef]

Hello Que,

The SqlDataSource Wizard allows you to specify a connection string, save the connection string by name or hard-code it, and then you can use the 'Select Statement' or 'Stored Procedure' option as a data retrieval method.

If the stored procedure has parameters, the wizard will prompt you to map the SQL parameters to report parameters or other value. Then you will be asked for design-time values allowing the wizard to retrieve the data schema (available fields).


For more details, please check the steps in the SqlDataSource Wizard help article. The wizard starts automatically when you add a SqlDatasource component in the report, or if you select the component and 'Configure' from its Context Menu.


Let us know how it goes and if you need any further help.

Regards,
Stef
Telerik