Hello, I have report parameter and I dynamically change the data source in available values, then I'd like to pick the first value (it could be various) as default. How can I implement this since the attribute ReportParameters["proc"].Value just accept an object?

Is the only option to query the data manually from code and then send first item?

Thank you for your attention!

We have a report created with several CSV data sources. In one CSV data source there are two rows by default, but in the we only need the first row only. We cannot change the CSV data source because it is generated by a separate application. Is selecting only first row only to appear in the report can be done by the designer is this feature does not yet supported by it. 

 

Thank you. 

Hi, I have a question! ¿What happened after the 30 days trial ends? ¿If I already compile a solution those controls keep working normally or they have a kind of error after that?

Hi All,

We have experienced some issues with Telerik reporting service tool and that the logs are given below.

{"message":"","exceptionMessage":"Client with ID '044210-0ccb' not found. Expired.","exceptionType":"Telerik.Reporting.Services.Engine.InvalidClientException","stackTrace":"   at Telerik.Reporting.Services.Engine.PersistableCollection`1.get_Item(String itemID)\r\n   at Telerik.Reporting.Services.Engine.ReportEngine.TouchClient(String clientID)\r\n   at Telerik.Reporting.Services.Engine.ReportEngine.CreateReportInstance(String clientID, String report, Dictionary`2 parameterValues)\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.CreateInstance(String clientID, ClientReportSource reportSource)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}

Can you please check this as soon as possible and provide your inputs to get it resolved.

Here's a video showing that. I'm using the integrated reporter from Visual Studio.

I was tasked with prototyping a new Telerik report using version 2018 R3 SP1 in Visual Studio 2017. I've searched the forum and the web but so far have not found a definitive answer to this question.

The report is somewhat complicated, with several sections, but the main section was best implemented as a banded report with a Graph in the detail section. Our existing reports use ObjectDataSource objects for the DataSource and this new report will follow suit. I tried passing the banded report a C# List<PrototypeItem> instance where the classes are:

public class PrototypeItem
{
public int Id { get; set; }
public string Location { get; set; }
public string Name { get; set; }
public string Type { get; set; }
public List<NumItem> Items { get; set; }
}

public class NumItem
{
public DateTime X { get; set; }
public double Y { get; set; }
}

PrototypeItem.Id is used as the group property (= Fields.Id) to distinguish the report bands. I found I could create a DataSource binding for the detail Graph, which I set to = Fields.Items. I set the Graph to have a LineSeries linked to a CartesianCoordinateSystem, a SeriesGroup and a CategoryGroup. The latter group I set to have Groupings = Fields.X and Sortings = Fields.X Asc expressions. The series had X = Fields.X and Y = Fields.Y.

When I run the report, it appears to give me the information I expect, with individual graphs having the X/Y data for the Id item in each band.

What I would like to do now is extend this report to provide more information in the graphs. In particular, I am interested in adding a straight horizontal line (possibly several) at a value that indicates to the user when the X/Y data has exceeded a certain "alert" level. However, I can't figure out how best to do this.

One approach I tried and found to work (albeit with limitations) was to add a another property to the NumItem class to define the "alert level". I added a second LineSeries to the Graph, linked it to the same category and series groups and defined the series X = Fields.X and Y = Fields.AlertLevel. The problem I have with this approach is that the horizontal line does not span the graph's entire X range if the main graph data does not also do so. I found that I could add two data points to the Items data list, one for the start date and another for the end date. While the alert level line spans the graph, unfortunately, this also introduces odd discontinuities in the raw data line between the end points of the graph and the first or last data points.

Ideally, it would be best to pass two line series, one for the raw X/Y data and a second for the alert level with just two data points: start date and end date as X values and the Y values as the alert level. I cannot determine if reporting supports this sort of operation. The main problem involves the DataSource binding for the Graph. How would one define classes to and set properties to make the Graph object "aware" of two (or more) line series?

I attempted one modification to my classes above. I changed PrototypeItem to replace List<NumItem> with a GraphData class property where:

 public class GraphData { List<NumItem> Items { get; set; } }

and changed the Graph binding expression to be = GD.Items (instead of = Items). When I ran the report this "sort of" worked but behaved strangely: each graph displayed a data line but all the graphs were identical (rather than the individual data for each Id). This also gave no indication how to bind a second List of NumItems in GraphData to a second line series.

I also occurred to me that I could try to create a separate report ObjectDataSource to retrieve the Graph data. However, I could not determine how to link the banded property Id to the function call so I did not attempt this.

Any thoughts about how to extend my report graphs?

Thanks.

I am currently using Report designer R2 2018. We have a table which spans across multiple pages. But at the end of each page, we can see left and right border printed even when there is no data. (shown in the image). Is this a normal behavior is this something we are doing wrong while designing the report? 

Hi,

We have a winform application which used telerik to show few reports.

When we try to view the reports with 150% scaling the reports are all skewed to the left with huge white spaces to the right.

One solution we found is to make our application DPI aware, that seems to fix the report issues but since our application is not built for scaling we cannot make it DPI aware without huge re writes!

Is there a way to fix with without making our application DPI aware?

Hello.

I am trying to dynamically create a report, without any designer, just c# code. I am using instance report source with a report document, to which i add items on the fly, based on a custom report definition containing the user required report format (columns, rows, sorting, etc). 

No matter what i do, the final report gets rendered on pdf with an empty page. The problem is that with the same report items, i am getting results when using visual studio designer. I am referring to teleric report examples in C# (ListBoundReport). I have modified the designers class report items to just include a singe section with a table having one column and row. The output in the designer preview is an empty table having only visible borders.

I have copied the report items from the above example in my reporting library implementation. The difference is that the items are constructed in a custom builder class instead of the report item constructor as in your example. The outcome is a pdf with no visible table. 

I can post the builder class that creates the report items, but it has a lot of custom information that will get you confused. Instead, i will post the modified code from the designer file in your example. I can attach my builder class code, as well, if needed.

Please let me know what i am doing wrong because i have created a whole infrastructure in the idea of creating on the fly reports based on some user configuration.

Hi All,

I have a date field in my sql query.

I want to create a report in which i want to show Current year(2016) and previous year(2015) data only.In the same way i want to show current month and previous month data.

 

So can someone tell me how i can convert my date to current year and the previous year or current nonth and previous year.

 

I am using Standalone report designer.

 

Thanks,

 

Narender