Hi, 

I am trying to show multiple reports in a reportbook object in WPF

However , I do not get any ReportSources Collection on my reportbook object , only the reports collection.    When I try to use report instead of TypeReportSource it tells me Report is obsolete and I must use ReportSource .  I have a standard WPF window, with a reportviewer object but now I want to use a reportbook object to show multiple reports.

var reportViewerWnd = new ReportBookViewerWnd();
            var report = new Telerik.Reporting.Report();

            var reportBook = new Telerik.Reporting.ReportBook();

            var typeReportSource = new Telerik.Reporting.TypeReportSource();
            typeReportSource.TypeName = "Schedwin.Reports.Tickets.PassengerTickets, Schedwin.Reports.Telerik";
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("ReservationIDX", ReservationIDX));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("ReservationName", ReservationName));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("PaxName", PaxName));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("TicketNo", TicketNo));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("IssuedBy", IssuedBy));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("IssuedDate", IssueDate));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("IssuePlace", IssuePlace));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("RegionalDBName", DatabaseName));
       
   

            reportBook.Reports.Add(typeReportSource);

            reportViewerWnd.ReportViewer.ReportSource = reportBook;
            reportViewerWnd.Title = "Passenger Ticket";

Hi..

How do you set a subreports ReportSource to a List<>?

 public List<uspGet_POs_DETResult> po_det { set; get; }

this.subReportDetail.ReportSource = po_det;

SeverityCodeDescriptionProjectFileLineSuppression State
ErrorCS0029Cannot implicitly convert type 'System.Collections.Generic.List<uspGet_POs_DETResult>' to 'Telerik.Reporting.ReportSource'

I have installed visual studio 2015 as well as the telerik reporting which is correctly detecting that I have VS2015.  In VS2015 there is no telerik menu and there is no item template for creating a new report . 

Please help

No matter what I do I am unable to create a SQLDataSource.

I am using the latest Telerik Reporting Framework.

It creates a connection string and the string it creates is correct and it adds it to the App.Config.

It says connection succeeded when I test the connection.

However it says:

Unable to create SQLDataSource check your connection string.

Now, I realize that most development companies have a default message to show customers when the real error was too hard to actually program because most developers fear custom exceptions.

But in this case, the wizard just errors out and creates the Setting correctly and then doesn't create the sql data source.

Now here's how to reproduce it because I know if I don't tell you how to reproduce it you will take many days to get back to me.

1) Install Telerik Reporting Trial by itself no other features via the MSI.

2) Next Create a Standard .NET Class Library in .NET 4.7.2

3) Create The project name as NameOfTheApp.Reports

4) Create a folder called Reports

5) Create an empty app.config in the class library at the root of the class library project

6) Right click the Reports folder and Add New Item

7) Select Telerik Report Wizard
8) Select Table Template

9) From the Project or Current Data Sources Create A New SQLDataSource With Type Microsoft SQL Server Connection Type And Use 

Windows Or Sql Username/Password Authentication, Select A Database With Stored Procedures. 

10) Select Stored Procedure With A Mix Of DateTime and Other Parameters

11) Pass in 2018-07-05 or a date into the date field which would work in an actual query

12) No rows will return no matter what you do

13) Click Finish, and the result will be that there will be an error message complaining about the connection string being incorrect.

14) Even though the connection string is correct and Test Connection works, the datasource is not created, the report is not created and the String is added to the app.config and the settings. 

What is the real error?

Hello,

I am very new to Telerik Reporting and I have downloaded the trial version of it to see if Telerik reporting is able to fulfill the reporting requirements.

Before, I have been using SSRS to generate the reports but I faced some issues and bugs that made me look for other options out there. I have some reports that have quite a complex logic in generating the data that is going to be used on the report. With RDLC, I had created some dataset that would serve as data source for the report and afterwards, I would fill the data on these datasets from code. Moreover, I used to create some partial views that were used for keeping custom parameters. I did not use any parameters on RDLC report, but instead, I would fill the datasets with already filtered data because in this way I keep the logic of data that should be displayed more under control.

What would be the way how to implement the same with Telerik reporting? I mean, can I somehow interfere on the logic how the data are filtered on the report, or maybe use the same approach as I was using with RDLC? I.e., I use some custom parameters via the partial views that I have already created and using these values, I fill the datasets which will serve as data source to the reports? In this way I would not use the filters of Telerik reporting.

To add some complexity logic to this, I have a report which uses two data sources which are basically two datatables of the same dataset. One data source will be used on the header of the report, meanwhile the second one will be used on the details section of the reports. So I will need to apply the filtering on both datasources.

I tried to find some solutions to my case, but I am just not sure what would the best approach...

Thanks a lot

Hi friends;

I created pie and bar charts. But I have a problem. I need send report parameters to these charts dynamically and update my charts. How can I do that inside the report designer ? Thanks for help.

Dear Telerik Team,

What I've noticed is that during rendering the Report generator doesn't (maybe for some elements only, at least DataTables) check the property Visible when planning paper length for reports in Preview and this Bug is producing the next behavior:-

For example, there is a data table with property Visible set in true in Designer code, but during the report generation, if the database query for that table gets back with Rows.Count = 0 and inside your code you set this property Visible = false (because you don't like to fill the doc with extra empty tables), and there are many such blocks inside your report, then it could be resulted to an extra blank page at the end..
I don't know how your render works exactly, but I understand it must check for some absolute locations of elements/blocks and then reserve the amount of paper sheets,
In my case, there are no blocks with absolute location.. the report should be printing as soon as a new Visible element is coming up to the entry of Renderer, so elements are populating with data and getting value for property Visible before they're rendered..

But Reporter anyway adds an extra page if it was there during the Preview Mode.
My suggestion is:
Maybe there is the reason to add a new property to a Report = say, Report.RenderStrategy = [Common] | [Dynamic] and change the strategy of rendering without planning the minimum of paper before rendering?
=====================
Sorry, if I was unclear, but I am not the Writer :) Hopefully I described the situation pretty clear for developers of the Report Component?

Hi to all,
I'm trying to create a solution console that it has generate a XLSX file from my report.
I'm using this code, it gives me an error "XLSX rendering format is not available." when execute reportProcessor.RenderReport()

I have already add these dll:
DocumentFormat.OpenXml version 2.8.1
Telerik.Reporting
Telerik.Reporting.OpenXmlRendering.2.7.2.dll
And added a bindingRedirect in the application configuration file for the DocumentFormat.OpenXml.dll assembly.

Also, i set CopyLocal property must be set to True to make sure that the proper DocumentFormat.OpenXml.dll is copied in the project's Bin folder.

Hi,

Imagine the following data where the xVal just contains month start dates (1 jan, 1 feb, etc) and then give it this sample data:

select convert(datetime, '1 mar 2018') as xVal, 1 as yVal, 'a' as seriesGrouping

Try to place that in a bar graph so that there is a series per seriesGrouping, the x/y set as per the column names and get it to show the month of March on the x axis.  With just one data point on the x axis the autoscaling seems to think that we want 1 label per year and shows January.  When the data set has multiple months then its fine and you get labels for each month that you have data.  Is there a way to set up the x axis so that it works for the single month case, maybe with binding?