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

Running report created in Report Designer

10 Answers 331 Views

General Discussions

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

Andre asked on 23 Jul 2013, 01:33 PM

I read the help and also some threads here on the forum, and even then, you can run a report type trdx, no user data source SQL Server and such.
Now my question is, fom customize a report data from a SQL Server data source and call the application through some filters.

In short: I have not seen anywhere here on the site of how to call a report that has its data from a data source, the opening of the report doing some filter data and also now enjoying the DataSource application to why my application is WPF Desktop then the DataSource changes from customer to customer.
With this piece of code could run a report from the folder is located.

XAML
                xmlns:tr="http://schemas.telerik.com/wpf" x:Class="RadControlsWpfApp1.MainWindow"
               Title="MainWindow" Height="350" Width="525">
    <Grid>
        <tr:ReportViewer x:Name="reportViewer1"/>
    </Grid>

C#
            var report = new UriReportSource();
            report.Uri = System.IO.Path.Combine(Environment.CurrentDirectory, "Barcodes Report.trdx");
            //report.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumber", "SO43659"));
            this.reportViewer1.ReportSource = report;

And now how to filter?

is possible for a demo or example a video explaining about, we urgently need our system to pass the work with telerik report.
I thank you.

graciously
André

10 Answers, 1 is accepted

answered on 29 Jul 2013, 08:39 PM

I was looking up watching the videos and reading the help, but we have not succeeded in implementing the project, we catched a little to release a new version of the system and we were not managing to implement the components of Telerik, I know that as time goes by we'll familiarize better with the functions of the components, but now we need help from you to pass on more specific stuff.

We are not knowing how to work with Report Designer using data from DBMS and use UriReportSource already informing the data source to the ODBC connection string and also through some filters to select data to be displayed on the screen!

answered on 01 Aug 2013, 03:10 PM

Hi Andre,

A step-by-step guide on how to connect to ODBC DataBases can be found here: How to: Connect to an ODBC Database. This approach is for both for the VS and the Standalone designer.
As to the UriReportSoruce, what exactly do you mean by "use UriReportSource already informing the data source to the ODBC connection string"? The UriReportSource needs to be assigned to the viewer's ReportSource property and if the Uri property is set correctly, the report will be displayed without any further interactions.
About the filtering, can you be more specific what and how do you need filtered?
If you mean static filtering for each report, than it is best to apply filters to the DataSource (when selecting the data). You can also use the report filters or table filters (if you use tables). Fore more info see Filtering Data.
If you need dynamic filtering, performed by the end-user, there isn't a provided functionality for such a scenario. However, you can check the following discussions:

In order to advise you accordingly, please give us more information on your DataSouce, data structure, desired functionality and report layout, etc..

Regards,
Elian
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

answered on 20 Sep 2013, 09:09 AM

ViewReportTelerik.zip

Hello Andre,

In order to display Report Designer files (.trdx) in a WPF viewer please follow the steps in the How to: Add report viewer to a WPF application help article.

I modified your project to display a simple .trdx report inside the ShowViewReport window. You can see it in the attached file.

Regards,
Nasko
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

answered on 20 Sep 2013, 11:45 AM

Sem-t-tulo.jpg

Sem-t-tulo1.jpg

Hello, first I want to apologize for everything.

Face the demo example is very good, but as I sent some files for you to analyze and be able to understand our reality, was awaiting a report. Trdx showing data from a database if the database would also sent to you.

Now I'm trying to display data from a database in the report by the WPF application is not occurring errors.

If not too encomodo and you can be more specific in the demo example and add some linking of data from SQL Server.

graciously
André

answered on 25 Sep 2013, 10:53 AM

Hello Andre,

You need to copy the connection string you are using in the .trdx report to your App.config file in the WPF application. You can find the connection string inside Telerik.ReportDesigner.exe.config which is located right next to the Telerik.ReportDesigner.exe file.

For example, if you are using the AdventureWorks database add the following to the App.config:

<connectionStrings>

<add name="AdventureWorks"

connectionString="Data Source=(local);Initial Catalog=AdventureWorks;Integrated Security=SSPI"

providerName="System.Data.SqlClient" />

</connectionStrings>

where you should specify the correct Data Source, Initial Catalog and Integrated Security if yours are different.

Regards,
Nasko
Telerik

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.